R Tutorials
Tools
{ }
JSON
</>
XML
YML
YAML
CSV
CSV and Excel
SQL
SQL
64
Encode and Decode
JSON Tools
JSON Viewer and Editor
JSON Validator
JSON Formatter
JSON Minifier
JSON Compare
JSON to CSV
JSON to Excel
CSV to JSON
JSON to XML
XML to JSON
JSON to YAML
YAML to JSON
Excel to JSON
JSON Schema Generator
JSON Schema Validator
JSON to String
String to JSON
All Data Tools
Courses
R Tutorials
Tools
{ }
JSON
</>
XML
YML
YAML
CSV
CSV and Excel
SQL
SQL
64
Encode and Decode
All Data Tools
Courses
SQL Formatter
Format messy SQL into neat, easy to read queries with clear indentation.
SQL Input
UPPERCASE
lowercase
Preserve
File
Format
➔
select u.id, u.username, u.email, count(o.id) as total_orders, sum(o.amount) as total_spent, max(o.created_at) as last_order_date from users u left join orders o on u.id = o.user_id where u.status = 'active' and u.created_at >= '2024-01-01' group by u.id, u.username, u.email having count(o.id) > 0 order by total_spent desc limit 50;
Formatted SQL
Copy
Related tools
See all tools
SQL Minifier
Remove extra spaces and comments from SQL.
JSON Formatter
Make JSON neat and easy to read.
XML Formatter
Make XML neat and easy to read.
YAML Formatter
Make YAML neat and easy to read.
