HN Explorer

6 comments

[ 2.2 ms ] story [ 39.5 ms ] thread
shthed
After 30 years they are finally adding an option to disable the automatic data corruption that happens when opening .CSV files in Excel.

This needs to be the new default option.

technion
Note that features on the insiders ring often either don't reach production deployment, or take years to get there unfortunately.
hulitu
So only for CSV files ? No fix for automatic converting cell content to data ?
jhgkjhlkhjkljk
Still doesn't stop auto conversion for dates. There is however at least this:

>NOTE: You can also select the When loading a .csv file or similar file, notify me of any automatic number conversions check box. By doing so, Excel will display a warning message when it detects that at least one of the optional automatic data conversions is enabled and about to occur when opening a .csv or .txt file. The message gives the ability to do a “one-time load” of the file without converting the data.