How to Import or Export CSV?

CSV (Comma-Separated Values) is a plain text format widely used for storing tabular data, while JSON (JavaScript Object Notation) is a very popular data exchange format in web development. In different application scenarios, you may need to convert data between CSV and JSON.

Import CSV

JSON For You supports converting CSV to JSON format, and also supports exporting JSON to CSV format.

  1. Click the "Upload" button in the sidebar and select CSV as the file type;
  2. Click the red dashed box and select your CSV file in the pop-up dialog;
  3. JSON For You will automatically convert the CSV data to JSON format and display it in the left editor, while the original CSV data will be displayed in the right editor.

CSV to JSON Example

Input CSV file:

name,age,city
John,30,New York
Jane,25,London

Converted to JSON (with header):

[
  {
    "name": "John",
    "age": 30,
    "city": "New York"
  },
  {
    "name": "Jane",
    "age": 25,
    "city": "London"
  }
]

JSON to CSV

Exporting JSON to CSV makes it easy to import data into spreadsheet software (such as Excel, Google Sheets) for further analysis and visualization.

JSON For You supports converting JSON to CSV format and downloading it locally.

  1. Paste the JSON data into the left editor;
  2. Click the "Export" button in the sidebar and select CSV as the file type;
  3. Click the "Preview" button, and the converted CSV data will be displayed in the right editor;
  4. Click the "Download" button to save the JSON data as a CSV file.

JSON to CSV Example

Input JSON data:

[
  {
    "product": "Laptop",
    "price": 1200,
    "in_stock": true
  },
  {
    "product": "Mouse",
    "price": 25,
    "in_stock": false
  }
]

Exported CSV file:

product,price,in_stock
Laptop,1200,true
Mouse,25,false