Ever wondered how to upload MULTIPLE sheets in bulk from one Google Sheet into Google BigQuery? Look no further. You just found solution!
As you may already know, BigQuery web UI allows you to use a Google Sheet as data source for your BigQuery tables. The problem is that it can only be ONE sheet from your Google Sheet. On the top of that, it’s always the FIRST sheet created in your Google Sheet.
Our FREE BigQuery Uploader for Sheets solves both problems - you can upload multiple sheets from your Google Sheet or just one sheet regardless whether it was created as the first sheet in the doc or not.
The setup is quite easy process. After adding our add-on into your Google Sheets, start with pressing “Create Config Sheet” button via add-on’s menu. This will create new sheet called “BqUploadConfigSheet”, where you just enter your project ID, dataset ID and table name. You can also choose if you want to truncate existing table in Big Query or if you want to just append the rows from the current sheet to your BigQuery table. When you are done, just press “Upload Sheets” button and let the magic work for you. Few seconds later, you will see status of your upload on the newly created “BqLogSheet” and you should see your tables in BigQuery.
Extore is a team of professionals who are passionate about creating extensions for web browsers. This devotion also gives us opportunity to appreciate work of other people. We get inspired by useful, open source extensions made by developers all over the world. Our strong belief is that one should share helpful add-ons with others. That’s why we’d like to present you our ever-growing list of favourite extensions that have inspired us. Moreover, as you probably have already learned, sometimes struggling for the best brings an end to the good. Talking about add-ons it often turns out that an upgrade is worse then previous version. Also it can become really tricky to get back to the beloved version of your favourite extension. That’s why we’re going to make not only the latest, but all versions of our favourite (and we hope yours too) add-ons available for download. No more compromises, just stick to the version you really like!
Preparing download link, please wait for seconds
Almost done...
Click to download
Error getting file. Please try again
