Convert CSV to JSON

How to use Convert CSV to JSON

1. 1. Paste your CSV data. Paste comma-separated rows exported from a spreadsheet or database, including the header line if there is one. Each row becomes one object in the resulting JSON array.
2. 2. Set the header and type options. Turn on First row is header so column names come from the first line instead of being treated as data, and Parse numbers and booleans to convert values like 45 or true into their real JSON types.
3. 3. Pick the output indent and copy. Choose 2 spaces, 4 spaces or tabs for the Indent setting, then copy the resulting JSON array and use it in your application, an API test, or a seed script.

When to use Convert CSV to JSON

Convert CSV to JSON turns a spreadsheet export or database dump into a JSON array of objects that a JavaScript application, an API client or a test suite can consume directly. It handles headers and type conversion so a plain-text spreadsheet becomes structured, typed data.

• Loading a spreadsheet export into an application. A colleague sent you a CSV file with user data and your application only reads JSON, so you need each row converted into a proper object before importing it.
• Building test fixtures from real spreadsheet data. You have a small CSV sample of production-like data and want it as a JSON array of objects to use as seed data in a test database.
• Converting a CSV export for an API request. An admin exported a list of records as CSV and you need to send that same data as a JSON array in a bulk-create API call.
• Migrating a legacy CSV-based data source. An older system stores its data as CSV files, and you are moving that data into a JSON document store or a JSON-based configuration.

Examples

name,age
Ada,36
Grace,45

[
  {
    "name": "Ada",
    "age": 36
  },
  {
    "name": "Grace",
    "age": 45
  }
]

About the Convert CSV to JSON tool

Frequently asked questions