CSV EDITOR

Which Keys Work in the Grid?

• Double-click a cell, or select it and start typing, to edit.
• Enter saves the value and moves down a row.
• Tab saves and moves right.
• Escape cancels the edit.
• Delete empties the selected cell.
• Double-click a header to rename the column.

Rows are selected by clicking their row numbers, with Shift-click to select a range. The arrow in each header sorts the table by that column. The grid is virtualized, so editing stays quick even in a file with a million rows.

How Do You Change Rows and Columns?

1. Add a row at the top, at the bottom, or above the selected row.
2. Select rows and delete them.
3. Add a new column after a column you choose.
4. Rename a column, move it left or right, or delete it.

Each change can be undone, for the last five changes, and Reset to original returns to the file as first read. If you try to close the tab with unsaved changes, the browser asks before leaving.

Is a CSV Editor the Same as a Spreadsheet?

No. A CSV editor works on plain values, so there are no formulas, formatting, or multiple sheets, and nothing is saved inside the file except the text. That is often what you want when a file is headed for an import: a spreadsheet can quietly change ZIP codes such as 00501, long IDs, and dates when it opens a CSV.

The editor keeps every value as the text it is. When you export a CSV that will later be opened in a spreadsheet, the optional formula protection puts an apostrophe before cells starting with = + - or @ so they are not run as formulas, while plain numbers such as -5 are left alone.

What Else Can You Do With a CSV Here?

• CSV viewer: Open a CSV of any size, scroll every row, and see a profile of each column.
• Sort CSV: Sort rows by one or more columns, as text, numbers, or dates, ascending or descending.
• Filter CSV: Show only the rows that match an expression such as price > 10 AND state = "NY".
• CSV validator: Find ragged rows, broken quotes, bad headers, encoding problems, and values of the wrong type.
• Remove duplicates from CSV: Find and remove duplicate rows, comparing whole rows or only the columns you choose.
• Trim CSV whitespace: Trim leading and trailing spaces, collapse double spaces, and drop invisible characters and empty rows.
• Find and replace in CSV: Find text in one column or every column and replace it, with match case, whole cell, and regex options.
• Remove rows from CSV: Delete rows by number or range, the first or last rows, empty rows, or rows that match a rule.
• Split CSV column: Split one column into several at a delimiter, such as a full name into first and last.
• Merge CSV columns: Join two or more columns into one with the separator you choose, skipping empty values.
• CSV column type converter: Convert a column to clean numbers, ISO dates, true/false, or upper, lower, or title case.
• CSV to JSON converter: Convert CSV to a JSON array of objects or arrays, or to JSON Lines, with typed values.
• JSON to CSV converter: Convert a JSON array or JSON Lines to CSV, flattening nested objects into dotted column names.
• CSV to SQL converter: Turn a CSV into SQL INSERT statements, with an optional CREATE TABLE, for PostgreSQL, MySQL, SQLite, or SQL Server.
• CSV to TSV converter: Convert a comma-separated file to tab-separated values that paste cleanly into spreadsheets.
• TSV to CSV converter: Convert a tab-separated file to a standard, properly quoted comma-separated CSV.
• CSV splitter: Split a large CSV into smaller files of a set number of rows, with the header repeated in each.

All eighteen tools are on the 2csv home page, and once a file is open you can switch between them without reloading it. Part of the 2suite.io privacy-first ecosystem.