3 ms·

Microsoft finally fixing Excel CSV data corruption

• shthed 4y ago
  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 4y ago
    Note that features on the insiders ring often either don't reach production deployment, or take years to get there unfortunately.
  • hulitu 4y ago
    So only for CSV files ? No fix for automatic converting cell content to data ?
• jhgkjhlkhjkljk 4y ago
  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.
  • bigiain 4y ago
    > Still doesn't stop auto conversion for dates. Or genes: https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates https://www.theverge.com/2020/8/6/21355674/human-genes-renam...
    • deleted 4y ago
      [deleted]