CSV Formatter screenshot

CSV Formatter

Validate, beautify, and convert CSV data to JSON tables.

Privacy First
0 Runs
Updated 2026-11-06
Runs in your browser
Nothing uploaded
No account needed

Validate, beautify, and convert CSV data to JSON tables. Enter your numbers and get an instant result.

Paste comma-, semicolon- or tab-separated rows and this page shows them as a spreadsheet grid, as aligned text, or as a JSON array of objects built from the first row's headers. The delimiter is a choice rather than a guess.

The parser splits each line on the delimiter and strips one pair of surrounding quotes. It does not implement RFC 4180: a delimiter inside a quoted field, or a field that contains a line break, will split where it should not.

Everything happens in the tab, so a customer list pasted here is not uploaded. Nothing is stored once the page is closed.

The three views of the same table

The grid puts the first row in the header and the rest in the body, which is the fastest way to see whether the delimiter was right. If the columns are clearly wrong, the file is probably semicolon- or tab-separated.

Pretty text pads every column to its widest value so the columns line up in a fixed-width font. JSON emits one object per data row, keyed by the header names, with an empty string for a missing cell.

  • Grid: header row plus body rows, scrollable
  • Pretty text: columns padded to equal width
  • JSON: one object per row, keyed by the header

Rows the simple parser cannot read

A file where an address field is "1 High Street, London" will split into two cells, because the comma is inside the quotes and the parser only splits on the delimiter. If the file uses quotes to protect delimiters, convert it with a real CSV library first.

The same applies to a quoted field containing a newline: the parser reads lines, not records, so one record becomes two. Numbers are also left as strings in the JSON output, since the page does not guess types.

How to use the mode and delimiter

Paste the rows into the Source CSV box, or open a csv, tsv or txt file, pick the Mode, Spreadsheet Grid, Pretty Text or Convert to JSON, and set the Delimiter: comma, semicolon or tab. Clear empties the boxes, Sample loads an example, and Download saves the result; validation starts as you type.

The parser splits each line on the delimiter and strips one pair of surrounding quotes: a delimiter inside quotes or a line break inside a field splits where it should not, and JSON numbers stay strings. When columns look wrong the file is probably using a different delimiter than the one set.

What to Expect

Best for

  • Eyeballing a pasted export in a grid
  • Turning a simple table into a JSON array
  • Aligning columns for a report or a ticket

Not ideal for

  • Files with quoted delimiters or multi-line fields
  • Type inference, where numbers should become numbers
  • Large files, which are meant for a spreadsheet rather than a text box

What this tool keeps

  • The first row as the header row
  • Cell values as text, with one pair of outer quotes removed
  • The row order of the source

What may need cleanup

  • Rows that split inside a quoted field
  • Numeric-looking values that stay strings in the JSON
  • Ragged rows, where a missing cell becomes an empty string

Common errors

  • Leaving the delimiter on comma for a semicolon-separated file
  • Expecting quoted commas to be preserved
  • Expecting a headerless file to keep its first row as data

Example use cases

  • Checking a pasted export before importing it
  • Producing a JSON fixture from a handful of rows
  • Aligning a small table for a bug report

Sample input

Paste ID,Name,Role then three rows, with the delimiter left on comma.

Sample output

A four-column grid, the same table aligned as text, and a JSON array of three objects keyed ID, Name and Role.

Who this is for

  • Analysts checking an export
  • Developers building a test fixture
  • Anyone who needs a table aligned in plain text

Frequently asked questions

What three views of my CSV does this page offer?

It shows the rows as a spreadsheet grid, as aligned text, or as a JSON array of objects built from the first row's headers.

Can it read a quoted delimiter or a multi-line field?

The simple parser cannot. A quoted delimiter or a field spanning several lines splits the row in the wrong place.

Does it infer number types?

No. Cell values stay text, with one pair of outer quotes removed, so a numeric-looking value remains a string in the JSON.

Developer program

Build custom tools for your store

Join the SDK program to create useful ecommerce utilities for your store.