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 T-SQL Online

Beautify Transact-SQL (T-SQL) for Microsoft SQL Server with proper indentation and keyword formatting. Paste your T-SQL and get clean, readable output — 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

T-SQL / SQL Server formatting

Transact-SQL (T-SQL) is Microsoft SQL Server's procedural SQL extension. It includes SQL Server-specific syntax like TOP, NOLOCK hints, square-bracket identifiers [like_this], DECLARE variables, BEGIN...END blocks, stored procedure syntax, and GO batch separators.

Using the T-SQL dialect ensures that SQL Server-specific constructs are correctly recognized and formatted — square bracket identifiers are preserved, TOP clauses are handled, and PRINT statements are formatted properly.

How to format T-SQL queries

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

Other SQL formatters