How-to Guides

Our comprehensive guides are designed to help you make the most of your JSON data processing needs. Whether you're new to working with JSON or looking to streamline your data conversion workflow, these step-by-step instructions will guide you through each process clearly and efficiently.

From understanding the basics of JSON tables to converting complex JSON structures into various formats like Excel, CSV, or ZIP archives, our guides cover everything you need to know. Each guide includes practical examples and detailed explanations to ensure you can successfully transform your data into the format that works best for your needs.

1. What is a JSON Table

   A core principle of our tool is to treat JSON data as tabular data.

   Here we describe how this works, with examples of what it looks like.

   Our examples include both arrays and nested objects which typically cause most difficulties for users of other platforms.

2. How to convert a full JSON file to Excel™ or Sheets™

   Following on from the idea that JSON data can be treated as tabular data, here we show you how to convert your JSON data to the Excel™ and Sheets™ .XLSX format.

   We describe your different options, including single or multi-sheet downloads, as well as 'All-Data' vs 'Selected' data only.

3. How to convert a full JSON file to a zipped collection of CSV files

   Similar in many ways to the above Excel downloads, this guide shows you how to convert your data to a compressed set of CSV files.

   There are pros and cons to CSV vs Excel, but the choice is yours.

4. How to convert a single table of JSON data to CSV

   This guide described how to download a single table of JSON data as CSV, without adding to a zip file.