Export multiple spreadsheets to csv

[Quirin]

Hi,

I have collected a lot of spreadsheets (several hundred) full of tweets using TAGS. Thanks again for making that possible.

I now need to convert (and merge) my spreadsheets in the csv format for doing data analyses. Is there a way to download/export/convert all my sheets in one go? As you can imagine, downloading them one by one would be extremely hard now, plus I’ll continue collecting data and will thus continually need to do that.

Best,
Quirin

[mhawksey]

Not tried myself but perhaps this add-on can help https://chrome.google.com/webstore/detail/sheetgo/baljgggfhdleglaneclmjhhmflaombln

Let us know how you get on 🙂

Martin

[Quirin]

Hi Martin,

Thanks for your suggestion!

I haven’t tried it because I’ve used a simple workaround:

* I download all the files as .xlsx which works fine because one can select multiple files for download from Google Drive.
* I batch-convert them using ssconvert to .csv on the Command Line

Best,
Quirin

[Author]

Posts