Practical guides

Data Conversion Guides

Practical guides for converting structured data between formats — CSV, JSON, XML, YAML, TSV, SQL INSERT statements, TypeScript interfaces, and JSON Schema — without uploading files to any server.

Converting CSV to JSON

Paste CSV data into the CSV to JSON tool. The first row is treated as headers, and each subsequent row becomes a JSON object. Empty cells produce empty string values. The output is a formatted JSON array ready for APIs, test fixtures, or JavaScript imports. For the reverse, JSON to CSV flattens a JSON array into a comma-separated table.

Converting between JSON and YAML

JSON to YAML converts any valid JSON document into YAML format with proper indentation — useful for Kubernetes configs, GitHub Actions workflows, and any tool that prefers YAML over JSON. YAML to JSON does the reverse, turning YAML config files into JSON for tools that require it.

Generating SQL INSERT statements from CSV

CSV to SQL Inserts takes a CSV file (first row as column names) and outputs a batch of INSERT INTO statements. Set the table name before converting. Values are automatically quoted and SQL-escaped. Useful for populating test databases or migrating spreadsheet data to a relational schema.

Generating TypeScript interfaces from JSON

JSON to TypeScript analyses a JSON object or array and infers a TypeScript interface definition. It detects optional properties (fields that are null or missing in some objects), handles nested objects recursively, and generates union types for mixed arrays. Paste the output directly into your TypeScript project as a starting type.