Convertisseur CSV vers JSON
Paste a CSV file or CSV text and instantly convert it to clean JSON. Auto-detects the header row, handles quoted strings with commas, infers number and boolean types, and outputs either a JSON array or newline-delimited JSON (NDJSON) for streaming.
CSV Input
JSON Output
How to use the CSV to JSON Converter
Paste your CSV data. The first row is treated as headers (column names). The tool handles quoted strings (including embedded commas), infers types automatically (numbers become numbers, "true"/"false" become booleans), and outputs either a JSON array (default) or NDJSON for streaming.
Pourquoi cet outil est important
Many APIs, databases, and analytics tools need JSON — but a lot of data starts as CSV (exports from Excel, Google Sheets, Salesforce, HubSpot). A reliable, quoting-aware converter saves hours of preprocessing. Auto type inference means your numbers stay numbers and your booleans stay booleans without manual fixes.
Cas d'utilisation courants
- Converting a Google Sheets export to JSON for an API call
- Preparing test data for a backend developer
- Building seed data for a database from a spreadsheet
- Converting CRM exports for use in a CMS or marketing tool
- Quick translation between formats during data migrations
- Generating example payloads for API documentation
CSV gotchas the converter handles
Commas inside quoted strings ("Smith, John"), embedded quotes (escaped as ""), trailing whitespace, mixed line endings (Windows CRLF vs. Unix LF), empty trailing lines, and missing values in some rows — all handled. What it does not handle: multi-line cells with literal newlines inside quotes (rare in marketing CSV exports).
Foire aux questions
What is NDJSON?
Newline-Delimited JSON — one JSON object per line. Used in streaming pipelines (BigQuery loads, log aggregators, line-based processors) because each line is independently parseable.
Why is "1.0" becoming a number?
Auto type inference detects numeric patterns and converts. If you need it to stay as the string "1.0", switch the Type inference dropdown to "All values as strings".
Does it handle semicolon-separated values?
Not directly — many European CSV exports use semicolons. Replace semicolons with commas before pasting (or change your export settings).
Can I export the JSON to a file?
Copy the output and save as .json in your text editor. For frequent batch processing, use a script (Python, Node.js) for direct file output.
Building marketing data pipelines and CMS imports at scale?
Riman Agency builds martech and data integration architectures.