CSV Editor Online
View, Edit And Fix CSV

What A CSV Editor Online Does For You

A CSV file is plain text, so it is hard to read. Commas, quotes and line breaks run together. A spreadsheet fixes that, but it also changes your data. So many people want a lighter way to look at a file and fix it.

This tool does that in your browser. First, paste CSV or open a file. Then the table appears, and you can click any cell and type. The CSV on the right updates as you go.

It reads comma, semicolon, tab and pipe files. It finds the right one for you, and you can pick it by hand. It also keeps line breaks inside a cell, which many simple viewers lose.

Everything runs in your tab. Your file never leaves your device. That matters, because exports often hold names, emails and prices.

View CSV As A Table

First, paste your text or open a file. The tool splits it into rows and columns. The first row becomes the header, and you can switch that off if your file has none.

Long files show in pages of three hundred rows. Then a button loads more. So a big export still opens fast, even on a phone.

Also, if a row has fewer fields than the rest, the tool adds empty cells and tells you. That keeps the table square.

For more detail, see: Wikipedia article on CSV files.

Edit, Sort And Clean

Click a cell and type. The change shows in the CSV at once. Then use the buttons for bigger jobs. You can add or delete a row or a column, and you can sort by the column you picked.

Three clean up buttons save a lot of time. One trims stray spaces. Another removes empty rows. The third removes duplicate rows, and it keeps the first copy.

The header row stays where it is when you sort. So your column names never jump into the data.

Escape And Unescape A Field

Some jobs need only one field. Maybe you must put a sentence with commas and quotes into a CSV. The escape box does that. It wraps the text in quotes and doubles every quote inside.

In the other direction, unescape removes the outer quotes and turns each doubled quote back into one. So you can read a field that came out of a file.

Line Breaks Inside Cells

A CSV cell can hold several lines, as long as quotes wrap it. Notes and addresses often do. Many tools break such a row in two. This one keeps it whole.

In the table, press Enter inside a cell to add a line break. Then the output wraps that cell in quotes for you.

So a file with multi line text opens, edits and saves without damage.

Delimiters And Quotes

CSV means comma separated values, but real files vary. Some use semicolons, because the comma is a decimal mark in many countries. Others use tabs or pipes. The reader checks the first lines and picks the right one.

You can also pick a different delimiter for the copy. So you can read a semicolon file and save it with commas, or the other way round.

The writer follows the standard rule. It quotes a field that has the delimiter, a quote, a line break or a space at the edge. You can also quote every field if a strict import needs it.

A Guard For Spreadsheet Formulas

A cell that starts with an equals sign can run as a formula when someone opens the file in Excel. That is a known attack, called CSV injection. So the guard adds an apostrophe in front of such cells.

It leaves normal numbers alone, even negative ones. You can switch the guard off if you know the data is safe.

Why Use An Online CSV Viewer

A spreadsheet app is heavy for a quick look. It also guesses types, so it can turn a ZIP code into a number and drop the zero. A plain viewer shows your text as it is.

Besides, the tool opens on any device, with nothing to install. So you can check a file on a laptop at work or on a phone on the train.

Finally, the output stays plain CSV. You can paste it into a database import, a script or an email.

Safe By Design

The tool draws cells as text and never as markup, so a hostile file cannot run code in your page. Also, it never runs a formula from your data.