Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to import JSON array as CSV?

Topic Labels: ImportingExporting
566 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I want to import a JSON dataset. I know I can’t import JSON, but I know I can convert the JSON first to CSV, which is importable.

The problem with that is my dataset contains arrays inside the JSON object, eg.:

         "variations": [
            227,
            329,
            229,
            190,
            119,
            123,
            152,
            155
         ]

In a JSON-to-CSV convertor, this comes out as multiple columns, variations/1, variations/2, variations/3 etc

That is not appropriate since, in Airtable, I want the “variations” field to be a Multi-select.

How can I accomplish this?

2 Replies 2

I use Integromat for this, which is a low-code automation & integration platform with full support for Airtable. Integromat is setup to process JSON by default.

But you could probably also write your own custom JavaScripts to handle this as well.

There might be other ways of doing this, too.

That’s the method that I would recommend, @Robert_Andrews. The Scripting app allows you to ask the user for a file, so you could directly load the JSON file, parse it, and update your base accordingly.