Free Data & CSV Tools

18 free tools — CSV, JSON, SQL, tables, JSONPath, XPath, and fake data

CSV Viewer

View and explore CSV files in the browser. Sort columns, filter rows, and browse without uploading anything.

CSV to Excel

Turn CSV rows into an Excel-openable workbook you can download and edit in Excel, Numbers, or Google Sheets.

Excel to CSV

Paste a range copied from Excel or Sheets and get clean, properly quoted CSV ready for imports and scripts.

CSV to SQL

Convert CSV into CREATE TABLE and INSERT statements with a table name you choose for quick bulk imports.

CSV to HTML Table

Convert CSV into a clean, semantic HTML table with thead and tbody you can paste straight into a web page.

JSON to HTML Table

Turn a JSON array of objects into a readable HTML table, with keys as columns and each object as a row.

TSV to CSV

Convert tab-separated values into comma-separated CSV with correct quoting for fields that contain commas.

Column Extractor

Pick one or more columns from CSV by header name or index and export just those columns as fresh CSV.

Data Sorter

Sort CSV rows by any column, choosing numeric or alphabetic order ascending or descending, header kept on top.

Duplicate Row Remover

Remove duplicate rows from CSV, matching on the whole row or on a key column you choose, keeping the first.

Data Transpose

Flip a CSV or TSV table so rows become columns and columns become rows, like a spreadsheet transpose.

SQL to CSV

Parse SQL INSERT statements and turn the values back into CSV rows with a header from the column list.

Markdown Table Generator

Convert CSV or TSV into a GitHub-flavored Markdown table with optional column alignment for READMEs and docs.

HTML Table Generator

Build a semantic HTML table from CSV or TSV with a thead header and optional styling classes, ready to copy.

JSONPath Evaluator

Run a JSONPath expression against pasted JSON and see every matching value, useful for testing API queries.

XPath Tester

Evaluate an XPath 1.0 expression against pasted XML using the browser engine and list every matching node.

Fake Data Generator

Generate rows of realistic-looking fake data — names, emails, addresses, phones, dates, UUIDs — as CSV or JSON.

Mock API Generator

Define a schema of field names and types and generate a downloadable JSON response for frontend development.

About Data Tools

Data tools cover the everyday work of moving tabular and structured data between formats: viewing and sorting a CSV, converting CSV to an Excel-openable workbook, SQL inserts, or HTML and Markdown tables, rendering a JSON array as a grid, swapping TSV for CSV, extracting or reordering columns, sorting rows, removing duplicate records, and transposing a table. Every tool parses your data in the browser following RFC 4180 CSV rules, so the file you paste never reaches a server.

Developers and analysts use the JSONPath evaluator and XPath tester to prototype queries against real payloads before committing them to code, the CSV-to-SQL tool to seed a database, and the fake-data and mock-API generators to fill tests and frontends with realistic placeholder records. Spreadsheet users lean on the column extractor, row sorter, duplicate remover, and transpose tools to reshape exports without opening a heavyweight app.

All 18 tools run entirely client-side with no dependencies — fake values come from crypto.getRandomValues, XPath uses the browser's own document.evaluate engine, and every conversion keeps proper quoting so output re-imports cleanly. Nothing is uploaded or logged; close the tab and your data is gone.