Skip to content
  • There are no suggestions because the search field is empty.

Special Characters Appear as Question Marks in a CSV Import

This article walks through steps to resolve identifiable characters.

When importing special or foreign characters from a CSV, question marks within a diamond shape may appear instead of the special or foreign character.

  1. Open the CSV file and select Save As.
  2. Change "Save as type" to CSV UTF-8.
  3. Re-import the file and the characters will appear correctly.

If the issue does not resolve when using Excel, try downloading LibreOffice and performing the same process.