Quoted commas, doubled quotes and line breaks inside a cell are read the way the CSV convention says they should be. Each field is then judged on its own: currency signs and commas come off, and if what is left is digits it becomes a number you can sum. Everything else stays text. The sheet carries no formatting. The header row is not bold and the columns are not widened.
The spreadsheet writer is a few kilobytes of our own code. No million-byte library is downloaded. Your file is read on your own machine and never sent anywhere. Open your browser’s network tab and watch while you use it.
Field by field. A dollar, pound or euro sign and every comma are removed first; if what is left is digits, with at most a leading minus sign and one decimal point, it is written as a number, and (840.50) becomes -840.50. A space inside the value keeps it as text. Spaces at either end are trimmed before that test, so a padded 1000 still becomes a number.
It is written as a number cell, so the leading zeros are gone and you get 123. Every field made only of digits goes the same way, and there is no setting here to hold a column as text. If those zeros have to survive, this is not the right converter for that column.
Then the whole line arrives as a single column, because only the comma separates fields. A file like that usually writes decimals as 1.234,56 as well, and every comma comes off before the number test, so 1.234,56 turns into 1.23456 — wrong, and quietly. Change the separator and the decimal mark before converting.
No. 2024-03-01 does not pass the number test, so it is written as text exactly as it appears. It reads correctly in the cell, but Excel does not treat it as a date until you convert the column yourself.
Everything here is free and works the same way, in your browser.
A new DeskKit tool lands every week or two. Leave an address to hear about it. Nothing else is ever sent, and one click removes you.