XLSX to TSV

Your files never leave your device.

Choose a format
Choose a format

Each sheet becomes its own TSV file. Cells are saved as Excel displays them, so formulas become their results.

Questions about XLSX to TSV

How does XLSX to TSV work?

XLSX to TSV writes each sheet of an Excel workbook to its own tab-separated file, using the values as they appear on screen: formulas give their results, and formatted numbers and dates are written as displayed. Colours, fonts and other styling are not kept. Commas in your data need no quoting in TSV.

Is a number written as 1234.5 or £1,234.50?

As the spreadsheet shows it. Cells are written with their number format applied, so a currency cell gives £1,234.50 and a percentage gives 25%. If you want the raw values, XLSX to JSON keeps numbers unformatted.

When are values quoted in the TSV?

Only when they contain a tab, a double quote or a line break, or start or end with a space. Commas need no quoting, so most rows come out as plain text separated by tabs.

Are empty rows kept?

Yes. Blank rows between your data are written as empty rows in the TSV rather than being removed.