![]() ![]() Unfortunately, the data doesn't flatten properly, so I just get a column of single-field data with the text. Delimiter = None Extra Columns = Show as errors. Right-click List in centre pane, next to "item" field name. Select file test.json (included below).Ĥ. Data | Get Data | From File | From JSONģ. I know Office is the wrong tool to use, but Word does excel at formatting, and that's a critical part of my ultimate goal (the Word side is now working, incidentally).Ģ. I'd like to import the data in this file into Excel in a flattened form that I can then massage into what will become a mail merge data source to automatically build a document. Configure the connection to the JSON API and the query using the. Save it as test.json or something similar. Specify the JSON URL to import data from Step 3. I've taken one of those and simplified it before pasting below. I have a "public" data source stored as 20-odd JSON files. Rather than trying to fully understand them, I'd just like some help solving one, single, active problem: how to import the JSON file below into Excel. Whether it is the actual input file or the CSV or Excel template, the import API works with data formatted in JSON. ![]() Using JSON files outside whatever their native environment is (JavaScript, presumably) is a major pain in the backside. ![]()
0 Comments
Leave a Reply. |