Problem:

When downloading a report, contact, user, or asset list to a CSV file, it downloads as a .txt file instead of a .csv file.

Root Cause:

If a report (or a Contact or User list) has downloaded as a text-type file, it indicates that at least one text field begins with one of the following hazardous characters:

=
+
-
@
'
"

NOTE: Text fields beginning with - or + that are followed by numbers (+1 818-230-9798) will not result in the file downloading as a text file.

Solution:

To change a .txt file to a .csv file, follow the steps below:

1. Open the text file.
2. Click File, then Save As.
3. Add .csv to the end of the file name.
4. From the Save as type drop-down menu, select All Files.
5. Click Save.

If the new .csv file is not maintaining the proper formatting, see Knowledge Base Article 000002675 - Downloaded Contact Data And/or Notification Data Is Not Properly Displayed When Imported Into a New Excel File for information on how to import files into Excel.