What is JSON?
It’s an incredibly compact format that requires a lot less storage space than XML and it’s even a lot more easier to read! But even in a beautified form, when we try to read something is missing – you got it, it’s not in a spreadsheet!
Import JSON to Google Sheets
One easy way to import JSON to Google Sheets is with the Google Sheets Add-on KPIBees. With just a few clicks, JSONs can be imported into Google Sheets.
Step 1: Go to the KPIBees Gsuite Marketplace listing and install the Google Sheets Add-on.
Step 2: Grant access to KPIBees on your Google account – we are GDPR compliant!
Step 3: Open any google spreadsheet and go to Add-ons in the page menu and click on Launch.