Forum Discussion
No option to load JSON file into EXCEL?
Fresh download of Office 365 today.
Data - Get Data has no menu item to import (load) JSON file.
Why not?
7 Replies
- Hello JSTcanuck99 Did you check From File Drop Down? If its not there please let us know what is the version and build numbers and maybe you can try and update again. Maybe something happened during the download???
- Data - New Query - From File - From Text
opens file directory where I change .txt to all file types
then load .JSON file type.
Where do I see version and build info?
ThanksHumJSTcanuck99 That is strange when you get to From File you do not see the From JSON option?
You can see the installation information by using the File menu then all the way on the bottom choose Account and then About Excel and you will see the version and build numbers near the top of the displayed dialog.
