CSV - JSON Converter

This converter lets you convert CSV to JSON and JSON to CSV. Just paste your CSV or JSON and then click the convert button. It uses the Ace embeddable code editor to add editing and error checking. It checks if you JSON is well-formed. If errors are found they are highlighted in the left gutter on the lines that errors were found. Hover over the error icons to see a description of the error. If there are errors found correct them and click the convert button again.

This editor works entirely in your browser. Your CSV/JSON is not sent to any server. If you close the browser or tab the current state of the editor is saved. If you don't want your CSV/JSON saved remember to clear the editor before closing. We value Privacy!

What is JSON?

JSON is:

• a "lightweight" syntax for storing and exchanging data
• an acronym of JavaScript Object Notation
• language independent - JSON is text only and can be read and used by any programming language
• self-describing and easy to read.

What is CSV?

CSV:

• is an acronym of Comma Separated Values
• is plain text using a character set such as ASCII, UTF-8, etc
• is a set of records - typically one record per line, and each record divided into fields separated by delimiters (typically a single reserved character such as comma, semicolon, or tab). This converter automatically detects delimiters.
• is a file where every record has the same sequence of fields
• are to create being just plain text
• allow you to organize large amounts of data
• are easy to import into a spreadsheet or another database

How are CSV files used?

CSV files can be used with many spreadsheet applications, such as Microsoft Excel or Google Sheets. CSV files only allow a single sheet in a file, and you cannot not save formulas.

Example JSON formats that can be converted to CSV:

[
                ["1-1", "1-2", "1-3"],
                ["2-1", "2-2", "2-3"]
              ]

[
                {
                  "Column 1": "foo",
                  "Column 2": "bar"
                },
                {
                  "Column 1": "abc",
                  "Column 2": "def"
                }
              ]

{
                "fields": ["Column 1", "Column 2"],
                "data": [
                  ["foo", "bar"],
                  ["abc", "def"]
                ]
              }
              

Example CSV format:

One,two,three
              1,2,3
              4,5,6
              7,8,9
              10,11,12
              

Editor Features

• Open a local CSV o JSON file
• Download your converted code to a file
• Specify whether to use first row for field names when converting from CSV to JSON
• Syntax highlighting
• Automatic indent and outdent
• Live syntax checking
• Handles large documents
• Search and replace with regular expressions (Ctrl-F)
• Highlight matching parentheses
• Drag and drop text using the mouse
• Line wrapping
• Code folding
• Multiple cursors and selections
• Cut, copy, and paste