Sheet to BigQuery
🚀A few clicks to have your Google Sheet in BigQuery
BEFORE
Your Google Sheet
🪄AFTER
Table in BigQuery
How to put Google Sheet's data to BigQuery table
🚀 Dear Business Leaders,
The solution is here
The First 1-2-3 Sulution om Marketplace
With our revolutionary Cooltables add-on, you need a few clicks to:
1️⃣ Load Google Sheets to Google BigQuery
2️⃣ LINK your data to the BQ table!
1
Choose sheet to upload
2
Set BigQuery endpoints:
database
project
3. Load!
Finally, click the button:
Load my Data to BigQuery
You are a few clicks away.
Convert your Google Sheets to powerful BI.
Forget about infinite loading and Spreadsheet cell limits!
Set up once
The add-on will remember what you did.
Every step you make! 😱
Load your Sheet to BigQuery
It does what is says.
Please wait a bit, the loading won't take long.
You're done!
What's next:
Rename the task to spot it more easily.
Jump to the BigQuery table you've just created!
View your tasks
✅We save all the tasks you run.
The add-on will show you the last 20.
Use the history to modify and replay your tasks.
FAQ
How to install the add-on?
—Follow this link to install the add-on.
How can I get help with the add-on?
—The add-on was created and is run by 1 person. And I'm so ready to help!
Fill out this form if you see any errors or you need help.
How do you request new features?
—We plan new features and develop the dynamic modern add-on for you.
You can contact, or follow us for the latest updates:
How do you prepare the data for loading to BigQuery?
—You should have a sheet with tabular data, including headers.
The add-on will detect the rest:
Table position
Table headers
Column datatypes
What makes this add-on better than others?
—We have an innovative data-detecting script, called Tabler.
It captures data, detecting data even on a messy sheet like this:
How to get started
Install the add-on:
1. Click on the direct link to the Cooltables add-on installation screen.
2. Confirm the installation by clicking on 'Install'.
Use the add-on in Google Sheets:
3. Open the Google sheet where you intend to use the add-on.
4. Click the Extensions menu, and navigate to Cooltables > Show Sidebar.
6. Select Sheet to BigQuery.
7. Select a sheet and the details of your Google BigQuery destination, then click 'Run'.
After the task runs successfully, the data from Google Sheet will be loaded into your BigQuery.
👉Tip. Remember to check the 'Home' tab in the Cooltables add-on for the list of your tasks. You can rename, re-run tasks, and see task statistics.