FG
💻 Software

Import json data into Excel

Fresh5 days ago
Mar 15, 202654908 views
Confidence Score0%
0%

Problem

I have a text file in json format and want to read it into Excel. A very simplified example of the json file has the following structure: I want to convert it to Excel in which each record becomes a row in excel with the selected parameters as the column headers.

Error Output

{ [
  { 'a': 10, 'b': 20 },
  { 'a': 20, 'b': 22 },
  { 'a': 11, 'b': 24 }
] }

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Import json data into Excel

Low Risk

You can do this in VBA with the library. Here's an example of some code I copied:

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment