How to Set Date to YYYY-MM-DD Format in Google Sheets?

You may run into issues with your date column during uploads:

  1. Uploads failing because of incorrect formatting of your date column – this applies mainly to Manual option under Data Types.
  2. TIMESTAMP (2020-03-05 11:00:00 UTC) data type being uploaded instead of DATE (2020-03-05) – this applies mainly to Autodetect option under Data Types.

If you are about to upload a table via Manual or Autodetect option with a date column, it’s important to make sure the date column is formatted as YYYY-MM-DD.

Real life example for Manual option:
Date Col as DATE

BigQuery is quite sensitive to data types and it only accepts DATE data type in YYYY-MM-DD format. So your date needs to look like 2020-05-30 (=May 30th, 2020) and not like 5/30/2020 for example.

Here is how to achieve YYYY-MM-DD formatting in Google Sheets:

Date as YYYY-MM-DD

Once you set your date column to YYYY-MM-DD and upload your spreadsheet to BigQuery, your column will really look like a date in BigQuery schema:

Date as YYYY-MM-DD Loaded to BQ

 

And then as YYYY-MM-DD date in Preview:
Date as YYYY-MM-DD Loaded to BQ v2

The same formatting procedure applies if you are using Autodetect.

And that’s all!

Back to Help Center  Buy License Now

2 thoughts on “How to Set Date to YYYY-MM-DD Format in Google Sheets?

  1. Pingback: BigQuery Uploader for Google Sheets 2.0 Released! – Mythical Reports

  2. Pingback: Cookie lišta v PPC: Jak jsme se poprali s výpadkem dat po nasazení cookie lišty – Karel Rujzl

Leave a Reply

Your email address will not be published. Required fields are marked *