4/22/2023 0 Comments Excel for mac new queryOne of the websites you can use to convert json to xslx is json csv. i would like the output to look like this: the issue i'm having is figuring out how to to transform the data based on my data i have. ![]() I would like to import the json file into excel, i am using power query as i'm not versed in vba. as a result, the new window would pop up on your screen called – ‘power query editor’. in the ‘import data’ dialog box that appears, navigate and search for the json file. Open a new excel workbook and navigate to data tab > get & transform data group > get data > from file > from json.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |