Information exported to a CSV file is incorrectly formatted by spreadsheet program
Information that is displayed in the web-based GUI can be exported to a comma-separated values (CSV) file. When you are viewing a CSV file in a spreadsheet program, some information might not match what is displayed in the web-based GUI.
Problem
A CSV file is a plain-text file. No type information is provided for the values in the CSV file, but a spreadsheet program, such as Lotus® Symphony® or Microsoft™ Excel, can determine a type based on the value itself. If a value contains only numeric characters, a spreadsheet program might determine that it is a numeric value. It might also format the value in a particular style, such as in decimal format or scientific notation. Sometimes, this automatic reformatting of values results in values that are incorrectly displayed. For example, a worldwide port name (WWPN) should be treated as a text even if it contains only numeric characters. If a spreadsheet program converts the WWPN to a new format, it no longer reflects that actual name.
Action
If values in the CSV file do not match the values that are displayed when the file is opened in a spreadsheet program, consult the documentation for the spreadsheet program you are using. When you open a CSV file in spreadsheet program, you can typically override the automatic formatting behavior and specify how values are imported. To verify that the values in the CSV file match the values that are shown in the spreadsheet program, you can open the CSV file in a text editor.