Jan 05 2018
11:14 AM
- last edited on
Jul 12 2019
11:00 AM
by
TechCommunityAP
Jan 05 2018
11:14 AM
- last edited on
Jul 12 2019
11:00 AM
by
TechCommunityAP
I have a JSON file that I would like to import into Excel
I have Office 365
I am using the following:
Use Excel's Get & Transform (Power Query) experience to connect to a JSON file.
Feb 26 2019 06:43 PM
Aug 01 2021 10:54 PM
Your answer only repeats the process that's shown on Microsoft for the process, which is what the first questioner shows he has done but then has link to pay a $59.90 licence for another XML converter.
What is needed in someone with greater knowledge Microsoft Tech to give an answer to allow the Microsoft process to work correctly.
I also have the same problem getting just data column headings, after clicking on the Query after conversion and downloading 1.5 GB of records but nothing showing again. I've done this twice and still no success.
Someone on Microsoft Tech please help with a real answer ? ? ?
Aug 21 2021 10:22 PM