Select your Google account from the drop-down list, then click Continue.You can easily change the destination and export data from Google Drive to Excel or BigQuery. With the Google Drive source, you can also import Excel to Google Sheets from GDrive. Click Continue to proceed with the destination setup. Select a CSV file on your Google Drive that you want to export to Google Sheets.Click Connect, select and sign in to your Google account.Read more about the CSV importer and how to import CSV to Google Sheets.Ĭonfigure the importer as follows : Set up the data source (Google Drive) If you want to export CSV data from a publicly stored CSV, you’ll need to choose CSV as a source app. Sign up to Coupler.io using your Google account, click Add new importer and select Google Drive as a source app and Google Sheets as the destination app. Coupler.io, for one, is an easy-to-use tool that helps consolidate data from different apps and sources to Google Sheets, Excel, or BigQuery. Let’s take a look at how you can use Coupler.io to insert a CSV file, stored on a Google Drive, into a Google spreadsheet.

If you are looking for a scalable, automated way to import CSV data from Google Drive, Coupler.io is a convenient option to consider. – 50 IMPORTDATA requests per spreadsheet.Īutomated CSV import from Google Drive with Coupler.io – Instant integration of multiple apps with Google Sheets in one place – No coding or tech background is required. If you hesitate which option to choose, check out the following comparison table between manual vs. It’s available as a web app and an add-on for Google Sheets. It lets you manually import CSV files from GDrive, but the drawback is that you’ll have to make your files publicly shareable and edit their URLs in a special way to do the job.Ĭoupler.io is a tool to automate importing data from various sources (CSV, BigQuery, and other) and updating it on a set schedule without human supervision. IMPORTDATA is a native function to fetch CSV and pull data to spreadsheets. IMPORTDATA or Coupler.io? Which way to go with to import CSV from GDrive into Google Sheets

Import csv to google sheets