Editing — Trusty CSV User Guide
User Guide: Editing
Editing Functions
Typing, copying and pasting
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.Copying for other programs
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.Multiple cursors
Type in many places at once, from a click to every occurrence of a value in a column.Selecting columns and rows
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.Moving, copying and deleting rows
Move a row up or down, copy it, or delete it, with a key, and always the whole row.Find and replace
Search the column you’re in, or the whole file, with capitals, whole words or regular expressions, and replace one match or all.Undo and redo
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.