CSV Editor

Edit CSV rows and columns in a simple grid.

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

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

1
Step 1
Paste CSV into the box or upload a.csv,.tsv or.txt file, then press Open in editor.
2
Step 2
Click any cell to edit it. Use Add row, Delete row, Add column and Delete column on the selected cell.
3
Step 3
Click a column heading to sort ascending, click again for descending.
4
Step 4
Press Download CSV or Copy CSV.

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?
Yes. The file is read and edited on this page; it is not sent to a server.
How does it pick the delimiter?
It tries comma, semicolon, tab and pipe on the first lines and keeps the one that gives the same column count on the most rows. You can change it from the Delimiter menu before downloading.
Does sorting treat numbers as numbers?
Yes. If both values look like numbers they are compared numerically, so 9 comes before 10. Empty cells go last. The header row stays on top.
What about commas and quotes inside cells?
They are quoted on download, with inner quotes doubled, so the file round-trips.
How big a file can I open?
Up to 50,000 rows. Only the visible rows are drawn, so scrolling stays smooth.

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 YouTube
  • Learn JSON - Full Crash Course

    freeCodeCamp.org

    Structured file formats show up beside binary converters.

    Watch on YouTube
  • File API

    MDN

    Browser file handling behind local file tools.

  • Blob

    MDN

    How browsers represent file bytes in local tools.