CSV Editor — Examples

Back to the overview: CSV Editor · Open the tool live: www.jpkc.com/tools/csv/

The manual explains every button and option in detail. This page adds concrete workflows: typical tasks, walked through step by step. The tool's interface is in English, so the button and field names are the real labels.

Example 1: Import a semicolon CSV from Excel

The classic in German-speaking regions: Excel exports CSV with a semicolon instead of a comma, because the comma is taken as the decimal separator.

1. Open the CSV Editor. The delimiter defaults to Auto-detect.
2. Click Open and choose your file (or drag it straight onto the editor area).
3. Detection counts the delimiter candidates in the first line and picks the semicolon because it occurs most often there. The toast confirms it: "… (semicolon-separated)".
4. The data now sits cleanly in columns. If it ended up all in one column, detection got it wrong — open Settings, set CSV Delimiter to Semicolon (;), and load the file again.

Example 2: Edit a column and export as JSON

You have a contact list as CSV and need it as a JSON array of objects for an API or a script.

1. Import the file (Example 1). Enable First row is header in Settings so the first row becomes column headers, then load the file again — now the columns carry real names like name, email, city.
2. Fix what you need to: click a cell and type the new value. Rename a whole column? Double-click the column header. Drop a redundant column? Right-click the header → delete.
3. Click JSON. Because header mode is on, the result is an array of objects with the headers as keys, downloaded as data.json:

[
  { "name": "Alice", "email": "alice@example.com", "city": "Berlin" },
  { "name": "Bob", "email": "bob@example.com", "city": "Hamburg" }
]

4. If you need plain row arrays instead, turn First row is header off before exporting — then JSON produces an array of arrays.

Example 3: Check auto-detection on a messy file

You've been handed a foreign file and don't know what it's built with.

1. Leave the delimiter on Auto-detect and open the file. Read the toast: it names the detected delimiter (comma / semicolon / tab / pipe).
2. Eyeball it: do the values sit cleanly in separate columns? Then it's right. If everything is stuck in one column or columns are shifted, the first line was atypical — detection only looks at the first line.
3. In that case set the delimiter manually in Settings and reload. Cycle through the candidates (comma, semicolon, tab, pipe) until the table looks right.
4. Fields with embedded commas or line breaks must have been correctly quoted by the source file — then the RFC 4180 parser splits them right. If it didn't, no delimiter will help; the file is broken at the source.

Example 4: Pull data in from Excel or Google Sheets by pasting

You don't want to export a file at all — just bring in a selection from a spreadsheet.

1. In Excel, Google Sheets, or Numbers, select the range you want and copy it (Ctrl+C).
2. Click Paste in the CSV Editor. (If the browser asks, allow clipboard access.)
3. Spreadsheets copy tab-separated; auto-detection recognizes this as a tab and builds the table correctly. The toast reports the row count and "tab-separated".
4. Edit the data and export it as CSV or JSON — or send it back into another spreadsheet with Copy (tab-separated).

Example 5: Transpose a sideways table

Some exports put the attributes in rows instead of columns — a "Name" row, a "City" row, and so on, with the records as columns.

1. Import the file.
2. Click Transpose. m rows × n columns becomes n rows × m columns — the table is flipped.
3. Now enable First row is header if the former row names should serve as the header row.
4. Export as usual. If the flip didn't produce what you wanted, get it back with Undo (Ctrl+Z).

Example 6: Work safely and survive a reload

You're editing a larger file across several sessions and don't want to lose anything.

1. Work normally — the tool saves the table to browser storage automatically after each change (you can see this in the storage status in the status bar).
2. Before a risky action (a large delete, a transpose), also click Store to pin an explicit state.
3. If something went wrong and a single Undo isn't enough, click Restore — the most recently saved table comes back.
4. When you're done and want a clean slate, click Reset: after the confirmation prompt, the table and the saved data are cleared.

---

Going deeper: the overview for the big picture, the manual for every function in detail, and the tips & tricks for the pitfalls. You can try all of it directly in the tool.