Spreadsheet & Data Converter
Convert spreadsheet workbooks, table exports, and record files between Excel, OpenDocument, CSV, TSV, JSON, and YAML. Files are parsed in your browser, and the report lists anything that did not fit the target format.
Converters
- TSV to CSVConvert tab-separated exports into quoted CSV records.
- CSV to TSVReplace comma separators with tabs while preserving quoted cell text.
- YAML to JSONConvert one YAML document into formatted JSON.
- JSON to YAMLMake JSON configuration easier to read as YAML 1.2.
- JSON to CSVExport an array of JSON objects as a spreadsheet-ready table.
- CSV to JSONTurn spreadsheet rows into JSON records without changing cell text.
- XLSX to XLSExport XLSX values as XLS for compatible data exchange.
- XLSX to ODSExport XLSX values as ODS for compatible data exchange.
- XLSX to CSVExport XLSX values as CSV for compatible data exchange.
- XLSX to TSVExport XLSX values as TSV for compatible data exchange.
- XLSX to JSONExport XLSX values as JSON for compatible data exchange.
- XLSX to HTMLExport XLSX values as HTML for a readable web table.
- XLS to XLSXExport XLS values as XLSX for compatible data exchange.
- XLS to ODSExport XLS values as ODS for compatible data exchange.
- XLS to CSVExport XLS values as CSV for compatible data exchange.
- XLS to TSVExport XLS values as TSV for compatible data exchange.
- XLS to JSONExport XLS values as JSON for compatible data exchange.
- XLS to HTMLExport XLS values as HTML for a readable web table.
- ODS to XLSXExport ODS values as XLSX for compatible data exchange.
- ODS to XLSExport ODS values as XLS for compatible data exchange.
- ODS to CSVExport ODS values as CSV for compatible data exchange.
- ODS to TSVExport ODS values as TSV for compatible data exchange.
- ODS to JSONExport ODS values as JSON for compatible data exchange.
- ODS to HTMLExport ODS values as HTML for a readable web table.
- XLSB to XLSXExport XLSB values as XLSX for compatible data exchange.
- XLSB to XLSExport XLSB values as XLS for compatible data exchange.
- XLSB to ODSExport XLSB values as ODS for compatible data exchange.
- XLSB to CSVExport XLSB values as CSV for compatible data exchange.
- XLSB to TSVExport XLSB values as TSV for compatible data exchange.
- XLSB to JSONExport XLSB values as JSON for compatible data exchange.
- XLSB to HTMLExport XLSB values as HTML for a readable web table.
- CSV to XLSXExport CSV values as XLSX for compatible data exchange.
- CSV to XLSExport CSV values as XLS for compatible data exchange.
- CSV to ODSExport CSV values as ODS for compatible data exchange.
- TSV to XLSXExport TSV values as XLSX for compatible data exchange.
- TSV to XLSExport TSV values as XLS for compatible data exchange.
- TSV to ODSExport TSV values as ODS for compatible data exchange.
- JSON to XLSXExport JSON values as XLSX for compatible data exchange.
- JSON to XLSExport JSON values as XLS for compatible data exchange.
- JSON to ODSExport JSON values as ODS for compatible data exchange.
- JSON to TSVConvert JSON records to TSV with explicit type and structure changes.
- TSV to JSONConvert TSV records to JSON with explicit type and structure changes.
- CSV to YAMLConvert CSV records to YAML with explicit type and structure changes.
- YAML to CSVConvert YAML records to CSV with explicit type and structure changes.
- TSV to YAMLConvert TSV records to YAML with explicit type and structure changes.
- YAML to TSVConvert YAML records to TSV with explicit type and structure changes.
Things to know
- CSV and TSV are flat tables. Nested JSON objects and arrays have to be flattened or written as text to fit in a cell.
- CSV has no data types: every value is text. Numbers, true/false and empty values from JSON or YAML lose their type when written to CSV.
- YAML comments are not part of the data, so they are lost when YAML is converted to JSON.
- Older versions of Excel may show accented characters in a UTF-8 CSV incorrectly. The data itself is fine.
- Workbook conversions export values only. Formulas become saved results; formatting, charts, merged cells, macros and links are removed. Hidden sheets are included unless you select one worksheet.