Related Posts
Any Recruiter here?
Need help
What’s everyone doing today babes 🧐
Hey fishes need 11 likes help me out
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.





Lol, within the data tab, you can just insert data from a JSON file and then manipulate it how you wish using power query.
Some options, and the one caveat is if the file contains nested arrays:
- Use a web JSON to Excel converter (easiest, security risk)
- Write simple Python script to import JSON, export CSV (simple, if you know how)
- Use Excel Power Query (more work, but better if data is complicated)
Hopefully the number of rows isn’t above the the limit excel can handle otherwise your data will be incomplete so be on the lookout for that