Skip to main content
Question

Convert JSON Array of Key/Value Pairs into Readable Text or Separate Fields

  • November 9, 2025
  • 1 reply
  • 16 views

Forum|alt.badge.img+1

Hi everyone 👋
I’m importing data into Airtable, and one of the fields arrives as a JSON array that looks like this:

[
{ "key": "Label", "value": "Sample A" },
{ "key": "Code", "value": "0716" },
{ "key": "Category", "value": "Lotus" }
]

Instead of showing the raw JSON, I’d like the field to display something more readable, for example:

Label: Sample A
Code: 0716
Category: Lotus

I tried changing the field type and using simple formulas, but it still shows the full JSON array.

Has anyone done this before?
Is there a formula, script, or automation that can parse this JSON?

Any suggestions would be really helpful, thank you!

 

1 reply

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9787 replies
  • November 9, 2025

Other people might have other ideas for solving this, but for me personally, I would just use Make’s JSON tools combined with Make’s Airtable tools to parse the JSON and put it into Airtable however you would like.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable. 

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld