How to Convert JSON File to Excel File Using Inbuilt Tool | Importing JSON File into Excel

In this video, we’ll show you How to Convert a JSON File to Excel.
At times, we need to convert a JSON file into different formats, like the xlsx. Here’s how to do it.
Open your spreadsheet.
Go to the Data tab, from the drop-down menu choose the From File option, then choose From JSON.
Find the JSON file on your local disk and click Import.
Click the “To table” option to convert the data into a table.
Click OK.
To expand the columns, tap the double arrow, then choose “expand to new rows”.
Tap the double arrow again and enable the fields you want to show.
Disable the “Use original column name as prefix” option and click ok.
To convert your json data into excel, click the “close and load” button then select “close and load” option .
The data will now be imported into a new worksheet in Excel.
Go to the file tab, select save as and save the file.
That’s it!
❓💬 What other tips do you want to know? Let us know in the comments below.
#HowTech #Excel
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here t.me/howtechtv
✅ Commercial questions [e-mail]
✅ Facebook / howtechtv
✅ Instagram / howtechprojects
✅ Twitter / howtechprojects

[@msaifuljb]

I have been cracking my head and searching for this exact step, and now I have found it. Thank goodness.

[@bharanidharankuppusamy4400]

I do not see the option in my table view!

[@parranoic]

Thank you, very useful. I was missing a couple of steps

[@sivasankarpalpandian2647]

It works for me. Thanks a lot man 😮

[@stuartc6303]

Was missing the clicking the arrow part. Couldn't work out how to expand it and kept getting spreadsheets with just "record" or "list" instead of the actual data I wanted. Thanks for this!

[@MrDash007]

Just awesome, saved me from a lot of work. Keep up the good work.

[@Harshpandey-t4o]

excellent man , thank you

[@coolbrainpictures]

Thank you very much!

[@mprashantg]

This tutorial has been very helpful, thank you for taking time to make this one.

[@nurbekxalilov4337]

Thanks bro this video was very important for me

[@gabrielvsanchez]

You've helped me a lot, thanks!

[@diomedesp]

amazing, thank you

[@jasminepunk]

EXTREMELY HELPFUL. Thanks a lot buddy !

[@rockstaranjan7]

Very Much Thankyou Sir 🥲

[@gladiuskrowten]

Thanks, my friend, excellent job.
Thanks for shared your wisdom and knowledge.

[@cicdsatishsatish5979]

Super , Thank You :)

[@rd2die1]

This has saved my day!

[@matthewwithum8372]

Perfect, thank you.

[@user-pr8kf7ku6i]

I don't have data from file tab in my excel version, how to proceed?

[@markbradwaybennett]

only works for simple json files

[@mvlas4385]

tnx!

[@user-pr8kf7ku6i]

Helpful

[@srikkanthank]

What is the json format you are having?

[@cadskie]

what version of excel you are using???

[@1zenex]

ur mom

[@dropsht]

how do you convert excel file into JSON