> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# How do I upload a CSV file to my BigQuery instance?

> Step-by-step instructions for uploading CSV files to your BigQuery data warehouse from your local machine

## Steps

1. From the BigQuery SQL Workspace, find and click the blue “+ ADD” button above your data explorer

   <img src="https://mintcdn.com/sourcemedium/pt-qB7Ich-aAP65i/images/article-imgs/bigquerey-csv-upload-guide/Screen_Shot_2023-05-23_at_3.18.41_PM.png?fit=max&auto=format&n=pt-qB7Ich-aAP65i&q=85&s=55edb4d06ce11d10e6a2cad93992fb0e" alt="" width="1416" height="454" data-path="images/article-imgs/bigquerey-csv-upload-guide/Screen_Shot_2023-05-23_at_3.18.41_PM.png" />

2. In the pane that opens select the location of the file you wish to upload. For a CSV file from your local machine, select “Local file”

   <img src="https://mintcdn.com/sourcemedium/pt-qB7Ich-aAP65i/images/article-imgs/bigquerey-csv-upload-guide/Screen_Shot_2023-05-23_at_3.22.54_PM.png?fit=max&auto=format&n=pt-qB7Ich-aAP65i&q=85&s=a9bc2ee7492c2d4f8b7f20e75df6862d" alt="" width="1966" height="860" data-path="images/article-imgs/bigquerey-csv-upload-guide/Screen_Shot_2023-05-23_at_3.22.54_PM.png" />

3. In the upload form, select the file you wish to upload

   <img src="https://mintcdn.com/sourcemedium/pt-qB7Ich-aAP65i/images/article-imgs/bigquerey-csv-upload-guide/Screen_Shot_2023-05-23_at_3.25.55_PM.png?fit=max&auto=format&n=pt-qB7Ich-aAP65i&q=85&s=16978171034b70a889d945cf219235dd" alt="" width="2802" height="1926" data-path="images/article-imgs/bigquerey-csv-upload-guide/Screen_Shot_2023-05-23_at_3.25.55_PM.png" />

4. Select “CSV” as the File format

5. Specify the project, dataset, and table names where would like it to appear in your BQ instance

6. You can manually specify the schema or select “Auto detect” to allow BigQuery to use the column names as they appear in the CSV

7. Once you've done the above, click the “CREATE TABLE” button

8. You can now search for your table and query it's contents from your data explorer

   <img src="https://mintcdn.com/sourcemedium/pt-qB7Ich-aAP65i/images/article-imgs/bigquerey-csv-upload-guide/Screen_Shot_2023-05-23_at_3.33.08_PM.png?fit=max&auto=format&n=pt-qB7Ich-aAP65i&q=85&s=9e5e21e86f467eb431bfa5086caca443" alt="" width="1296" height="334" data-path="images/article-imgs/bigquerey-csv-upload-guide/Screen_Shot_2023-05-23_at_3.33.08_PM.png" />
