Copy, paste, and save the following code.

Create a new Google Sheet, and open the script editor ( Tools > Script editor).

We will write a script to create a custom menu, search through the files for a user-supplied search term, and display the results in a Google Sheet. In this section, we assume have some files stored in your Google Drive. Section 1: Searching your Google Drive and displaying matching files

Section 3: Saving a selected Range to a CSV file.

Section 2: Importing data from a CSV file.Section 1: Searching your Google Drive and displaying matching files.This tutorial is divided into the following sections: Defining custom menus in Google Sheets.Using the script editor and have experience using basic spreadsheet functions.Time to Completeīefore you begin this tutorial, you should already be familiar with: This tutorial shows how to search the files in your Google Drive and display the results and how to import from and export to CSV files which are saved in your Google Drive. So for my penance below is a reworking of Tutorial: Interacting With Your Docs List CC-BY Google Inc. One of the really nice things about the Google Developers site is most, if not all, the documentation is released under Creative Commons Attribution 3.0 License.

Given the tutorial I referenced was written in May 2010 it’s not surprising given the updates in Apps Script that it’s now out of date and the tutorial itself should probably be carrying a deprecated notice.

+ Marcos Gomes then pointed out that the tutorial uses the Docs List Service that was deprecated on Decem… doh. Shortly after + Andrew Roberts kindly pointed out that Apps Script includes a parseCsv method … doh. In particular this tutorial included a function to parse a. I saw the question come in over my phone and knowing it was very achievable directed the person to the Interacting With Your Docs List tutorial on the Google Developers site as a starting point. A question came in on the Google Apps Script Google+ Community which in part was asking about parsing.

Google sheets to csv