How to Display Special Characters (UTF-8) in a Spreadsheet?

UTF-8-Encoding Comparison
A side-by-side example of a spreadsheet with and without UTF-8 encoding.

 

If the special characters and symbols in your CSV/Excel file are not displayed correctly, it needs to be converted into UTF-8 Character Set first. Here’s how to save a CSV file with UTF-8 encoding using Apple Numbers:

 

➊ Open Spreadsheet in Apple Numbers
 

➋ Click on File > Export To > CSV

Export to CSV
 

➌ Select Text Encoding to Unicode (UTF-8)

Select UTF-8
 

➍ Click Save.

 

Dryfta is the all-inclusive event management platform for universities & nonprofits.

dryfta_logo_promote

Related posts:

  1. Display Hotels near your Event Venue
  2. Set Groups for Tickets & Display them under Different Headings
  3. Event CRM with Inline Editing – as Easy as a Spreadsheet