Trusty CSV — a CSV editor for cleaning and preparing data
Edit CSV files like code , not like a spreadsheet.
Trusty CSV opens the file itself and shows it as a table you can read: every column in its own colour, lined up as you type. Edit it with the keys of a code editor, let the quality check find what’s wrong, and clean it with tools made for tables. Nothing is converted and nothing is uploaded: what you save is your file, with only your changes.
Open the editor
or try it with
world-cities.csv
free no sign-up nothing uploaded
coffee-menu.csv
id
,
product
,
price
,
stock
,
description
1
,
Espresso
,
2
.20
,
120
,
"Rich, intense shot pulled from freshly ground beans with a hazelnut crema"
2
,
Flat white
,
3
.40
,
85
,
Velvety microfoam poured over a double ristretto
3
,
Cortado
,
3
.10
,
64
,
"Equal parts espresso and warm milk, served in a small glass"
4
,
Cold brew
,
3
.90
,
40
,
Steeped for eighteen hours for a smooth and naturally sweet cup
5
,
Matcha latte
,
4
.20
,
22
,
Stone-ground green tea whisked with steamed milk
6
,
Chai
,
3
.60
,
37
,
"Black tea, cardamom, cinnamon and ginger, simmered with milk"
Delimiter: Comma · Header row
…and the columns line up, without changing a single character of the file.
why
Code editors are made for code. Spreadsheets, for spreadsheets. Trusty CSV is made for CSV.
A CSV file is a table written as text, and the tools you already have see one half or the other. A spreadsheet sees the table, and converts the text to get it. A code editor keeps the text, and never sees the table.
Trusty CSV sees both. It shows the text as a table you can read, edits it like code, and cleans it with tools made for tables. And it stops there: no formulas, no charts, no fonts, no extensions to set up.
opened-in.csv
| opened in | what you get |
|---|---|
| a spreadsheet | a converted copy: 0042 becomes 42, SEPT2 a date, a long number 9.40011E+21 |
| a code editor | lines of commas: sort them, and a row with a line break in a cell falls apart |
| a data-prep tool | a project: you import the file, clean a copy and export a new one |
| Trusty CSV | the file itself, as a table: clean it, save it, and only your changes are new |
Its menus are named after what they change: the table, its rows, its columns, what’s in a cell.
quality check
See what’s wrong with a file, and fix it in a click
A CSV has usually been through a few hands before it reaches you: exported, pasted together, opened in a spreadsheet and saved again. Quality Check reads the whole file and lists what went wrong on the way. Each kind of problem has a button that fixes every case at once.
customers.csv
id
,
name
,
city
,
joined
,
plan
,
notes
1041
,
Ana García
,
Madrid
,
2026-01-03
,
pro
,
Renewed in March
1042
,
José Ruiz
,
Málaga
,
2026-01-09
,
free
,
NA
1043
,
Luis Ortega
,
Bilbao
,
2026-01-17
,
pro
,
Asked for an invoice
by email
1044
,
Eva Soler
,
Valencia
,
2026-02-02
,
team
,
n/a
1045
,
Noa Vidal
,
Vigo
,
2026-02-11
,
free
,
1046
,
Iván Peña
,
León
,
2026-02-20
,
pro
,
Paused until June
1045
,
Noa Vidal
,
Vigo
,
2026-02-11
,
free
,
1047
,
Mar Costa
,
Lugo
,
2026-03-01
,
team
,
Delimiter: Comma · Header row
28 checks, and only the sure ones
It reports what is surely wrong, or surely written in two ways. It doesn’t guess what your data means.
The list comes in the order to fix things in: first what makes the file read wrong, then the text to clean, then the columns written in two ways. Start at the top and go down. Every fix is one step of Ctrl + Z .
F8 goes to the next problem, and Ctrl + . fixes the one under the cursor. Like everything else, it happens on your computer.
Every check, in the User Guide
checks.csv
| problem | fix |
|---|---|
| Rows cut by a line break | Join them |
| Rows with delimiters missing | Add them |
| Empty and repeated rows | Remove them |
| Broken encoding: España | Repair it |
| HTML entities: Tom & Jerry | Decode them |
| Spaces around a value | Trim them |
| NA and n/a and - in one column | Empty them |
| Codes that lost their zeros: 8001 | Add the zeros |
| A decimal comma among decimal points | Write it like the rest |
| Dates written in several ways | Reformat them |
| Madrid and madrid and MADRID | Group them |
| Text in a column of numbers | Select it |
| Repeated ids | Select them |
prepare
From a messy export to the table you need
Group the values written in several ways, filter the rows, rewrite dates and numbers one way, split and join columns, turn columns into rows and back, summarize, and put files together. Each operation changes the file you have open, not a copy of it, and each one is a single Ctrl + Z .
Values written in several ways, made one
Madrid, madrid and MADRID are the same city. Group Similar Values finds them, from the strictest way of comparing to the loosest (same words, same letters, similar spelling, same sound), and turns each group into the value you choose.
Grouping similar values
orders.csv
id
,
city
,
customer
,
total
1
,
Madrid
,
Ana García
,
120
.00
2
,
madrid
,
Luis Ortega
,
85
.50
3
,
Barcelona
,
Eva Soler
,
42
.00
4
,
MADRID
,
Noa Vidal
,
310
.25
5
,
Sevilla
,
Iván Peña
,
19
.90
6
,
Barcelona
,
Mar Costa
,
64
.00
7
,
barcelona
,
Pau Roca
,
77
.10
8
,
Sevila
,
Leo Gil
,
15
.00
9
,
Madrid
,
Sara Ruiz
,
58
.40
10
,
Sevilla
,
Hugo Sanz
,
33
.00
Delimiter: Comma · Header row
Filter, and see what was left out
Filter a column by its values, by a condition or by dates. The rows that pass stay where they are, and the rest wait in grey after the last row, so you always see what the filter took away. Operations work on the rows you can see.
Filtering rows
shipments.csv
order
,
customer
,
country
,
total
1001
,
Ana García
,
Spain
,
120
.00
1002
,
Tom Baker
,
United Kingdom
,
85
.50
1003
,
Eva Soler
,
Spain
,
42
.00
1004
,
Lena Vogel
,
Germany
,
310
.25
1005
,
Marc Dupont
,
France
,
19
.90
1006
,
Iván Peña
,
Spain
,
64
.00
1007
,
Sofia Rossi
,
Italy
,
77
.10
1008
,
Jonas Berg
,
Germany
,
15
.00
1009
,
Leo Gil
,
Spain
,
58
.40
Columns into rows, and back
A column for each month is easy to read and hard to analyse. Columns to Rows turns them into two columns, a name and a value; Rows to Columns goes back, and Summarize counts, adds up or averages each group. The first rows of the result show before anything changes.
Reshaping the table
stores.csv
store
,
jan
,
feb
,
mar
Lisbon
,
120
,
135
,
150
Porto
,
98
,
104
,
111
Faro
,
45
,
52
,
61
And the rest of the cleaning
Each operation takes the selection: the column of the cursor, the cells you selected, or the whole file with Ctrl + A . Quotes, line breaks inside cells and the header row are taken care of, and a toast says how many cells or rows changed, even out of sight.
How the operations work, in the User Guide
operations.csv
| menu | what it does |
|---|---|
| Columns | Sort by one column or several, as numbers or dates when that’s what they hold |
| Columns | Split a column, join two, or merge the first value that isn’t empty |
| Columns | Insert, duplicate, move and delete columns; tidy the header names |
| Rows | Remove the title and notes above the table |
| Cells | Reformat numbers and dates, written one way |
| Cells | Trim spaces, change case, remove accents and invisible characters |
| Cells | Fill down, fill empty cells, empty the NA, n/a and - |
| Rows | Remove duplicate and empty rows |
| Rows | Split the values of a cell into rows, and combine them back |
| Table | Summarize: count, add up or average each group |
| Table | Turn columns into rows and back, or swap rows and columns |
| Table | Append the rows of other files, or join two files by a column |
| View | A column’s profile: its values, their counts, a histogram of its numbers or dates |
| View | Compare with the last change, the file on disk or another file |
editing
A text editor that knows where the columns are
For the edits no menu has: the keys of a code editor, in an editor that tells rows from lines and columns from commas.
Many values, changed at once
Retype every “United States” of a column as “USA” in one go. Select one and press Ctrl + D to add the next in the same column, or Ctrl + Shift + L for all of them, then type. Ctrl +click adds a cursor anywhere.
people.csv
id
,
name
,
city
,
country
,
joined
1
,
Ada Lovelace
,
London
,
United Kingdom
,
2024-03-01
2
,
Grace Hopper
,
New York
,
United States
,
2024-03-09
3
,
Alan Turing
,
Manchester
,
United Kingdom
,
2024-03-04
4
,
Katherine Johnson
,
Hampton
,
United States
,
2024-04-20
5
,
Hedy Lamarr
,
Vienna
,
Austria
,
2024-04-12
6
,
Margaret Hamilton
,
Boston
,
United States
,
2024-05-02
A whole column at once
Retype the dates of a column, fix a prefix or clear a field in thousands of rows: Ctrl + Alt + Shift + C puts a cursor on every value of the column you’re in. Alt + Shift +drag selects a box of columns.
people.csv
id
,
name
,
city
,
country
,
joined
1
,
Ada Lovelace
,
London
,
United Kingdom
,
2024-03-01
2
,
Grace Hopper
,
New York
,
United States
,
2024-03-09
3
,
Alan Turing
,
Manchester
,
United Kingdom
,
2024-03-04
4
,
Katherine Johnson
,
Hampton
,
United States
,
2024-04-20
5
,
Hedy Lamarr
,
Vienna
,
Austria
,
2024-04-12
6
,
Margaret Hamilton
,
Boston
,
United States
,
2024-05-02
Long values stay out of the way
Every row stays one aligned line: values wider than their column fold into “…”, and cells with line breaks into their first line. Click “…”, or move the cursor in, to see the whole value; it folds again when you leave. Ctrl+Alt+E opens the whole column.
coffee-menu.csv
id
,
product
,
price
,
stock
,
description
1
,
Espresso
,
2
.20
,
120
,
"Rich, intense shot pulled from
…
2
,
Flat white
,
3
.40
,
85
,
Velvety microfoam poured over a
…
3
,
Cortado
,
3
.10
,
64
,
"Equal parts espresso and warm
…
4
,
Cold brew
,
3
.90
,
40
,
Steeped for eighteen hours for
…
5
,
Matcha latte
,
4
.20
,
22
,
Stone-ground green tea whisked
…
6
,
Chai
,
3
.60
,
37
,
"Black tea, cardamom, cinnamon
…
It reads your file for you
Open a file and start: comma, semicolon, tab or pipe; with or without a header row; UTF-8 or Windows-1252; Windows or Unix line breaks. Trusty CSV detects all of it, and keeps it when you save, so the file still opens the same way everywhere else.
ventas-marzo.csv
01/03/2026;Aceite de oliva 1 L;12;8
,
95;107
,
40
02/03/2026;Queso manchego;4;6
,
40;25
,
60
02/03/2026;Turrón de Jijona;20;5
,
25;105
,
00
05/03/2026;Azafrán 1 g;7;4
,
80;33
,
60
06/03/2026;Pimentón de la Vera;
…
,
95;44
,
25
09/03/2026;Vino tinto crianza;9
…
,
50;67
,
50
A real app on your desktop
Trusty CSV for Windows, macOS and Linux is on its way: double-click a .csv file to open it, press Ctrl + S to save straight back to disk, and keep working offline. Tabs you leave open are still there next time.
In the browser, Chrome and Edge save straight back to the original file too; elsewhere, files are saved as downloads.
shortcuts
Shortcuts your fingers already know
The same keys as VS Code, plus a few for working with columns. Press Ctrl + K in the editor for the full list, or see every shortcut in the User Guide.
shortcuts.csv
| keys | action |
|---|---|
| Ctrl+D | Add next occurrence in the same column |
| Ctrl+Shift+L | Select all occurrences in the column |
| Ctrl+Alt+D | Add next occurrence anywhere in the file |
| Ctrl+click | Add a cursor |
| Ctrl+Alt+↑ / ↓ | Add cursor above / below |
| Ctrl+Alt+C | Select column |
| Alt+Shift+drag | Box selection |
| Ctrl+F / Ctrl+H | Find / replace in a column or the whole file, with regular expressions |
| Ctrl+G | Go to line or row |
| F8 | Go to the next problem the quality check found |
| Ctrl+. | Fix the problem under the cursor |
| Shift+wheel | Scroll sideways (over the scroll bar, the wheel alone does it) |
| Ctrl+Shift+P | Command palette |
| Alt+↑ / ↓ | Move row up / down, multiline cells included |
| Alt+← / → | Move column left / right |
| Ctrl+S | Save |
| Ctrl+Z | Undo, as many times as you need |
trust
The table is the file.
What you see is the text of your file, coloured and lined up on screen. Nothing is converted when it opens and nothing is added to line it up, and saving writes back the same delimiter, quotes, encoding and line breaks. Trusty CSV won’t move a comma you didn’t.
Nothing converted on the way in
Open a CSV in a spreadsheet and it reads each value as it sees fit: codes lose their leading zeros, some turn into dates and long numbers are rounded. Save it, and that’s what the file says from then on.
Trusty CSV reads the text as it is, and writes it back the same.
These are a spreadsheet’s conversions by default; recent versions of Excel let you turn some of them off.
orders.csv, opened in a spreadsheet and saved
| id | zip | sku | ordered | tracking |
|---|---|---|---|---|
| 42 | 8001 | 2-Sep | 3/4/2026 | 9.40011E+21 |
| 43 | 28013 | 1-Dec | 3/5/2026 | 9.40011E+21 |
orders.csv, opened in Trusty CSV and saved
| id | zip | sku | ordered | tracking |
|---|---|---|---|---|
| 0042 | 08001 | SEPT2 | 2026-03-04 | 9400111202555842332669 |
| 0043 | 28013 | DEC1 | 2026-03-05 | 9400111202555842332676 |
The diff is what you changed
Repair a broken encoding with the quality check and save: version control sees one line changed, the one you fixed. The rest of the file is byte for byte what it was.
git diff customers.csv
@@ -3 +3 @@
-1042,José Ruiz,Málaga,2026-01-09,free,NA
+1042,José Ruiz,Málaga,2026-01-09,free,NA
Nothing is uploaded. Files are read and written on your device. There is no account, and the tabs you leave open stay in your browser’s own storage, so a reload doesn’t lose your work.
Nothing changes that you didn’t change. The alignment is only on screen, and an operation rewrites only the cells it is for.
Every change is one Ctrl+Z. An operation on a million cells too, and still after you reload the page.
The checks don’t guess. Quality Check reports what is surely wrong, and leaves what your data means to you.
Open the editor
faq
Questions
Is Trusty CSV free?
Yes. Open the editor and start working: no sign-up and no limits on the number of files.
Why not just use Excel, or a code editor?
A spreadsheet converts a CSV when it opens it: by default, codes lose their leading zeros, some become dates and long numbers are rounded, and that’s what gets saved. A code editor keeps the text but doesn’t know it’s a table: it can’t line up the columns, sort the rows without breaking a cell that has a line break, or tell you that a row is short. Trusty CSV keeps the text and knows the table. More in Edit CSV files without Excel changing them .
How is it different from OpenRefine or Tableau Prep?
They import your data into a project or a flow, and you export a new file at the end. Trusty CSV opens the file itself, in your browser with nothing to install, shows every row, finds the problems for you, and saves the file with only your changes. It groups similar values, filters, reshapes and joins files too. What it doesn’t do yet is replay a list of steps on the next file, and it reads files, not databases. Compared in detail: an OpenRefine alternative , a Tableau Prep alternative .
Are my files uploaded anywhere?
No. Everything happens in your browser: opening, editing, converting to and from Excel and saving. The files never travel to a server.
Can it find what’s wrong with a CSV file?
Yes. Table › Quality Check reads the whole file and lists its problems: rows cut in two or too short, repeated rows, text with a broken encoding, stray spaces, lost leading zeros, dates, numbers, yes/no values and countries written in several ways, and more, 32 kinds in all. Most have a button that fixes every case at once, and Ctrl + Z undoes it. See Quality Check in the User Guide.
Does the alignment change my file?
No. Columns are aligned only on screen. The file keeps its exact text (the same delimiter, quotes, encoding and line breaks) unless you edit it or choose another format when saving.
How large a file can it open?
Files of tens of megabytes and around a million lines open in a few seconds and stay smooth to edit. Beyond that it depends on your computer’s memory.
Can I open and save Excel files?
Yes: .xlsx , .xls and .ods open sheet by sheet as CSV, and any file can be downloaded as a new .xlsx or .ods workbook. The original workbook is never overwritten, because formulas and formatting can’t be kept in CSV.
Which browsers does it work in?
Any modern browser. Saving straight back to the original file needs Chrome or Edge on a computer; elsewhere, files are saved as downloads.
Is there a desktop app?
It’s on its way, for Windows, macOS and Linux: it opens .csv files with a double-click, saves straight back to disk and works without a connection.
or try it with world-cities.csv
How the operations work, in the User Guide