Special characters in CSV file incorrectly shown

    Intro

    Rock Mapper stores data as CSV files in Unicode formatĀ UTF-8, such as theĀ [FaceID]_metadata.csvĀ file which includes columns forĀ LevelĀ andĀ Region.Ā 


    When opening such a file in Excel, some special characters will be incorrectly encoded. For example, an apostrophe will be shown asĀ Ć¢ā‚¬ā„¢Ā because Excel is using the defaultĀ Windows-1252Ā encoding.



    Ā Stefan's TestĀ encoded using Windows-1252 instead of UTF-8


    When opening the same CSV file with Notepad, the apostrophe inĀ Stefan's TestĀ is shown correctly because Notepad is using UTF-8 by default.



    Stefan's TestĀ correctly shown. Notepad is using UTF-8, as indicated in lower right corner of the screenshot


    Instructions

    In order to use UTF-8 encoding in Excel, follow these steps:

    1. Open Excel
    2. Click onĀ DataĀ tab in menu bar
    3. ClickĀ From Text/CSV
    4. Navigate to the the CSV that you want to import. Click on the filename and then theĀ ImportĀ button.Ā 
    5. ChooseĀ 65001: Unicode (UTF-8)
    6. PressĀ LoadĀ button


    ā„¹ļøĀ For import into a drillhole or grade control database, the CSV files will work straight out of the box because databases support and use the UTF-8 format.
    Published