Product Feed CSV to JSON for Shop APIs

Many shop and marketplace APIs take JSON, while catalogues are kept as CSV.

Open the CSV to JSON converter

Open the CSV to JSON converter and drop the feed. Turn on type detection so prices and stock become numbers, and keep SKUs and barcodes as text.

JSON is a list of records, each with named fields. Numbers and true/false stay as such when type detection is on, but ids and codes with leading zeros should stay text. Choose pretty JSON to read it, or compact JSON to save space.

Check one record against the API documentation: field names, required fields and number formats. Test with a small batch first, because a failed bulk upload can be slow to undo.

Everything runs in your browser and nothing is uploaded.

Open the CSV to JSON converter

Related tool pages

  • JSON, CSV, Parquet and Excel Converter: Convert between JSON, CSV, Parquet and Excel online for free, one file or a whole folder. It runs in your browser, so nothing is uploaded.
  • JSON to CSV Converter: Convert JSON to CSV in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.
  • CSV to Parquet Converter: Convert CSV to Parquet in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.
  • JSON to Parquet Converter: Convert JSON to Parquet in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded.
  • Parquet to CSV Converter: Convert Parquet to CSV in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.
  • Parquet to JSON Converter: Convert Parquet to JSON in seconds. Drop a file and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.

How to use the CSV to JSON converter: step by step

  1. Open the CSV to JSON converter.
  2. Drop the feed and turn on type detection.
  3. Check a record against the API rules.
  4. Download JSON.

When to use the CSV to JSON converter

  • Load products through an API
  • Feed a web front end
  • Test an integration
  • Share a catalogue as JSON

Example

Input: id,name,age 1,Ada,36 2,Alan,41

Output: [{"id":1,"name":"Ada","age":36},{"id":2,"name":"Alan","age":41}]

Frequently asked questions

How do I convert CSV to JSON?

Drop your CSV file (or paste the data), check the options, click Convert and download the JSON result.

How big can a file be?

It depends on your device. A few hundred MB usually works.

Which conversions does the Format Converter support?

Any direction between JSON, CSV, Parquet and Excel (.xlsx), for one file or a whole folder. Nested JSON is flattened into columns such as address.city. For Excel, the first sheet is read; old .xls files are not supported.

Why did my number or date change after converting?

Types are detected from the values. Turn off "Detect types" to keep everything as text, which also keeps leading zeros in IDs and phone numbers.

Tip: Test with 10 products before a bulk upload.