JSON Tick Data to CSV: Convert Trades and Quotes

Tick data often arrives as JSON, one record per trade or quote. A CSV is easier to open, load and share.

Open the JSON to CSV converter, drop the file or paste the data, and download the CSV. A list of records becomes the rows, and nested fields are flattened into columns named by their path. Turn on flatten if your records hold objects inside objects.

Timestamps need attention. Keep the time as it arrives, ideally ISO text or a unix number, rather than letting a spreadsheet reformat it, because a rounded time can break the order of trades. Prices and sizes should be numbers, and symbols should stay text. Open the first and last rows to confirm the order, and use the Data Profiler to look for blank fields and duplicate timestamps.

Size matters with ticks. A day of trades can run to millions of rows. CSV handles that, but Excel stops at 1,048,576 rows, so load the file in a database or script, or use large file mode in the app. If the files are heavy and you read them often, Parquet is smaller and faster.

Everything runs in your browser and nothing is uploaded.

Open the JSON to CSV 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.
CSV to JSON Converter: Convert CSV to JSON 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 JSON to CSV converter: step by step

Open the JSON to CSV converter.
Drop the file or paste the JSON.
Keep flatten on for nested records.
Download the CSV and check the first and last rows.

When to use the JSON to CSV converter

Open JSON trades in a spreadsheet or database
Share a sample of quotes
Check a feed before building a pipeline
Prepare tick data for a script

Example

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

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

Frequently asked questions

How do I convert JSON to CSV?

Drop your JSON file (or paste the data), check the options, click Convert and download the CSV 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: Do not open a tick CSV in Excel and save it again. It can change timestamps and cut rows.