Efficient way to store and search through large data set?

[tatiang]

I tried storing the full JSON response in a Google Spreadsheet but it wouldn’t allow a single cell with that much data (19,000 JSON records!!!). So then I tried to loop over the full JSON as a list and populate the spreadsheet rows with JSON values. But it only filled about 30 cells and then stopped.