User Guide
How to read, edit and clean CSV files with Trusty CSV, online and in the desktop app, from the first file to every shortcut.
Getting started
Reading your data
Editing
Cleaning data
- How data operations work
- Column profile
- Quality Check and quick fixes
- Filtering rows
- Finding the cells to fix
- Whitespace and case
- Letters, digits and other characters
- Grouping similar values
- Numbers and dates
- Empty and repeated values
- Sorting rows
- Duplicate rows
- Columns
- Reshaping the table
- Putting files together
- Recipes
- Count, sum, average, minimum and maximum
Files and formats
Reference
Common questions
Is Trusty CSV free?
The online editor is: open trustycsv.com/online and start working, with no sign-up and no limit on the number of files. A desktop app for Windows, macOS and Linux is on its way.
Are my files uploaded anywhere?
No. Everything happens on your computer: opening, editing, converting to and from Excel and JSON, and saving. The tabs you leave open are kept in your browser’s own storage, so that a reload doesn’t lose your work. See Privacy and storage.
Does the alignment change my file?
No. Columns line up only on screen; the file keeps its exact text, with the same delimiter, quotes, encoding and line breaks, unless you edit it or pick another format when saving. See Columns and colours.
Why does a cleaning operation change only one column?
Operations in the Cells, Columns and Rows menus work on what you select. With just a cursor, that is the cursor’s whole column; to change several columns, select cells in each of them, or press Ctrl+A⌘A for the whole file. See How data operations work.
Can I undo an operation?
Yes: every operation of the Table, Rows, Columns and Cells menus is one step of Ctrl+Z⌘Z, however many cells it changed. The undo history even survives a reload of the page, and closing the file. See Undo and redo.
Can I open and save Excel files?
You can open .xlsx, .xls and .ods workbooks sheet by sheet, and save any tab, or all of them, as a new .xlsx or .ods workbook. The original workbook is never overwritten. See Excel workbooks.
Which browsers does it work in?
Any modern browser. Saving straight back to the original file needs Chrome or Edge on a computer; other browsers save a copy as a download. See Saving.
Suggestions or bugs?
Write to us at hello@calmly.studio. We read everything, and requests from people who use the editor are how it decides what to do next.