17.5. Bringing a Google Sheet into BigQuery

In this lesson, we're going to explore how to import your Google Sheet data into BigQuery as a table. We will cover two different methods, starting with the simplest one: importing a CSV file.

Importing GA Data as a CSV

First, let's export the GA data in CSV format:

1. Go to your Google sheet.
2. Click on File > Download > Comma-separated values (CSV).
3. Save the file to your desired location.

Now that you have downloaded the GA data as a CSV file, let's bring it into BigQuery.

Creating a Table in BigQuery

Follow these steps to create a table from the downloaded CSV file:

1. Go to BigQuery and navigate to your dataset (make sure it's empty).
2. Right-click on the dataset and click Create Table.
3. You will be presented with options for creating your table.

Selecting File Source

Choose these options:

• Create table from: Select "File".
• Click Browse and select the previously downloaded CSV file (sample_data_ga_data.csv).