# agentsite-static-version=4b1b7df4-4c2d-4a74-ae3c-8498e2f8bfd3 # trustycsv.com > AI-optimized mirror of trustycsv.com containing 57 pages totalling 41,479 words of clean markdown content, structured data, and semantic HTML. Original source: https://trustycsv.com. Last updated: 2026-11-17T12:52:23.723Z. Each page is available as HTML (with JSON-LD structured data) and Markdown (text-only, ideal for LLMs and RAG). ## Homepage - [Trusty CSV — a CSV editor for cleaning and preparing data](/content/site-root.html): Edit CSV files like code, not like a spreadsheet. Find and fix what’s wrong, filter, reshape and join tables on the file itself. Free, nothing uploaded. (3,128 words) ## Articles & Blog Posts - [Filtering rows — Trusty CSV User Guide](/content/help/cleaning/filtering/index.html): Bring together the rows you want to work on, by the values of one column or of several. The other rows aren’t removed: they wait in grey after the last row, and cleaning or sorting leave them alone. (1,488 words) - [The window — Trusty CSV User Guide](/content/help/getting-started/the-window/index.html): The menu bar and the tabs at the top, the file in the middle, the status bar at the bottom, and the command palette for everything else. (1,331 words) - [Quality Check and quick fixes — Trusty CSV User Guide](/content/help/cleaning/quality-check/index.html): A panel that reads the whole file and lists what is wrong with it (rows cut, repeated or too short, empty columns, zeros lost in a spreadsheet, text with a broken encoding, columns that write numbers, yes/no values or countries in several ways), with a key to go through them and a fix for most. (2,271 words) - [Selecting columns and rows — Trusty CSV User Guide](/content/help/editing/selecting-columns-and-rows/index.html): Whole columns from the bar of column numbers, whole rows from the line numbers, a cursor on every value of a column, boxes of columns, and a drag that keeps to the columns where it started. (991 words) - [Keyboard shortcuts — Trusty CSV User Guide](/content/help/reference/keyboard-shortcuts/index.html): Every shortcut of Trusty CSV, online and in the desktop app, for Windows and Linux or a Mac. (719 words) - [Column profile — Trusty CSV User Guide](/content/help/cleaning/column-profile/index.html): A panel at the side with what a column holds: its type, empty and missing values, distinct values, figures and a histogram for numbers and dates, and every value with how many cells have it, to select or correct them all at once. (1,536 words) - [Numbers, dates and other values — Trusty CSV User Guide](/content/help/reading/values-by-type/index.html): Number columns line up on their decimal point, email addresses on their @, times on their colon and dates group by group, all on their own. (781 words) - [Comparing two versions — Trusty CSV User Guide](/content/help/files/comparing/index.html): Compare a tab with what it was before a change, with its file on disk, with another tab or with a previous version. The differences are marked in the tab itself, which you can go on editing, and summed up in the Changes panel. (1,229 words) - [Saving — Trusty CSV User Guide](/content/help/files/saving/index.html): Save keeps the file exactly as it was written; Save As changes its format, delimiter, encoding or line breaks. In the browser, Chrome and Edge save in place and the others download a copy. (856 words) - [Delimiter and header row — Trusty CSV User Guide](/content/help/files/delimiter-and-header/index.html): How Trusty CSV finds out the character between values and whether the first row has the names of the columns, and how to change either. (749 words) - [Recipes — Trusty CSV User Guide](/content/help/cleaning/recipes/index.html): A recipe is the operations you did on one file, saved to do them again on another, such as the export that arrives every week, or on a whole folder of files. Recipes come with the desktop app, which is on its way. (1,065 words) - [Trusty CSV User Guide](/content/help/index.html): How to read, edit and clean CSV files with Trusty CSV, online and in the desktop app, from the first file to every shortcut. (496 words) - [Columns and colours — Trusty CSV User Guide](/content/help/reading/columns-and-colours/index.html): Every column in its own colour and lined up under the others, without a single character of the file changing. (733 words) - [Typing, copying and pasting — Trusty CSV User Guide](/content/help/editing/typing/index.html): The file is text, and you edit it as text: values, delimiters, quotes and line breaks, with a few helps that keep the columns in place. (706 words) - [Hiding columns — Trusty CSV User Guide](/content/help/reading/hiding-columns/index.html): Put the columns you don’t need out of sight to read a wide table without scrolling sideways; they stay in the file, and come back with a click. (790 words) - [How data operations work — Trusty CSV User Guide](/content/help/cleaning/how-data-operations-work/index.html): The Cells, Columns, Rows and Table menus change what you select, a whole column with just a cursor, in one step you can undo, and tell you how much they changed. (825 words) - [Excel workbooks — Trusty CSV User Guide](/content/help/files/excel-workbooks/index.html): Open the sheets of an Excel or OpenDocument workbook as CSV, and save any tab, or all of them, as a new Excel workbook. (347 words) - [Empty and repeated values — Trusty CSV User Guide](/content/help/cleaning/empty-and-repeated-values/index.html): Fill the gaps in a column with the value above, empty the values that repeat the one above, fill empty cells with your own text, turn NA, null and the like into empty cells, and remove empty rows. (582 words) - [OpenRefine alternative: clean CSV files in your browser — Trusty CSV](/content/openrefine-alternative/index.html): An OpenRefine alternative for cleaning CSV files: nothing to install, every row in view, problems found for you, the file itself saved. Free, in your browser. (1,134 words) - [Numbers and dates — Trusty CSV User Guide](/content/help/cleaning/numbers-and-dates/index.html): Write the numbers of a column plainly, with one decimal separator and no thousands separators, and its dates in a single format, whatever way each one was written. (520 words) - [Putting files together — Trusty CSV User Guide](/content/help/cleaning/combining-files/index.html): Add the rows of other files after the ones of this one, matching their columns by name, or bring columns from another file beside its rows, matched by an id. (1,005 words) - [Finding the cells to fix — Trusty CSV User Guide](/content/help/cleaning/finding-cells/index.html): Select the empty cells of a column, its repeated values, the values of another type, the longest ones or those with unusual characters, and then fix just those. (780 words) - [Reshaping the table — Trusty CSV User Guide](/content/help/cleaning/reshaping/index.html): Turn columns into rows and rows into columns, turn the whole table on its side, summarize a table with one row for each group, give each value of a cell a row of its own, and put those rows back together. (2,380 words) - [Multiple cursors — Trusty CSV User Guide](/content/help/editing/multiple-cursors/index.html): Type in many places at once, from a click to every occurrence of a value in a column. (440 words) - [Grouping similar values — Trusty CSV User Guide](/content/help/cleaning/similar-values/index.html): Find the values of a column that are the same one written in different ways (capitals, accents, spaces, typos) and merge each group into one value. (841 words) - [Whitespace and case — Trusty CSV User Guide](/content/help/cleaning/whitespace-and-case/index.html): Trim the spaces around values, squeeze the ones between words, remove them all, and put text in upper, lower or title case. (452 words) - [Tableau Prep alternative: clean CSV files for free — Trusty CSV](/content/tableau-prep-alternative/index.html): A Tableau Prep alternative for cleaning CSV files: free, in your browser, every row instead of a sample, problems found for you, the file itself saved. (911 words) - [Opening files — Trusty CSV User Guide](/content/help/files/opening-files/index.html): CSV, TSV, text, Excel and JSON files, also compressed, from the Open dialog, by dragging them in or from the recent list, with their format worked out for you. (566 words) - [Columns — Trusty CSV User Guide](/content/help/cleaning/columns/index.html): Insert, duplicate, delete and move columns, header included, in every row at once; split one in several, join several in one, number the rows, and tidy up the column names. (1,523 words) - [Find and replace — Trusty CSV User Guide](/content/help/editing/find-and-replace/index.html): Search the column you’re in, or the whole file, with capitals, whole words or regular expressions, and replace one match or all. (310 words) - [Tabs, and the work you leave open — Trusty CSV User Guide](/content/help/files/tabs-and-sessions/index.html): Every file in its own tab, and every tab still there, unsaved changes and undo history included, after a reload or a restart. (428 words) - [Cleaning data — Trusty CSV User Guide](/content/help/cleaning/index.html): The column profile, the problems of a file and their fixes, sorting and filtering, and the Cells, Columns, Rows and Table menus: spaces, case, characters, similar values, numbers and dates, empty and repeated values, duplicates, columns, reshaping the table and putting files together. (600 words) - [Edit CSV files without Excel changing them — Trusty CSV](/content/csv-without-excel/index.html): Opening a CSV in Excel drops leading zeros, rounds long numbers and turns codes into dates. What changes, how to stop it, and how to edit the file without it. (765 words) - [JSON — Trusty CSV User Guide](/content/help/files/json/index.html): Open a JSON or JSON Lines file as a table, with its numbers as written, and export any file as JSON, an array of rows keyed by the column names, or as JSON Lines. (668 words) - [Moving, copying and deleting rows — Trusty CSV User Guide](/content/help/editing/rows/index.html): Move a row up or down, copy it, or delete it, with a key, and always the whole row. (301 words) - [Online and on the desktop — Trusty CSV User Guide](/content/help/getting-started/online-and-desktop/index.html): The same editor runs in your browser at trustycsv.com and, soon, as an app for Windows, macOS and Linux. What changes between them. (365 words) - [Themes and zoom — Trusty CSV User Guide](/content/help/reading/themes-and-zoom/index.html): A dark or a light window, or whichever your system uses; a bigger or smaller text; and the colour themes of Visual Studio Code. (515 words) - [Changes on disk and previous versions — Trusty CSV User Guide](/content/help/files/changes-on-disk/index.html): When another program changes a file you have open, Trusty CSV asks before loading it. It keeps previous versions of your files, and the tabs you close without saving, so that nothing it writes over is lost. (530 words) - [Moving around a file — Trusty CSV User Guide](/content/help/reading/moving-around/index.html): Scrolling sideways, going to a line, a row or a column by name, and jumping from value to value. (614 words) - [Privacy and storage — Trusty CSV User Guide](/content/help/reference/privacy-and-storage/index.html): Your files never leave your computer. What Trusty CSV keeps on it, where, and how to remove it. (434 words) - [Sorting rows — Trusty CSV User Guide](/content/help/cleaning/sorting/index.html): Sort the rows by one column or by several, as numbers when a column holds numbers, as dates when it holds dates and in natural order when it holds text, or by the length of its values. (380 words) - [Count, sum, average, minimum and maximum — Trusty CSV User Guide](/content/help/cleaning/count-sum-average/index.html): Select some cells and the status bar adds them up, as a spreadsheet does. (236 words) - [Copying for other programs — Trusty CSV User Guide](/content/help/editing/copy-as/index.html): Copy As puts the selected rows and columns on the clipboard as a table to paste into a spreadsheet or a document, as Markdown, HTML, JSON or SQL, or as the values without the file’s quotes. (338 words) - [Encodings and line breaks — Trusty CSV User Guide](/content/help/files/encodings-and-line-breaks/index.html): The encodings Trusty CSV reads and writes, how to fix accents that come out wrong, which encoding Excel likes, and the two kinds of line break. (400 words) - [Missing values and stray spaces — Trusty CSV User Guide](/content/help/reading/missing-values-and-spaces/index.html): Values that mean “nothing here” are shown in grey, and spaces at the edges of a value, or spaces that aren’t ordinary ones, are marked. (359 words) - [Long values and line breaks — Trusty CSV User Guide](/content/help/reading/long-values/index.html): Values longer than their column fold into “…” and values with line breaks fold into one line, so that every row stays one aligned line. One click shows them whole. (351 words) - [Reading a row down — Trusty CSV User Guide](/content/help/reading/row-details/index.html): Row Details shows the row of the cursor as a list, a name and its value on each line, to read a wide table without scrolling sideways, and to edit any of its values. (401 words) - [Letters, digits and other characters — Trusty CSV User Guide](/content/help/cleaning/characters/index.html): Remove letters, digits, punctuation or accents, straighten curly quotes, decode HTML entities and get rid of invisible characters. (610 words) - [Undo and redo — Trusty CSV User Guide](/content/help/editing/undo-and-redo/index.html): Every change can be undone, a whole cleaning operation in one step, and the history survives a reload of the page, a restart of the app and closing the file. (383 words) - [Files and formats — Trusty CSV User Guide](/content/help/files/index.html): Opening and saving, delimiters, encodings, Excel and JSON, and the tabs you leave open. (308 words) - [Editing — Trusty CSV User Guide](/content/help/editing/index.html): Typing, multiple cursors, whole columns and rows, find and replace. (210 words) - [Duplicate rows — Trusty CSV User Guide](/content/help/cleaning/duplicate-rows/index.html): Find out how many rows repeat another, whole or by one column, exactly or ignoring capitals and spaces, and remove them keeping the first. (309 words) - [Reading your data — Trusty CSV User Guide](/content/help/reading/index.html): Column colours, alignment, long values and moving around a file. (243 words) - [Online CSV Editor — Trusty CSV](/content/online/index.html): Open a CSV, TSV or Excel file and edit it in your browser like code: a colour for every column, aligned columns, multiple cursors. Nothing is uploaded. (83 words) - [Getting started — Trusty CSV User Guide](/content/help/getting-started/index.html): The window, the command palette, and the online editor and the desktop app. (115 words) - [Reference — Trusty CSV User Guide](/content/help/reference/index.html): Every keyboard shortcut, and what stays on your computer. (48 words) ## Resources - [Full Page Index](/index.html): Browse all cached pages with rich metadata - [About This Cache](/about.html): Methodology, technical details, and usage guidelines - [XML Sitemap](/sitemap.xml): Machine-readable sitemap for crawler discovery - [Robots.txt](/robots.txt): Crawler directives - [Agentsite Network](https://agentsite.network/network.html): Public index of Agentsites and their machine-readable resources