Skip to main content

CSV Download Troubleshooting: Values as Dates

Written by Tara Warnock

For users of Microsoft Excel on Windows Computers:

When downloading accounts from the Enlyft Platform via CSV file to your Windows computer, you may run into a data issue when reviewing the data in Microsoft Excel. When you use the employee filter range for filter values "1-10" and/or "10-50," those values will instead show in date format, such as "10-January." This is an issue within Microsoft Excel itself.

In order to correct this issue, please complete the following:

  1. Download the CSV file from your segments and save to your computer.

  2. Open a blank Excel file.

  3. Go to the "Data" tab.

  4. In the left-most section, select "Get Data" > "From File" > "From Text/CSV."

  5. Save the output.

  6. Your data will now be shown with correct formatting!

Did this answer your question?