Export Multiple Sheets to TSV Using Macro Button

Question

EDIT *I copy and pasted from Google Sheets: Exporting to TSV however how do i get it to get the data only from a select few sheets and not every sheet? thank you *

I've tried looking online for answers, but I'm not that great at Script Editing yet,

I'm trying to make a Macro that when I click a button (already Made) it will export 7 sheets to TSV on my G Drive, preferably in a folder named with today's date (With the file named as the stores '1' '2' etc (name of the sheets).

When I tried the record Macro all I got was the following,

function DownloadOrders() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('1'), true);
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('2'), true);

Any help would be greatly appreciated!

J. G. J. G. · Accepted Answer · 2019-02-14T22:39:40

It looks like you want to use the script you found but modify the "saveAstsv()" function and add the "make one tsv function);

function saveAstsv() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  // create a folder from the name of the spreadsheet
  var folder = DriveApp.createFolder(ss.getName().toLowerCase().replace(/   /g,'_') + '_tsv_' + new Date().getTime());

  makeOneTsv("Sheet A",folder);
  makeOneTsv("Sheet B",folder);


  Browser.msgBox('Files are waiting in a folder named ' + folder.getName());
}



function makeOneTsv(sheetName,folder){
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
fileName = sheet.getName() + ".tsv";
var tsvFile = convertRangeTotsvFile_(fileName, sheet);
folder.createFile(sheetName, tsvFile);



}

I haven't tested this but it should do what you want if you remove any typos.

Export Multiple Sheets to TSV Using Macro Button

1 Answers