CSV Formatter
Why use a private CSV formatter?
CSV files frequently contain personal data — customer lists, order exports, HR records, financial transactions. Uploading them to an online formatter means that data passes through someone else's infrastructure, even if only briefly.
formatvault parses and reformats CSV entirely in your browser using PapaParse, the same library trusted by data engineering teams at scale. No row of your data is ever transmitted. The file stays on your machine from open to close.
How it works
PapaParse sniffs the first few rows to detect the delimiter automatically — comma, tab, pipe, or semicolon. It then parses the entire file, detects whether the first row is a header, and reformats each row with consistent quoting and your chosen output delimiter.
Files above 1 MB are processed in a Web Worker so the main thread stays responsive. The streaming parser can handle files up to 500 MB without loading the full content into memory at once.
Common use cases
- Cleaning up CSV exports from Excel or Google Sheets with inconsistent quoting
- Normalising delimiter style before importing into PostgreSQL, MySQL, or BigQuery
- Validating that a CSV is well-formed before committing it to a data pipeline
- Re-delimiting a pipe-separated file to comma-separated for tool compatibility
- Formatting customer export data from Stripe, Shopify, or Salesforce without uploading it
- Previewing large CSV files (up to 500 MB) without opening Excel
- Detecting encoding issues and inconsistent row lengths before processing
Frequently asked questions
- Is my CSV data safe to format here?
- Yes. PapaParse runs entirely in your browser — no row of your file is transmitted to any server. This is safe to use with PII, financial records, or any data you would not normally share with a third party.
- What delimiters are supported?
- Comma, tab (TSV), pipe (|), and semicolon. The formatter auto-detects the delimiter in your input and you can choose any of these for the output.
- What is the maximum file size?
- Up to 500 MB. Files above 1 MB are parsed in a Web Worker using PapaParse's streaming mode, so the UI stays responsive throughout.
- Does it handle CSV files with quoted fields containing commas?
- Yes. PapaParse correctly handles RFC 4180 quoting — fields containing the delimiter character, newlines, or quotes are parsed and re-quoted correctly.
- Can I validate that my CSV has consistent column counts?
- Yes. The validator reports rows where the column count does not match the header, helping you catch truncation or extra-field issues before loading into a database.