Home » Tools

Import Excel / CSV File into BigQuery table


Import file into Database

Copy and paste the CSV file contents / Excel spreadsheet table cells here

Easily import your CSV file or excel spreadsheet table data in to your BigQuery table. This utility automatically creates the table as well the insert commands to load the data into the BigQuery table. Simple paste your data in the below textbox and click on the convert button




How to Import Excel File into BigQuery Table

  1. Open your excel spreadsheet and go to the sheet that contains the data that you want to import
  2. Highlight the data cells, including the headers. And copy the data into Clipboard
  3. Paste the data in the textbox in this page
  4. Click on the convert button
  5. Now you can copy and paste the SQL Commands in your database client and execute them to create the table

How to Import CSV File into BigQuery Table

  1. Right click on the CSV file and Choose "Open With" and select notepad
  2. Copy the contents of the notepad (Including headers)
  3. Paste the data in the textbox in this page
  4. Click on the convert button
  5. Now you can copy and paste the SQL Commands in your database client and execute them to create the table

What is BigQuery?

BigQuery is a cloud-native data warehouse service from Google. BigQuery is fully managed cloud datawarehouse solution offered as SAAS. It has a unique architecture that separates storage and compute, thereby resulting in unlimited horizontal scalability. It can scale the number of compute slots during peak times, thereby supporting numerous concurrent users

Privacy policy

SQL Generation is done within your browser using JavaScript. We don't send your input data to our servers. Its totally private and secure

Terms of use

  • No usage limits: You don't need an account to use our tools. All tools are free of charge and you can use them as much as you want
  • We're not liable for your actions and we offer no warranty

Remember to ⭐Bookmark this site




SQL.info