CSV Editor
Edit CSV rows and columns in a simple grid.
About this tool
Paste CSV text or upload a file and it opens as an editable table. Click a cell to change it, add or remove rows and columns, sort by any column, then download the result or copy it. The delimiter (comma, semicolon, tab or pipe) is detected for you.
How to use
How it works
The file is parsed into a grid of text cells. Short rows are padded so every row has the same number of columns. When you save, any cell that contains the delimiter, a double quote, a line break or leading or trailing spaces is wrapped in quotes, and quotes inside it are doubled, so the file opens correctly in Excel, Sheets and other parsers. Only the rows on screen are drawn, so large files stay responsive.
Worked example
A cell with a comma in it
- Input
- name,qty "Gadget, large",1 Widget,4
- Output
- name,qty "Gadget, large",1 Widget,4
- Walkthrough
- The comma inside Gadget, large stays inside one cell because it is quoted. Sorting the qty column ascending would put Gadget, large first (1 before 4).
Limitations
- The first 50,000 rows are loaded; a notice tells you when a file is longer and the rest is not in the download.
- There is no undo; use Start over to return to the text.
- Numbers and dates are kept as text exactly as typed. No formulas.
- Output uses CRLF line endings and the delimiter shown in the toolbar.
Questions
Can I edit a CSV online without uploading it?
How does it pick the delimiter?
Does sorting treat numbers as numbers?
What about commas and quotes inside cells?
How big a file can I open?
Features
- Edit cells in a table
- Add and delete rows and columns
- Sort by any column
- Detects the delimiter
- Correct quoting on export
- Runs in your browser
Related resources
Guides and videos from around the web—opens on YouTube or the publisher’s site.
How Image Compression Works
Leo Isikdogan
Size limits matter for many file-sharing tools.
Watch on YouTubeLearn JSON - Full Crash Course
freeCodeCamp.org
Structured file formats show up beside binary converters.
Watch on YouTube