![]() Source = Json.Document(File.Contents(“C:\Users\my.json”)), #”Converted to Table” = Record.ToTable(Source) Replace C:\Users\my.json with your file name and path: In older versions of Excel (Office 2010 - Office 2013), you'll need to use Power Query, and in the Advanced Query editor enter the path to your file and build a query like this: ![]() If your flattened JSON data is less than a million rows, and depending on your computer's performance, you may be able to import the JSON to Excel. (If you're looking to open a big CSV file, check out our other post.) Unfortunately, that's not a lot of data in today's world. Since the release of MS Office 2007, the number of rows supported by Excel has been 1,048,576. Even then you'll be limited by the max number of rows Excel can support. That's it! When you're done simply export the file as a CSV.Įxcel can work with JSON files to some extent, and the process varies depending on which version of Microsoft Excel you have installed. Once opened you can filter, sort, split columns, and more.
0 Comments
Leave a Reply. |