Forge Json

Convert CSV to JSON Online

Paste CSV text or spreadsheet exports and convert them to JSON online in your browser, with headers, quotes, delimiters, and type inference handled for you.

Paste your JSON → Get results instantly (no signup)

⚡ Instant resultsNo signupRuns in your browser
Try examples:

→ Parse this CSV text into JSON rows.

name,age,city
Alice,30,New York
Bob,25,London
Output✓
1[
2  {
3    "name": "Alice",
4    "age": 30,
5    "city": "New York"
6  },
7  {
8    "name": "Bob",
9    "age": 25,
10    "city": "London"
11  }
12]

Love the result?

Use this exact pipeline in your app, backend, or LLM workflow.

No setup needed. Works with curl, Node, Python.

Uses example data. For edited input, copy from the playground.

Read integration guide

Works with:

  • Excel and Google Sheets exports
  • CSV text pasted from files
  • Quoted fields and embedded commas
  • JSON arrays for downstream tools

Example: input → output

Convert CSV to JSON online

CSV to JSON online means converting pasted CSV in the browser, without installing a package, opening a terminal, or sending the file through a backend upload flow.

This page is for privacy-sensitive browser conversion. Paste rows from Excel, Google Sheets, a data export, or a .csv file and inspect the JSON result before it leaves your device. The live tool uses the same engine as the CSV to JSON Converter, but the reason to use this page is simple: quick conversion, no install, no server handoff.

Why online conversion is safer for samples

  • You can inspect the JSON shape before committing to an import script.
  • You avoid uploading customer samples, vendor exports, or internal spreadsheet rows to a generic converter.
  • You can test delimiter, quoting, and header behavior in seconds.
  • You can hand the output to Clean JSON, Normalize JSON, or JSON Schema Validator without switching tools.

Online conversion is not a replacement for a production import job. It is the review step before the job: "Does this CSV turn into the JSON shape I expect?"

Browser workflow

  1. Paste CSV text into the input panel.
  2. Confirm whether the first row is a header row.
  3. Run the browser conversion.
  4. Review the JSON array.
  5. Copy the result or continue with cleanup, validation, or export.

For API request bodies, use CSV to JSON API. For code examples, use CSV to JSON JavaScript or CSV to JSON Python.

CSV to JSON online example

Input CSV:

id,name,active
1,Ada,true
2,Grace,false

Output JSON:

[
  { "id": 1, "name": "Ada", "active": true },
  { "id": 2, "name": "Grace", "active": false }
]

Each column becomes a key. Each row becomes one object in the array. If the first row is not a header, use CSV to JSON without headers instead.

Browser vs API conversion

Conversion modeBest forWatch out for
Browser CSV to JSONSamples, privacy review, one-off shape checksManual paste/copy
API CSV to JSONRepeatable imports and backend workflowsContract validation and request limits
Scripted CSV to JSONVersioned code and scheduled jobsParser edge cases and type handling

Use the browser page when you need confidence before automation. Move to API or script workflows when the same conversion repeats.

CSV conversion ecosystem

ForgeJSON currently covers the stable conversion loop: CSV to JSON, JSON to CSV, JSON to Excel, and API response formatting. TSV, XML, and native Excel-to-JSON pages should only go live when dedicated converters exist, so users never land on a page that overpromises the engine.

Frequently asked questions

Why use an online CSV to JSON converter?+

Use it to inspect the JSON shape in the browser before installing a parser, writing code, or building an import workflow.

Does online CSV to JSON conversion keep headers?+

Yes. When headers are enabled, the first row becomes the field names for each JSON object.

What delimiters are supported?+

Common delimiters such as commas, semicolons, tabs, and pipes are supported, with explicit delimiter control for unusual files.

Can I convert quoted CSV cells?+

Yes. Quoted commas, escaped quotes, and embedded newlines are handled before the rows are converted to JSON.

When should I move from browser conversion to an API or script?+

Move to an API or script when the job repeats, needs scheduling, must process very large files, or has production reliability requirements.

Related tools

Read more on the blog

Advanced usage (optional)

CSV to JSON

v1.0.0
Convert
stringreversible

Description

CSV to JSON

Parse CSV text into a JSON array of objects. Supports multiple delimiters, automatic type inference, header row detection, and whitespace trimming.

How It Works

The utility reads CSV text (string input) and converts each row into a JSON object. Column names come from the header row (if enabled) or are auto-generated as col1, col2, etc.

Type Inference

When enabled, the parser automatically converts values:

  • "30" → 30 (number)
  • "true" / "false" → true / false (boolean)
  • Empty values → "" (empty string)

Disable type inference to keep all values as strings.

Configuration

FieldTypeDefaultDescription
Delimiterenum,Field separator: ,, ;, \t (tab), or `\` (pipe)
First Row is HeadersbooleantrueWhether the first row contains column names
Infer TypesbooleantrueAuto-convert numbers and booleans (disable for all-string output)
Trim WhitespacebooleantrueRemove leading/trailing whitespace from values
Skip Empty LinesbooleantrueIgnore blank rows in the CSV input

Use Cases

Data Import

  • Spreadsheet data: Convert exported CSV from Excel or Google Sheets into JSON
  • Database exports: Parse database dump CSV files for processing
  • Log files: Parse tab-delimited log files into structured objects

Format Conversion

  • API preparation: Convert CSV data into JSON format for API requests
  • Configuration files: Parse semicolon-delimited config files
  • Data migration: Convert legacy CSV data to JSON for modern systems

Data Cleaning

  • Type normalization: Use type inference to convert string numbers to actual numbers
  • Whitespace cleanup: Automatically trim messy CSV data
  • Empty row removal: Skip blank lines in poorly formatted CSV files

Configuration

NameTypeDefaultDescription
Delimiterenum,Character used to separate fields in the CSV , ; \t |
First Row is HeadersbooleantrueWhether the first row contains column names
Infer TypesbooleantrueAuto-convert numbers and booleans (disable for all-string output)
Trim WhitespacebooleantrueRemove leading/trailing whitespace from values
Skip Empty LinesbooleantrueIgnore blank rows in the CSV input

Examples

AI Prompt
Parse this CSV text into JSON rows.
name,age,city
Alice,30,New York
Bob,25,London
Output✓
1[
2  {
3    "name": "Alice",
4    "age": 30,
5    "city": "New York"
6  },
7  {
8    "name": "Bob",
9    "age": 25,
10    "city": "London"
11  }
12]
Config
Delimiter
,
First Row is Headers
ON
Infer Types
ON
Trim Whitespace
ON
Skip Empty Lines
ON

API Usage

POST /api/v1/utilities/convert.csv-to-json
Example:
curl -X POST https://your-domain.com/api/v1/utilities/convert.csv-to-json \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"inputs":{"primary":"name,age,city\nAlice,30,New York\nBob,25,London"},"config":{"delimiter":",","hasHeaders":true,"inferTypes":true,"trimWhitespace":true,"skipEmptyLines":true}}'
Response
1[
2  {
3    "name": "Alice",
4    "age": 30,
5    "city": "New York"
6  },
7  {
8    "name": "Bob",
9    "age": 25,
10    "city": "London"
11  }
12]