When a user extracts a CSV file from the CRM report, some fields appear as: #NAME? when opening the CSV file with Microsoft Excel.
This is a Microsoft Excel behavior. If any text starts with -, +, = or any other symbol, it considers it as a formula.
There are two ways to resolve this issue:
- Select the .xls format when exporting a report.
- Open the CSV file with Text Editor and to see the correct value.
Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.