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.

Open the editor

or try it with world-cities.csv

Quality Check

Grouping similar values

Filtering rows

Reshaping the table

How the operations work, in the User Guide

every shortcut

Edit CSV files without Excel changing them

an OpenRefine alternative

a Tableau Prep alternative