Online CSV Editor

How to edit a CSV file online?

1. Open your CSV file with the Open file button above the table, or drop the file on the table. The separator (comma, semicolon, tab, ...) is detected. An Excel workbook (.xlsx) opens too: choose one of its sheets, and save it as CSV with Download CSV. You can also paste cells copied from a spreadsheet (click a cell and press Ctrl+V) or start with an empty table (File / New table).
2. Edit the data: click a cell and type to replace its text, or double click it (or press Enter) to change the text that is there; Esc or a click elsewhere ends the edit. Tab and the arrow keys move between cells. Add, remove and move rows and columns with the Row and Column menus or the context menu (right click), find and replace text with Edit / Find and replace, and undo with Ctrl+Z.
3. Choose the separator, quoting and line ends in the options under the result, and download the file -- or copy the CSV text to the clipboard.

Your file stays on your computer

The file is read and written by your browser: it is not sent to our server. With Edit / Autosave table locally the table is kept in your browser, so you can close the page and come back to it.

CSV files and Excel

CSV (comma-separated values) has no single standard: Excel in countries that write decimal numbers with a comma (e.g. 3,14) separates fields with a semicolon, and some programs use tabs. A file you open is downloaded with its own separator and line ends unless you choose others. A field that contains the separator, a quote or a line break is put in quotes ("a ""quoted"" word"), as RFC 4180 says.

To have Excel show accented letters and other non-English characters correctly, keep Byte order mark (for Excel) on: without it Excel reads the file in an older encoding.

A CSV file holds only text: it has no formatting and no merged cells, so the CSV editor has none either. To make a formatted table from your data, open the file on one of the other pages, e.g. the HTML or LaTeX tables generator.