Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

After exporting my data in CSV format, when I load it into Excel some of the values are changed. What is causing this?

April 26, 2017causing changed csv Data Excel exporting format load values

0

10 Posted

After exporting my data in CSV format, when I load it into Excel some of the values are changed. What is causing this?

1 Answer

0

10 Posted

The newer versions of Excel automatically import CSV files using the “general” format for cells. In some cases, this causes certain values to be interpreted as a date, and Excel replaces the original data with a date. The workaround is to rename the file with a “TXT” (or other) file extension, and excel will then prompt you via a wizard on how to import the data. This allows you to select Text or Numeric as your datatype, and the original data will be preserved.