Step 3 - Prompt the user for the URL or for the Google Drive Filename Step 2 - Create a custom menu that will let users choose where to import the CSV file from: Google Drive or from a URL Step 1 - Create a new Google Sheets spreadsheet or open an existing spreadsheet Prompting the user for input using Apps Script.įour steps to build an application that will let you import CSV files from a URL or from Google Drive This tutorial assumes that you're familiar with:īasic coding concepts (If you're new to coding, please check out a series of tutorials that I've written on learning to code using Google Sheets and Apps Script.).Īuthenticating and Authorizing Apps Scripts.

This tutorial will show you how to automate the process of importing CSV files by using Apps Script.

While this method works very well, this is a manual process and can be time consuming if your work involves importing lots of CSV files everyday. The CSV file format provides a convenient way to transfer tabular data from one application to another.Ī common way to import CSV data into Google Sheets is by using the Import feature from the File menu. For example, a salesperson might export a list of leads from their CRM system as a CSV file and then import this list into a Marketing Automation product to send emails. In this tutorial, I'll show you how to use Apps Script to automatically import CSV files into Google Sheets from a URL or from Google Drive.Ĭomma-Separated Values (CSV) files are a very common file format for storing tabular data in the business world.

How to import CSV files into Google Sheets using Apps Script

Open csv with google sheets