Unformat.online
More tools
Clean Text
Strip smart quotes, zero-width characters, non-breaking spaces, and invisible Unicode from any pasted text.
Format JSON
Prettify or minify JSON. Auto-fixes single quotes, trailing commas, and unquoted keys.
Format SQL
Format SQL for MySQL, PostgreSQL, BigQuery, T-SQL, and more — uppercase keywords, proper indentation.
Format YAML
Format and validate YAML. Catches indentation errors in Kubernetes, Docker Compose, and GitHub Actions files.
Format XML
Indent and pretty-print XML. Works with SOAP, RSS, Maven POM, Android manifests, and SVG.
Markdown Viewer
Live split-view editor and renderer — edit on the left, preview on the right.
FileSQL
Drop a CSV or JSON file and query it with SQL instantly — no upload, no server.
Shredder
Remove EXIF, GPS, and author metadata from images and PDFs. Redact secrets from text and log files.
CronScope
Paste a cron schedule and see every run on a 12-month calendar. Never misread a cron expression again.
JWT Debugger
Decode JWTs instantly — view all claims, check expiry, and see the algorithm. Token never leaves your browser.
Base64
Encode text or files to Base64, or decode Base64 strings and preview images inline.
URL Encode / Decode
Encode URLs or decode percent-encoded strings like %20, %3D, %26 — instantly.
UUID Generator
Bulk-generate cryptographically random v4 UUIDs using crypto.randomUUID(). Copy one or all at once.

Format BigQuery SQL Online

Beautify Google BigQuery SQL with proper indentation and keyword formatting. Paste your BigQuery SQL and get clean, readable output instantly — 100% client-side.

Rules:Smart QuotesConverts curly quotes (“” ‘’) to straight quotes. Always active.Non-Breaking SpacesReplaces non-breaking spaces (U+00A0) with regular spaces. Always active.Line EndingsNormalizes CRLF → LF and trims trailing whitespace per line. Always active.Removes invisible zero-width characters (U+200B, U+200C, U+200D) that silently break string comparisons.Strips the Byte Order Mark (U+FEFF) that causes “invalid character” errors in parsers and editors.Removes soft hyphens (U+00AD) from PDFs that show as garbled characters in code editors.Converts mixed tabs/spaces to a consistent indent width. Click to pick a size.Collapses all line breaks into one continuous paragraph. Great for reflowing PDF or email text.Control blank line density. Click to pick Keep 1 or Remove all.Text never leaves your browser
0 characters

BigQuery SQL formatting

Google BigQuery uses Standard SQL with extensions for large-scale analytics. Its dialect includes backtick-quoted project and dataset references like `project.dataset.table`, ARRAY_AGG, STRUCT, UNNEST, analytic functions, and INFORMATION_SCHEMA views.

Using the BigQuery dialect ensures that backtick identifiers, nested repeated fields, and BigQuery-specific functions are formatted correctly without being misinterpreted as standard SQL.

How to format BigQuery SQL

  1. Paste your BigQuery SQL query into the text area above.
  2. The formatter is pre-set to BigQuery dialect. Toggle UPPERCASE keywords as needed.
  3. Copy the formatted output with the Copy button or Ctrl+K.

Other SQL formatters