Yogesh Joshi iyogeshjoshi
👾
iyogeshjoshi
/ download_all_sheet_as_csvs.gs
Created
March 13, 2015 06:48
Downloads all sheets in a google spreadsheet file into to folder in your google drive :). Click on tools > script editor, then Create blank script project and paste the code there. Go back to your spreadsheet, you'll see the 'csv' menu in the spreadsheet menu. enjoy :)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onOpen() { | |
| var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
| var csvMenuEntries = [{name: "export as csv files", functionName: "saveAsCSV"}]; | |
| ss.addMenu("csv", csvMenuEntries); | |
| }; | |
| function saveAsCSV() { | |
| var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
| var sheets = ss.getSheets(); | |
| // create a folder from the name of the spreadsheet |
NewerOlder