Saving search results into csv file


#1

Many of you might be familiar with this, I am trying to save a search result into Excel/csv file. Any suggestions?


#2

There may be ready-made tools available that we’re not aware of, but the best solution is to get the standard JSON output (e.g. using twurl), and then use some JSON-to-CSV conversion library to perform the conversion in a second step. There are plenty of options available for that portion - a quick search should point you to several.

Keep in mind that CSV is two dimensional, where JSON can have many nested layers, so you’ll either be losing data or flattening it to get it into CSV.