Skip to main content
Sign in

I have a data file containing double-byte characters, how can I open it?

  • Updated

If you have your own file, or have downloaded one of our Open Data files (located under Data - Data Catalog) that has double-byte characters, use the following table when opening it so the double-byte characters are correctly handled.

Original File Format Open using: GOOGLE SHEETS Open using: EXCEL
Excel Opens correctly Opens correctly (providing it was saved in the proper format). If you download an open data set from Openprise in Excel format, it is saved correctly.
 CSV Opens correctly To open the file in Excel, you have to instruct Excel to open with UTF-8 format:
  1. Open Excel and go to Data - Get Data - From File - From Text/CSV.
  2. Select your file
  3. in the File origin window, select 65001 : Unicode (UTF-8)
  4. Select Next, and change the delimiter to a comma.
  5. Make any other changes needed and press finish.

When saving, instruct Excel to save with UTF-8 format:

  1. Select Save as
  2. Then select CSV UTF-8 (comma delimited) (*.csv)

image.png

 

Related articles