Using CSV files in Excel - Johnson Controls - Metasys - LIT-12012389 - Software Application - Software Licensing - 3.0

Software Manager Help

Brand
Johnson Controls
Metasys
Product name
Software Licensing
Document type
User Guide
Document number
LIT-12012389
Version
3.0
Revision date
2020-10-30
Language
English

When you use Excel to view the content of an exported CSV file, use the Text Import Wizard rather than directly opening the file to ensure the correct interpretation of the data. This applies to License History and License Details export files. Refer to Excel's Help for the Text Import Wizard, with the following considerations:

  • In Step 1 of the Text Import Wizard, select the Delimited option for the data type. If the preview does not look correct with the default file origin selection, choose 65001 : Unicode (UTF 8).
  • In Step 2, choose Comma as the delimiter type.
  • In Step 3, set the column data formats as appropriate for each data column.
    Note: These steps may vary depending on the version of Excel you use.