URL for BI & Spreadsheets: Google Sheets

Modified on Thu, 25 Apr 2024 at 02:46 PM


You can connect live data in Gigasheet to Google Sheets using the IMPORTDATA function in Google Sheets.


How to get there

Step 1: Open your Google Sheets document.

Step 2: In an empty cell (usually the top left), type the following formula: 


Step 3: Replace "https://your-gigasheet-url-to-csv-file.csv" with the URL provided by Gigasheet in the File > URL for BI & Spreadsheets dialog. Enclose the URL within double quotes in your formula.

Step 4: Press Enter. The data from the live Gigasheet file will be imported into your spreadsheet. For large files, IMPORTDATA might take a few minutes to complete the import.

The imported data will be updated automatically if the linked Gigasheet data changes. You can format the imported data as needed using Google Sheets' formatting tools.

Things to Consider

  • File Size: Google Sheets limits the number of cells per sheet. Row limit is at 10,000. 
  • File Location: The URL you provide must match the link provided by Gigasheet’s URL for BI & Spreadsheets dialog. Other URLs won’t work.
  • Data Refresh: Gigasheet automatically refreshes the data for continuous updates, but large data sets make take a few minutes to update in Google Sheets.

Additional Tips

You can test the URL in a private browser window to verify its accessibility.

If encountering issues, consider downloading the CSV locally and importing it from your computer to Google Sheets to test compatibility.

Still having issues? Contact us at support@gigasheet.com

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article