How to render a exported Riskminder Report Data correctly using EXCEL

Document ID : KB000109846
Last Modified Date : 10/08/2018
Show Technical Document Details
Introduction:
At times exported Riskminder Reports with CSV format (Comma Separated Values) do not render some columns (show up as “#NAME?”") in an EXCEL spreadsheet. The columns render fine in other editors such as Textpad or in Notepad++ editor.
Question:
How to render a Riskminder Report Data (like Device ID) ?
Environment:
Riskminder Reports
Answer:
This is an Excel issue as this issue does not reproduce in a TEXTPAD or Notepad++ editory.  To resolve the issue follow the following steps:  

1. Open a blank EXCEL worksheet.
2. Select the "Data" pull down on EXCEL 
3. Proceed to import with "From CSV file/Text"
 
Additional Information:
None.