DataForge Tools

Row 4,182 has an extra comma.

CSV Studio finds it — along with the duplicate IDs, the two date formats, the eleven cells that say N/A, and the name that came back as Müller. A desktop app for Windows. Your files never leave your machine.

subscribers_export.csv
id email signup_date spend
1 1041 ana@corp.io 2024-03-04 129.00
2 1042 j.lee@corpflagged 03/12/20242024-03-12 89.00
3 1043     missing 2024-13-01invalid N/Anull
4 1042duplicate j.lee@corp.io 2024-03-12 89.00
5 1044 Müller@corp.iomüller@corp.io 2024-04-01 1,240.001240.00

7 issues across 5 rows — nothing exported yet. 7 issues resolved. Ready to export as JSON, Excel, SQL, YAML, XML or Markdown.

Local only

Files are processed on your computer. Nothing is uploaded.

Windows desktop

Installs from a setup file. Works offline.

No account

Buy it, install it, open your file. There's no sign-in.

CSV Studio

One app, two editions.

Start free to open and export files. Choose Pro at checkout when you need the cleaning, validation and batch work done for you. Both editions are versions of the same product — pick yours on the product page.

Pro — £29 once

CSV Studio Pro

The full toolkit for messy files you didn't create.

  • CSV and TSV import with table preview and editing
  • Data cleaning and validation
  • Duplicate, missing-value, email and date checks
  • Column transformations
  • JSON, Excel, SQL, YAML, XML and Markdown export
  • Batch conversion across many files
  • ZIP and split-file exports
  • Saved workflows and export presets
  • Undo and redo throughout
Get Pro
Free edition — £0

CSV Studio Free

Open, read and export a file without opening a spreadsheet.

  • CSV and TSV import
  • Table preview and editing
  • Basic JSON and CSV export
  • Local, private file processing
  • Undo and redo support
Get the free edition

What Pro checks for

The four things that break an import.

Every check reports the row and column it fired on, so you can fix the source or let CSV Studio resolve it on export.

id 1042 appears twiceduplicate rows grouped
email = "j.lee@corp"malformed address flagged
spend = "" · "N/A" · "-"missing values, one rule
03/12/2024 vs 2024-03-12one date format, invalids named

Export as

.json .xlsx .sql .yaml .xml .md .csv .zip — split files