CSV to JSON Converter

CSV to JSON Converter is used to convert CSV data or file into JSON format. You can choose whether the property names are auto-generated or taken from the header row in the CSV. Property names can also be transformed using various naming strategies such as: Camel Case, Lower Case, Upper Case & Snake Case The JSON output can be indented for easier viewing. Source delimiter is automatically detected but can also be manually overriden. The JSON output varies itself according to various strategies. Check out the setting descriptions below.

Converted on ToolSlick's server. Your input and its output are not stored.

Paste CSV content below
Converted JSON

Settings

How the input is converted. Each is explained below.

History

  • 2017-09-03Major overhaul of settings
  • 2017-08-25Tool Launched

Settings explained

Delimiter
What separates the fields of the input, or Auto Detect to work it out.
Header Transform Type
How the column names are changed to make the JSON property names.
Output Type
The JSON's shape: Properties (an object per row), Column Arrays, Row Arrays, Dictionary Object or Dictionary Array.
First Row Is Header
Whether the first row holds the column names; without it the columns are numbered.
Indent
An indented output is easier to read; a compact one is smaller.

Background

CSV to JSON Array

  1. Paste CSV data in the input or select a CSV file from your system
  2. Configure any conversion settings such as delimiter type, whether first row is header
  3. Hit the convert button to convert your CSV into JSON

CSV

CSV is an old & very popular format for storing tabular data. It has been used in the desktop as well as mainframe. It is a simple & compact format that works really well for tabular data and so is still in use today.

JSON

JavaScript Object Notation (JSON), pronounced as Jason, is the most common data interchange format on the web. Douglas Crockford first released the JSON specification in the early 2000s. It is a simple format that is easier to comprehend than XML. It is also smaller in size because it does not have closing tags. A wide variety of programming languages can parse JSON files. They also support the serialization of data structures to JSON. You can copy JSON text to JavaScript and start using them without any modifications.

Related tools