How do I import a sitemap CSV into BigQuery?

Upload the CSV to a Google Cloud Storage bucket, then create a BigQuery table from it: BigQuery → Create Table → Source = Google Cloud Storage → File format CSV → tick 'Auto-detect schema'. The schema becomes one column per CSV column (URL, lastmod, changefreq, priority, source). For lastmod values in W3C/ISO 8601 format, change that column's type from STRING to TIMESTAMP for date-range queries. If you're loading huge sitemaps regularly, automate with the bq command-line tool: bq load --autodetect dataset.sitemap gs://bucket/sitemap.csv. JSON exports (see /sitemap-to-json) work too and preserve nested data better, but CSV is faster to ingest and cheaper to store.