Unformat.online
More tools
Clean Text
Remove formatting, fix smart quotes, and clean pasted text.
Format JSON
Prettify or minify JSON in seconds.
Format SQL
Beautify SQL queries with syntax-aware formatting.
Format YAML
Lint and format YAML files instantly.
Format XML
Indent and pretty-print XML documents.
FileSQL
Query CSV & JSON files with SQL, right in your browser.
Shredder
Strip GPS, Exif, author info, and API keys from images, PDFs, and logs.
CronScope
See exactly when your cron jobs fire on a 12-month calendar.

About Unformat.online

What it is

Unformat.online is a free developer toolkit for cleaning text, formatting JSON and SQL, querying files with SQL, stripping hidden metadata from images, PDFs, and logs, and visualizing cron job schedules — all in your browser, nothing sent to any server.

We built this to solve the “Notepad dance” problem that developers face constantly: copying text from Slack, PDFs, documentation sites, and emails that carries invisible formatting garbage. Smart quotes that break code. Zero-width characters that cause mysterious syntax errors. Non-breaking spaces that mess up string comparisons.

Core features

The main text tool has three modes: Clean (removes smart quotes, zero-width characters, hidden formatting), Format JSON (beautifies and validates JSON with auto-fix for common errors like single quotes and trailing commas), and Format SQL (beautifies queries for MySQL, PostgreSQL, BigQuery, SQLite, and T-SQL with proper indentation and keyword capitalization).

FileSQL lets you drop a CSV or JSON file and query it directly with SQL in your browser, powered by DuckDB Wasm — no upload, no server.

Shredder strips hidden metadata from files before you share them: GPS coordinates and Exif data from photos, author names and edit history from PDFs, and API keys, IP addresses, and auth tokens from log files and configs.

CronScope is a visual cron expression visualizer. Paste any cron expression and see a 12-month calendar of every trigger date, with timezone support and a frequency safety check that flags expressions running too often — all computed locally in your browser using croner.

Technology & privacy

Built with Next.js, TypeScript, and Tailwind CSS. Uses the sql-formatter library for SQL beautification and native JavaScript APIs for text cleaning and JSON formatting.

Everything happens in your browser. Your text, files, and queries never leave your device. No server processes your data, no tracking, no analytics beyond basic visitor counts. This is especially important when working with sensitive photos, internal documents, API responses, and database queries.

Who builds this

Unformat.online is an independent project, started to solve a daily developer frustration and shared freely to help others save time and avoid copy-paste formatting headaches. Get in touch if you have feedback or ideas.