Skip to main content
Keep Your Business Open During COVID-19Learn More
Call us
Phone numbers and hours
Help Center

Explore our online help resources

BlogHelp

Online Store Help

Fix Extended Character Errors

In preparing to Import Multiple Products to the Online Store, if you save your Excel product spreadsheet in CSV (Comma Separated Values) format, extended characters (such as é in resumé) will not display properly. To avoid the problem, you'll need to save the file as Unicode text.

Extended character looks OK in spreadsheet Extended character displays incorrectly once imported

Note: Other extended (or UTF-8) characters include superscripts, fractions, currency symbols other than $ (such as the euro's €), plus accent marks and non-English characters (such as ñ, ü, Ё, ؏, and 您).

  1. Reopen the CSV-formatted spreadsheet in Excel and save it as a Unicode file ending with the .TXT suffix.
  2. Open that just-saved .TXT file in Excel, then use the Replace function to find and replace all the file's tab characters with commas.
  3. Now re-save the Excel file in the UTF-8 format.
  4. If you haven't already done so, you'll still need to format your product spreadsheet to match the Online Store's product template.
  5. You're now ready to upload the file to your Online Store.

Next steps

More info

Community Related

Colacat's Avatar
Search Engine Visability Errors

2 Replies

Last posted over 4 years ago.

awaisahmed1990's Avatar
Please use the Latin Alphabet (A ~ Z). At this time,

9 Replies

Last posted about 3 years ago.

AddyC's Avatar
Not eligible for listing 2 characters .tv domain

1 Replies

Last posted over 1 year ago.

TrevT's Avatar
Spelling mistake in my email address

1 Replies

Last posted 3 months ago.

alinavo's Avatar
Cyrillic characters

1 Replies

Last posted over 4 years ago.

Don't see what you are looking for? Search the Community