How do I open a CSV without Excel?

Select the file in Elegant File Explorer and the preview panel shows it as a table — no program launched. Press Space with the file selected for a quick peek, or just click it to load the preview beside the list. It reads CSV and TSV files and renders them as a proper table with a header row, so you can check the file at a glance without opening Excel.

It's a European CSV that uses semicolons — will it read correctly?

Yes. The preview detects the separator automatically by testing commas, semicolons, tabs and pipes and picking the one that lines the rows up consistently. A semicolon-separated file shows up as a clean table just like a comma one, and a small badge tells you which separator it used (“CSV · separator ; · N rows”). No settings to change.

Can I edit the CSV in the preview?

No — the preview is for reading, not editing. It shows the file as a table so you can check what’s in it without launching a heavier program (and without the risk of a spreadsheet silently reformatting your data). When you actually need to change cells, that’s a job for a spreadsheet editor.

Will it open a huge CSV with hundreds of thousands of rows?

The preview reads a portion from the start and shows up to the first 200 rows and 30 columns, noting when it’s showing only the first rows. It’s built to be instant for a quick look, not to load an entire massive dataset — for that, a full spreadsheet tool is the right choice. For the everyday “what’s in this file?”, the preview handles it in a click.

Does previewing the file change it or send it anywhere?

No. The preview only reads the file to display it, never modifies it, and doesn’t lock it — you can still move, rename or delete the CSV while previewing. And like the rest of the app, it runs entirely on your PC; nothing about the file is uploaded anywhere. Available now on the Microsoft Store.

Open a CSV without Excel: preview it as a table

You get a .csv file — an export from your bank, a report from some web app, a contact list someone sent over — and all you want is a quick look. Is this the right file? How many rows? What are the columns called? Simple questions. And yet the moment you double-click, one of two annoying things happens.

Either Excel lurches to life — a heavy program spinning up for ten seconds just so you can glance at forty rows — and sometimes it even mangles the file on the way in, turning 007 into 7 or a date into something nonsensical. Or, if Excel isn’t the default, the file opens in Notepad as a wall of raw text: every value crammed together with commas or semicolons between them, columns invisible, completely unreadable past the first line.

Neither is what you wanted. You didn’t want to edit the spreadsheet. You just wanted to see it. This guide is about doing exactly that — reading a CSV as a proper table, instantly, without launching Excel or squinting at raw text.

Why CSV files are awkward to just look at#

A CSV — “comma-separated values” — is about the simplest data format there is: rows of text, with a separator between the fields. That simplicity is its strength (anything can read it) and its curse (nothing agrees on the details).

The biggest gotcha is the separator itself. Despite the name, plenty of “CSV” files don’t use commas at all. In much of Europe, where the comma is the decimal mark, exports use a semicolon instead. Others use a tab (that’s what a .tsv file is) or a pipe character. So a tool that blindly splits on commas will show a European file as one useless column, and raw text hides the structure completely. That’s the real reason a CSV is awkward to peek at: not the data, but the guesswork about how it’s laid out.

The preview panel: see the file without opening it#

Elegant File Explorer has a preview panel beside the file list, the same idea as Quick Look on a Mac. Click a file and the panel shows its contents — no program launched, nothing opened. Press the Space bar with a file selected and the preview pops open for a fast peek; press it again and it’s gone. It works for images, PDFs, Office documents — and, the point of this guide, for CSV and TSV files.

When you select a .csv or .tsv, the panel doesn’t dump raw text at you. It renders the file as an actual table: the first row treated as a header in bold, gentle zebra striping down the rows so your eye can track across, colours that match your light or dark theme. Columns line up. You can read it. And if the table is wider than the panel, it scrolls sideways inside its own card instead of breaking the layout.

All of it happens right there in the window where you were already browsing. No second app opens, and the whole thing runs 100% on your PC — nothing about the file is sent anywhere.

The separator, detected for you#

Here’s the part that quietly saves the most annoyance: you don’t tell it whether the file uses commas, semicolons, tabs or pipes. It figures that out on its own.

Before drawing the table, the app samples the top of the file and tests each candidate separator — comma, semicolon, tab, pipe — scoring them by how consistently each one splits the rows into the same number of fields. The right separator is the one that makes every line line up into the same number of columns; the wrong ones produce a ragged mess and score badly. A .tsv file gets a nudge toward tab, which breaks ties. It also respects quoted values properly, so a comma sitting inside a quoted field (“Smith, John”) is treated as content, not as a new column — the way a correct CSV reader should.

Once it’s decided, it tells you what it found. A small badge above the table reads something like “CSV · separator ; · 240 rows” — so you’re never guessing whether it read the file the way you expected. That semicolon file from your European bank? It just shows up as a clean table, no settings, no import wizard, no re-saving.

Built to stay fast and never choke#

A preview has one job — be instant — so there are sensible limits, and they’re worth knowing so nothing surprises you:

It reads up to a generous chunk from the start of the file and shows up to the first 200 rows and 30 columns. Past that, it notes that it’s showing the first N rows. A preview is for looking; if you genuinely need all million rows, that’s a job for a real spreadsheet tool, and the preview will say so.
It handles the common text encodings — it respects a UTF-8 or UTF-16 byte-order mark and falls back gracefully otherwise — so accented names and non-English text show correctly instead of turning into garbled symbols.
It never chokes on a messy file. If the CSV is malformed — a stray quote, a ragged row, half a line — the preview degrades gracefully and still shows you the rows it could read, rather than throwing an error and giving up. For a quick “what’s in here?”, that’s exactly the behaviour you want.
Opening the preview never locks the file, so you can still move, rename or delete that CSV while you’re looking at it.

Preview, not edit — and that’s the point#

One honest boundary: this is a preview, not an editor. You’re reading the CSV as a table, not changing cells in it. That’s deliberate — the whole value is answering “is this the right file, and what’s in it?” in a single click, without the weight and the risk of opening the file in something that might silently reformat it. When you actually need to edit the data, that’s when a spreadsheet program earns its keep; for everything up to that point — the constant little “let me just check this file” — the preview is faster and safer.

And because it lives in the same panel as every other preview, a CSV sits right alongside your PDFs and images. If your day involves a lot of “let me just glance at this file before I deal with it”, it’s worth knowing the panel does the same trick for searching text inside PDFs — the same instinct of seeing what’s in a file without the ceremony of opening it.