Data tools

Format, validate and convert structured data — JSON, CSV, XML, YAML, SQL and Excel spreadsheets.

19 tools

Tools

  • CSV to JSON

    Convert CSV rows into a JSON array, using the first row as field names.

  • JSON to CSV

    Convert a JSON array of objects into a CSV table you can open in a spreadsheet.

  • Base64 Encode / Decode

    Encode text to Base64 or decode Base64 back to readable text (UTF-8).

  • URL Encode / Decode

    Percent-encode text for use in URLs, or decode %20-style text back.

  • HTML Entities Encode / Decode

    Escape < > & and quotes as HTML entities, or turn entities back into characters.

  • JSON Formatter

    Format and validate JSON with clean indentation — numbers and text are kept exactly as written.

  • JSON Minifier

    Remove all unnecessary whitespace from JSON to make it as small as possible.

  • CSV Formatter

    Clean up CSV: change the separator, trim cells, fix quoting and even out rows.

  • XML Formatter

    Indent XML so its structure is easy to read, and catch unclosed or mismatched tags.

  • HTML Formatter

    Re-indent HTML so nested elements are easy to follow. Scripts and preformatted text are kept intact.

  • SQL Formatter

    Lay out SQL queries with each clause on its own line and consistent keyword case.

  • JSON to XML

    Convert JSON objects and arrays into well-formed XML.

  • XML to JSON

    Convert XML into JSON, with attributes and repeated elements handled predictably.

  • JSON to YAML

    Convert JSON into clean, readable YAML for config files.

  • YAML to JSON

    Convert YAML (including multi-document files) into JSON.

  • HTML to Text

    Strip tags from HTML and keep the readable text, with paragraphs and lists intact.

  • Excel to CSV

    Convert each sheet of an Excel (.xlsx) workbook into a CSV file.

  • Excel to JSON

    Convert the rows of an Excel (.xlsx) sheet into a JSON array of objects.

  • CSV to Excel

    Turn CSV files into Excel (.xlsx) workbooks that open in Excel, Numbers and Google Sheets.

Exact conversions

Converters keep values exactly as written: large IDs keep every digit, and values with leading zeros such as 00123 stay as text. Where a format can’t express something (JSON has no attributes, CSV has no nesting), the tool explains how it was mapped.

Safe with untrusted files

Nothing in your data is ever run. Spreadsheet formulas are never calculated, XML document type definitions and custom entities are refused, YAML custom tags are ignored, and oversized or deeply nested inputs are stopped with a clear message.

Helpful guides

  • How-to

    How to Convert CSV to JSON

    Turn CSV rows into JSON objects using the header row, detect numbers safely, handle semicolons and quoted commas, and convert from Excel.

  • Explainer

    JSON vs XML vs YAML

    How JSON, XML and YAML represent the same data, what each is good at, common gotchas such as YAML’s “no” problem, and how conversion works.

Related categories

Questions about data tools

Which Excel files can I convert?

Modern .xlsx workbooks. Older .xls files need to be saved as .xlsx or .csv first.

Are formulas converted?

Formulas are never calculated. Excel saves the last calculated value of every formula cell, and that value is what you get; the tool tells you how many formula cells there were.