Dev Tools for Data Analysts
Data analysts frequently move data between formats — CSV from exports, JSON from APIs, SQL queries for database extraction, and YAML for configuration of data pipelines. The tools in this collection help you transform, inspect, and clean data without needing to write one-off scripts for every format conversion. From diffing two CSV snapshots to find changed records, to converting API JSON responses into spreadsheet-ready CSV, these tools handle the format-translation work so you can focus on analysis.
Convert CSV data to a JSON array of objects.
Convert a JSON array of objects to CSV format.
Convert CSV (comma-separated) to TSV (tab-separated) format.
Convert TSV (tab-separated) to CSV (comma-separated) format.
Compare two CSV files row by row and highlight added, removed, and changed cells.
Upload and view CSV files as a formatted table.
Format and beautify SQL queries with proper indentation and uppercase keywords.
Convert tab- or pipe-separated SQL CLI output into clean CSV format.
Convert CSV data into SQL INSERT statements with auto-detected column types.
Pretty-print and format JSON with proper indentation.
Compare two JSON objects and highlight added, removed, and changed keys.
Compute structural statistics for any JSON: depth, type counts, array lengths, key frequency, and size.
Convert YAML to JSON with proper structure and types.
Convert XML to a JSON object using recursive element traversal.
Convert Unix timestamps to human-readable dates and vice versa.
Calculate the exact difference between two dates.
Compare two texts side by side and highlight differences.
Find text and replace it with options for case sensitivity and regex.
Remove duplicate lines from text while preserving order.
Sort text lines alphabetically, numerically, or in reverse order.
Count words, characters, sentences, and lines in any text.
Count characters, unique characters, and find the most frequent character in text.
FAQ
- How do I convert an API JSON response to a CSV I can open in Excel?
- Paste the JSON array into the JSON to CSV converter and it flattens the structure into a spreadsheet-ready CSV with automatic column headers. For nested JSON, it joins keys with dots. Download the result and open directly in Excel or Google Sheets.
- How do I compare two versions of a CSV export to find what changed?
- Use the CSV Diff tool to upload or paste two CSV files and see a row-by-row comparison showing added rows, removed rows, and modified cells highlighted. This is faster than Excel's manual comparison for large exports.
- How do I generate test data to validate my analysis pipeline?
- The CSV Data Generator and Fake Data Generator create realistic datasets with configurable fields (dates, names, numbers, emails). Define the schema and row count, then export as CSV or JSON to test your import scripts, transformation logic, and aggregation queries before running on production data.