Can I generate a file from Google Sheets script?

google-apps-script google-sheets google-apps
Charles Randall picture Charles Randall · Aug 22, 2011 · Viewed 12.2k times · Source

I'm using Google Sheets to prototype a bunch of numerical data for something I'm doing.

Is there a way to export a subset to a text file?

Effectively, what I'm aiming to do is export a file I can include directly in the build for another project.

So is there a way to generate a text file for download?

Answer

Jan Kleinert picture Jan Kleinert · Aug 23, 2011

If you have a Google Apps account, then you can use DocsList.createFile() to create the text file and save it in your documents list.

Section 3 of this tutorial shows how to save the selected range of a spreadsheet as a file in your documents list in CSV format. It could be modified pretty easily to save in a different format.

Related questions

Script to summarise data not updating

I have a Google spreadsheet of timesheet data; it has a sheet for each month, each sheet is a lot of six column blocks, one block per client. I have created a summary sheet that goes and gets the total …

Read More
If var isnumber, for script

I need to run a script which contains the logic: If isNumber, Then DoSomething. I've run other such if then tests such as if blank, and if cell contains "x". It should be simple but I can't find a solution. …

Read More
Open Google Docs Spreadsheet by name

I have a situation where a script is taking input data and sending it to a spreadsheet. After a while, this spreadsheet becomes too big. Right now we have to manually move the items from the the primary spreadsheet to …

Read More