How to Convert a JSON File to Microsoft Excel

Microsoft Excel logo on a green background.

Have you received a JSON file that you’d like to convert to Microsoft Excel format? Excel offers a built-in option to help you import it without third-party parsing tools. Here’s how you can do it.

RELATED: How to Parse JSON Files on the Linux Command Line with jq

To convert your JSON file to Excel, you will first connect Excel to your JSON data. You’ll then review the JSON data, select the columns you’d like to bring to your Excel file, and finally load the data into an Excel spreadsheet.

You will then save that spreadsheet as an XLSX file, and your JSON to Excel conversion is done.

Import a JSON File Into an XLSX File

To start parsing a JSON file, open Microsoft Excel on your computer and start a new spreadsheet.

On the spreadsheet window, in Excel’s ribbon at the top, click the “Data” tab.

Click the

On the “Data” tab, from the “Get & Transform Data” section, select Get Data> From File> From JSON.

Click Get Data> From File> From JSON.

You will see your computer’s standard “Import” window. Here, open the folder where your JSON file is located. Double-click the file to connect it to Excel.

Choose the JSON file.

Excel will open a “Power Query Editor” window. Here, you will decide how JSON’s data will be loaded in your spreadsheet. First, at the top of the window, click the “To Table” option. This turns your data into a table.

Click the

In the “To Table” prompt, click “OK.”

Select

To choose which columns to keep in your spreadsheet, next to “Column1,” click the double-arrow icon.

In the menu that opens, choose the columns you’d like to keep. Then, deselect the “Use Original Column Name as Prefix” option and click “OK.”

Select the columns to keep and click

Your JSON file’s data is now visible in Excel-style columns and rows.

Preview of JSON data in Excel.

If you’d like to remove or change the positions of your columns, right-click a column and choose an appropriate option.

Modify JSON data columns.

When you’re happy with the result, add your JSON data to your Excel spreadsheet by clicking “Close & Load” in the window’s top-left corner.

Click

Your Excel spreadsheet now has your JSON data in it. You can play around with this data however you want. For instance, you can remove the table formatting or even convert the table to a range.

JSON data in an Excel spreadsheet.

Finally, to save this JSON data in Excel format, click “File” in Excel’s top-left corner.

Click

In the left sidebar, click “Save.”

Select

Your computer’s standard “save” window will open. Here, select a folder to save your file in, type a name for your file, and click “Save.”

Select a folder to save the Excel file in.

And that’s it. The Excel version of your JSON file, complete with the .xlsx extension, is now available in your specified folder. Cheers!


Want to convert a Google Sheet to Excel? It’s even easier to do that.

RELATED: How to Convert a Google Sheet to Microsoft Excel

Note: This article have been indexed to our site. We do not claim legitimacy, ownership or copyright of any of the content above. To see the article at original source Click Here

Related Posts
When Will Kids' COVID Vaccines Be Available? thumbnail

When Will Kids’ COVID Vaccines Be Available?

When Tonya Zerkle, a mom in Cincinnati, Ohio, found out that Ontario, Canada was vaccinating any children who turn 12 by the end of the year, she wasted no time. After confirming with Canadian officials that her American 11-year-old was eligible and checking with border authorities on requirements to visit, she and her family headed…
Read More
Quantum Complexity Tamed by Machine Learning thumbnail

Quantum Complexity Tamed by Machine Learning

In 2018, climate simulations were the third-largest use of computing cycles at a leading U.S. supercomputing cluster. The study of quarks and other subatomic particles came in second. Topping the list was the most heavily cited idea in the physical sciences — though few have ever heard of it. “It’s ridiculously important,” said Kieron Burke,…
Read More
Astronaut Luca Parmitano on NASA's return to the moon: 'It's no longer a dream' (exclusive) thumbnail

Astronaut Luca Parmitano on NASA’s return to the moon: ‘It’s no longer a dream’ (exclusive)

News Spaceflight Luca Parmitano preparing for flight. (Image credit: ESA/NASA) Helping to inject enthusiastic support for the Italian space industry, distinguished European Space Agency (ESA) astronaut Luca Parmitano recently appeared as the keynote speaker at the "Space It Up" conference in Houston, Texas to promote six innovative startups from his homeland entering the global space
Read More
Index Of News
Consider making some contribution to keep us going. We are donation based team who works to bring the best content to the readers. Every donation matters.
Donate Now

Subscription Form

Liking our Index Of News so far? Would you like to subscribe to receive news updates daily?

Total
0
Share