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.
On the “Data” tab, from the “Get & Transform Data” section, select 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.
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.
In the “To Table” prompt, click “OK.”
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.”
Your JSON file’s data is now visible in Excel-style columns and rows.
If you’d like to remove or change the positions of your columns, right-click a column and choose an appropriate option.
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.
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.
Finally, to save this JSON data in Excel format, click “File” in Excel’s top-left corner.
In the left sidebar, click “Save.”
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.”
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.
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
Aqua Original 4-in-1 Monterey Hammock Pool Float & Water Hammock – Multi-Purpose, Inflatable Pool Floats for…
$16.99 (as of June 28, 2024 21:10 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Hiearcool Waterproof Phone Pouch, Waterproof Phone Case for iPhone 15 14 13 12 Pro Max, IPX8 Cellphone Dry Bag…
$9.99 (as of June 28, 2024 21:10 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Oura Ring Gen3 Sizing Kit - Size Before You Buy The Oura Ring - Unique Sizing - Receive Credit for Purchase
$10.00 (as of June 28, 2024 21:10 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Apple AirPods (2nd Generation) Wireless Ear Buds, Bluetooth Headphones with Lightning Charging Case Included, Over…
$89.00 (as of June 28, 2024 21:10 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
