Spreadsheet and data tools

Reshape tabular data for the tool that has to read it next, from a spreadsheet export to a clean JSON payload.

  • 4 browser tools available
  • 4 run in your browser
  • No account

How it works

The same three steps every time

Choose a tool marked Runs in your browser, add your file and download the converted result. Tools marked Not available yet cannot convert files.

About spreadsheet and data conversion

CSV is simpler than it looks, and harder than it looks

A CSV file is just text, which is why every tool can read it, and there is no single standard for it, which is why so many tools read it wrongly. Commas inside quoted fields, escaped quotes, line breaks inside a cell, semicolons instead of commas in European exports and a stray byte order mark from Excel all break naive parsers. These converters handle the format as specified, so a field like "Smith, John" stays one value.

Types are where data gets lost

The dangerous part of a conversion is not the separator, it is the type guessing. A product code of 0071 becomes 71, a phone number becomes scientific notation, and a date in one country order is read in another. CSV input is converted conservatively: leading-zero codes remain text, and ordinary numbers and booleans become typed values. JSON dates stay as written. Excel exports use stored cell values and formatting; check dates and identifiers in the receiving application before importing.

Spreadsheet and data conversion: common questions

Will Excel mangle my CSV?

CSV is plain text, so Excel may guess column types and change leading zeros or date formatting when opening it. Use the import dialog to select UTF-8 and text columns where needed. JSON-to-CSV includes a UTF-8 byte order mark; Excel-to-CSV does not.

Are the data tools private?

The CSV and JSON converters run entirely in your browser, so a customer list or a finance export is never transmitted. CSV to Excel and Excel to CSV also run inside your browser. No file is uploaded.

What happens to formulas?

These converters do not calculate spreadsheet formulas. Excel-to-CSV exports stored results when available. Recalculate and save the workbook in your spreadsheet application first; CSV-to-Excel stores formula-like input as text.

Elsewhere on the site

Other categories