The export files for the MadgeTech mobile app for the LynxPro series of loggers uses the UTF-8 encoding. UTF-8 (Unicode Transformation Format – 8 bit) is a universal format selected as it is a standard with broad compatibility for use with software from many vendors.
Some software–such as Microsoft Excel–may add unnecessary characters when importing data in this format. For example: 25 °C may be displayed as 25 °C.
It is possible to process this data in Excel to view the data in a more readable format and remove the extraneous characters.
- In the Data tab of the toolbar, select From Text/CSV in the Get & Transform Data section
- Locate and select the .CSV file for the exported data, and double-click or highlight and click Import
- Unicode (UTF-8) should be selected in the File Origin dropdown box, and Comma should be selected in the Delimiter dropdown box
- Click Load
This will result in a more user friendly format.
