# Data converters

- Human page: https://happytails.ai/en/data-tools/
- Markdown: https://happytails.ai/en/data-tools.md
- Structured JSON: https://happytails.ai/agents/en/data-tools/index.json
- Visibility: public

## Page guide

Find the tool you need, then open it to get started.

## All data converters

- [Change CSV delimiter](https://happytails.ai/en/data-tools/change-csv-delimiter/): Parse and reserialize correctly. ([Markdown](https://happytails.ai/en/data-tools/change-csv-delimiter.md))

- [CSV column selector](https://happytails.ai/en/data-tools/csv-column-selector/): Keep selected CSV columns in the order you choose. ([Markdown](https://happytails.ai/en/data-tools/csv-column-selector.md))

- [CSV remove duplicates](https://happytails.ai/en/data-tools/csv-remove-duplicates/): Remove duplicate CSV rows while keeping the first occurrence. ([Markdown](https://happytails.ai/en/data-tools/csv-remove-duplicates.md))

- [CSV to excel](https://happytails.ai/en/data-tools/csv-to-excel/): Create an Excel workbook from CSV text. ([Markdown](https://happytails.ai/en/data-tools/csv-to-excel.md))

- [CSV to geojson](https://happytails.ai/en/data-tools/csv-to-geojson/): Map latitude/longitude columns, validate coordinates and preserve chosen properties. ([Markdown](https://happytails.ai/en/data-tools/csv-to-geojson.md))

- [CSV to HTML](https://happytails.ai/en/data-tools/csv-to-html/): Convert CSV to HTML. ([Markdown](https://happytails.ai/en/data-tools/csv-to-html.md))

- [CSV to JSON](https://happytails.ai/en/data-tools/csv-to-json/): Convert CSV to JSON. ([Markdown](https://happytails.ai/en/data-tools/csv-to-json.md))

- [CSV to markdown](https://happytails.ai/en/data-tools/csv-to-markdown/): Convert CSV to Markdown. ([Markdown](https://happytails.ai/en/data-tools/csv-to-markdown.md))

- [CSV to PDF](https://happytails.ai/en/data-tools/csv-to-pdf/): Column widths, landscape layout and page breaks. ([Markdown](https://happytails.ai/en/data-tools/csv-to-pdf.md))

- [CSV to SQL](https://happytails.ai/en/data-tools/csv-to-sql/): Convert CSV to SQL. ([Markdown](https://happytails.ai/en/data-tools/csv-to-sql.md))

- [CSV to TSV](https://happytails.ai/en/data-tools/csv-to-tsv/): Convert CSV to TSV. ([Markdown](https://happytails.ai/en/data-tools/csv-to-tsv.md))

- [CSV to XML](https://happytails.ai/en/data-tools/csv-to-xml/): Convert CSV to XML. ([Markdown](https://happytails.ai/en/data-tools/csv-to-xml.md))

- [CSV to YAML](https://happytails.ai/en/data-tools/csv-to-yaml/): Convert CSV to YAML. ([Markdown](https://happytails.ai/en/data-tools/csv-to-yaml.md))

- [CSV validator](https://happytails.ai/en/data-tools/csv-validator/): Check CSV headers, quoting and row lengths. ([Markdown](https://happytails.ai/en/data-tools/csv-validator.md))

- [CSV viewer](https://happytails.ai/en/data-tools/csv-viewer/): Preview CSV rows and columns in a readable table. ([Markdown](https://happytails.ai/en/data-tools/csv-viewer.md))

- [Excel to CSV](https://happytails.ai/en/data-tools/excel-to-csv/): Select sheet. ([Markdown](https://happytails.ai/en/data-tools/excel-to-csv.md))

- [Excel to JSON](https://happytails.ai/en/data-tools/excel-to-json/): Sheet/range selection, header rows and cached formula value behavior. ([Markdown](https://happytails.ai/en/data-tools/excel-to-json.md))

- [Geojson to CSV](https://happytails.ai/en/data-tools/geojson-to-csv/): Define supported geometry flattening and property collisions. ([Markdown](https://happytails.ai/en/data-tools/geojson-to-csv.md))

- [HTML table to CSV](https://happytails.ai/en/data-tools/html-table-to-csv/): Pasted HTML only initially. ([Markdown](https://happytails.ai/en/data-tools/html-table-to-csv.md))

- [JSON to CSV](https://happytails.ai/en/data-tools/json-to-csv/): Convert JSON to CSV. ([Markdown](https://happytails.ai/en/data-tools/json-to-csv.md))

- [JSON to excel](https://happytails.ai/en/data-tools/json-to-excel/): Flatten records, select columns and preserve identifiers and dates. ([Markdown](https://happytails.ai/en/data-tools/json-to-excel.md))

- [JSON to HTML](https://happytails.ai/en/data-tools/json-to-html/): Convert JSON to HTML. ([Markdown](https://happytails.ai/en/data-tools/json-to-html.md))

- [JSON to jsonl](https://happytails.ai/en/data-tools/json-to-jsonl/): Convert JSON to JSON Lines. ([Markdown](https://happytails.ai/en/data-tools/json-to-jsonl.md))

- [JSON to markdown](https://happytails.ai/en/data-tools/json-to-markdown/): Convert JSON to Markdown. ([Markdown](https://happytails.ai/en/data-tools/json-to-markdown.md))

- [JSON to SQL](https://happytails.ai/en/data-tools/json-to-sql/): Convert JSON to SQL. ([Markdown](https://happytails.ai/en/data-tools/json-to-sql.md))

- [JSON to TOML](https://happytails.ai/en/data-tools/json-to-toml/): Convert JSON to TOML. ([Markdown](https://happytails.ai/en/data-tools/json-to-toml.md))

- [JSON to TSV](https://happytails.ai/en/data-tools/json-to-tsv/): Convert JSON to TSV. ([Markdown](https://happytails.ai/en/data-tools/json-to-tsv.md))

- [JSON to XML](https://happytails.ai/en/data-tools/json-to-xml/): Convert JSON to XML. ([Markdown](https://happytails.ai/en/data-tools/json-to-xml.md))

- [JSON to YAML](https://happytails.ai/en/data-tools/json-to-yaml/): Convert JSON to YAML. ([Markdown](https://happytails.ai/en/data-tools/json-to-yaml.md))

- [Jsonl to JSON](https://happytails.ai/en/data-tools/jsonl-to-json/): Convert JSON Lines into a JSON array. ([Markdown](https://happytails.ai/en/data-tools/jsonl-to-json.md))

- [Semantic deduplication](https://happytails.ai/en/data-tools/semantic-deduplication/): Local MiniLM embeddings propose similarity groups. ([Markdown](https://happytails.ai/en/data-tools/semantic-deduplication.md))

- [Split CSV](https://happytails.ai/en/data-tools/split-csv/): Split CSV text into smaller files with repeated headers. ([Markdown](https://happytails.ai/en/data-tools/split-csv.md))

- [SQL to CSV](https://happytails.ai/en/data-tools/sql-to-csv/): Convert SQL to CSV. ([Markdown](https://happytails.ai/en/data-tools/sql-to-csv.md))

- [Text classifier](https://happytails.ai/en/data-tools/text-classifier/): Assign your chosen labels to each line of text. ([Markdown](https://happytails.ai/en/data-tools/text-classifier.md))

- [TOML to JSON](https://happytails.ai/en/data-tools/toml-to-json/): Convert TOML to JSON. ([Markdown](https://happytails.ai/en/data-tools/toml-to-json.md))

- [Transpose CSV](https://happytails.ai/en/data-tools/transpose-csv/): Rows-to-columns with header options and empty-cell handling. ([Markdown](https://happytails.ai/en/data-tools/transpose-csv.md))

- [TSV to CSV](https://happytails.ai/en/data-tools/tsv-to-csv/): Convert TSV to CSV. ([Markdown](https://happytails.ai/en/data-tools/tsv-to-csv.md))

- [XML to CSV](https://happytails.ai/en/data-tools/xml-to-csv/): Convert XML to CSV. ([Markdown](https://happytails.ai/en/data-tools/xml-to-csv.md))

- [XML to JSON](https://happytails.ai/en/data-tools/xml-to-json/): Convert XML to JSON. ([Markdown](https://happytails.ai/en/data-tools/xml-to-json.md))

- [YAML to CSV](https://happytails.ai/en/data-tools/yaml-to-csv/): Convert YAML to CSV. ([Markdown](https://happytails.ai/en/data-tools/yaml-to-csv.md))

- [YAML to JSON](https://happytails.ai/en/data-tools/yaml-to-json/): Convert YAML to JSON. ([Markdown](https://happytails.ai/en/data-tools/yaml-to-json.md))

## Choose a format that preserves the information you need

JSON represents structured values and nested objects. CSV and TSV represent rows and columns, making them convenient for spreadsheets and bulk imports. Moving between these formats changes what can be represented directly: a nested object needs a defined mapping to a flat table.

## How to choose your next step

Check the header row, separator, text encoding and a few sample records. Keep identifiers such as 00123 as strings when leading zeros matter. Review empty cells and nested values before exporting.

## Common questions about data converters

### Can JSON and CSV make a lossless round trip?

Not in every case. CSV does not carry JSON data types or nested structure. Decide how numbers, nulls, missing values and nested arrays should be represented rather than assuming a reverse conversion restores them.

### Why does a comma create an extra column?

A separator inside a cell must be quoted using the rules of the file format. Newlines and quotation marks inside cells also need proper escaping. Changing the delimiter can help, but it does not repair malformed quoting.
