I'm working on a research project and a research partner has provided me with a massive file of data from his website, which I need to be able to analyze. I've tried importing the file into excel, but it's awkward and figuring out an effective way to delineate the data has proven nearly impossible. Is there any program or technique to take the JSON file and organize the data into something resembling a spreadsheet? (Ultimately, I need to sample the data, but only for a couple variables, for my data analysis. I need to get it into some sort of spreadsheet-type format or something that is visually, if not functionally, similar that would allow me to figure out how many datapoints I have in the relevant categories and to randomly sample them)
Thanks for any help!