iformat.io Logo iformat.io
iformat.io Logo iformat.io

Free CSV Viewer & Editor

Open, view, sort, filter, and edit CSV files right in your browser. No Excel or Google Sheets needed — everything stays private on your device.

CSV isn't as simple as it looks

"Comma‑separated values" is loosely standardized by RFC 4180, but half the files you'll open won't follow it. The three landmines to watch for: fields containing the delimiter (a name field with "Doe, Jane" must be quoted or the row splits into an extra column); embedded newlines inside quoted fields (an address across two lines is legal but breaks any parser that splits on newlines first); and escaped quotes — the RFC says a literal " inside a quoted field is written as "", but plenty of exports use backslash‑escape instead. The viewer parses using a state machine that handles all three, so you don't get phantom columns.

Regional Excel adds its own layer. On Windows systems set to a German or French locale, Excel exports use semicolons as the separator because the comma is the decimal mark. Files created there don't look like CSV to a US‑locale Excel — same bytes, different render. The viewer auto‑detects by sampling the first few rows and picking whichever separator produces a consistent column count. You can force a delimiter if the guess is wrong.

Encoding is the other quiet problem: UTF‑8 without a BOM opens fine in Numbers and text editors but shows mojibake in Excel unless the BOM is present. Files that look correct on Mac and broken on Windows are almost always this. If your data has accented characters, save with the BOM.

Frequently Asked Questions

How do I open a CSV file without Excel or Google Sheets?

Upload your CSV file to this tool or paste the raw text directly into the text area. The file is parsed entirely in your browser and displayed as an interactive table. No software installation, no account sign-up, and no data leaves your device.

Can I edit cells directly in the table?

Yes. Click any cell to switch it to edit mode. Type your new value, then press Enter or click outside the cell to save. All edits stay in memory until you download the updated CSV, so you can make as many changes as you like before exporting.

How do I sort and filter the data?

Click any column header to sort the table by that column. Click again to reverse the sort order. Use the search box in the toolbar to filter rows — it matches across all columns simultaneously, showing only rows that contain your search term.

Can this tool handle large CSV files?

The tool paginates data at 100 rows per page to keep the browser responsive. Files with tens of thousands of rows work well. Very large files (over 50 MB) may be slower depending on your device's memory and processing power.

How do I export or download the edited CSV?

Click the Download CSV button in the toolbar. The exported file reflects all your edits, added rows, and deleted rows. The download uses comma as the delimiter and properly quotes fields that contain commas or newlines.

What delimiters are supported?

The tool supports comma, semicolon, tab, and pipe delimiters. By default it auto-detects the delimiter by analyzing the first few lines of your file. You can also select a specific delimiter from the dropdown before loading the data.

Is my data private and secure?

All processing happens entirely in your browser. Your CSV file is never uploaded to any server. This makes the tool safe for confidential data, financial records, customer lists, and any other sensitive information.

Can I add or delete rows?

Yes. Use the Add Row button to append a blank row at the bottom of the table. To delete rows, check the selection boxes on the rows you want to remove, then click Delete Selected. Both operations are reflected in the downloaded CSV.
Reviewed by Editorial team Updated