When using Microsoft Excel to view exported historical data CSVs from Chartbeat, non-English characters may display incorrectly. To avoid this issue, you can open the Chartbeat CSV file using Google Sheets, or use the Unicode encoding option when importing the data into Excel. Unicode is an international standard that includes support for most foreign alphabets.
Import to Google Sheets
- Open Google Sheets
- Select File > Import
- Import your downloaded CSV
Import to Microsoft Excel
- Open a new Excel document, then select "Data"
- Click "Get External Data", and select "Import Text File"
- Select the CSV and click "Open" to automatically import the data
- Change the "File Origin" to "Unicode (UTF-8)". Check the characters in the preview window. If the appropriate language font is not displayed, the characters may be saved in a different format than Unicode UTF-8. Try UTF-7 or another JIS-based encoding under another language option until the characters are displayed correctly.
- Select "Delimited" as the data type, then, click Next
- Select "Comma" as the delimiter, then click Finish