📊 CSV Data Studio

Paste a spreadsheet, get a clean dataset. Parses CSV/TSV, detects the delimiter, profiles every column, cleans the rows, and re-exports as JSON, SQL, Markdown, XML or HTML. Nothing is uploaded — the whole pipeline runs in this tab, which is the part spreadsheet-to-JSON sites charge a subscription for.

📁 Open a .csv file

Delimiter

First row is the header Trim cells Drop blank rows Remove duplicate rows

Chart a column

Preview — first 0 rows

How the parsing and profiling works

Fields are read with a quote-aware scanner (RFC 4180), so "Smith, Jones" stays one cell and "" becomes a literal quote. Auto-detect scores comma, semicolon, tab and pipe by counting separators on the first ten non-empty lines and picks the one with the most consistent column count. A column is typed numeric if at least 90% of its non-blank cells parse as finite numbers after stripping thousands separators and currency symbols; date if at least 90% match ISO, UK or US date shapes. Nothing leaves the browser — there is no server to send your rows to.