Useful Hacks

Data Tools

Work with tabular data without opening a spreadsheet app — view, format, deduplicate and convert CSV, and generate SQL from raw data. Processed locally in your browser.

All data tools

CSV Viewer

View a CSV file as a formatted table.

CSV Formatter

Clean up CSV formatting and convert between delimiters.

CSV to JSON

Convert CSV data to a JSON array of objects, with a delimiter choice and a header-row toggle.

JSON to CSV

Convert a JSON array of objects to CSV, with delimiter choice and nested-data flattening.

Data Deduplicator

Remove duplicate rows from CSV data.

Column Extractor

Extract specific columns from CSV data.

SQL IN Clause Generator

Turn a list of values into a ready-to-paste SQL WHERE...IN (or NOT IN) clause.

SQL Insert Generator

Generate SQL INSERT statements from CSV data, one per row or batched into a single statement.

Frequently asked questions

Related categories

Developer PDF Image Finance

Search tools

Search for any tool by name, category or keyword