Csv

I had a Google Apps spreadsheet with around 40 sheets. Wanted to export them to csv. Unfortunately Google only lets you export one sheet at a time. Here’s a script that exports all sheets in a spreadsheet to csv To use, click on tools –> script editor. Then create a new blank script and paste the code there. Click on the play button (run) and go back to your spreadsheet. »

Sometimes you might want to export your Mongodb database in csv format. If you have many collections, it can be a bit of a hassle since mongoexport requires you to specify each field you want to be exported with the --fields attribute and you have to do it for each collection seperately. Here’s a little bash script that will do the work for you. Result is a .csv file for each collection you have in your db. »