Fidument Tools · Beta version

How do I convert CSV to JSON?

Convert a CSV file into an array of JSON objects in your browser. Keep leading zeros and empty fields.

Need to send a CSV list of products, orders or line items as JSON?

How to use this tool

  1. Choose the CSV file

    Save your source as UTF-8 and put unique column names in the first row.

  2. Check the delimiter

    Use automatic detection or choose comma, semicolon or tab.

  3. Download the JSON file

    Select “Convert to JSON”. Review the row and column counts and the preview.

Preparing an import

Each object uses the CSV headers as keys. If the destination expects numbers or booleans, set the field types in the import settings.

Who is it for?

  • People transferring spreadsheet data to apps and integrations

Input

  • CSV UTF-8

Output

  • JSON

Capabilities

  • Save your source as UTF-8 and put unique column names in the first row.
  • Use automatic detection or choose comma, semicolon or tab.
  • Select “Convert to JSON”. Review the row and column counts and the preview.

Limitations

  • Up to 2 MiB, 20,000 data rows and 100 columns. Output up to 8 MiB.

Example use

The CSV code 001 becomes the text “001” in JSON.

Questions and answers

Where is my data processed?

Processing takes place in the browser on your device.

Related tools

Compare CSV files

Match two lists by an ID or compound key. Find changed, missing and duplicate records in your browser.

CSV to JSON

Check access and export conditions in the app. A product description does not grant access.