How to change the default character encoding of Excel to UTF-8

Objective

Using the registry, change the default encoding of Excel to UTF-8 for compatibility with Vend on non-English computers or computers using another character set.

If you are not comfortable editing registry values on your device, please consult your IT professional.

Setup

  • Vend for PC
  • Excel
  • Regedit

Steps

  1.  Open Regedit
  2.  Navigate to HKEY_CURRENT_USER>Software>Microsoft>Office>[Excel version here—likely the highest number in this folder]>Excel>Options
  3. In the right pane, right click
  4. Select New > DWORD
  5. Name the new item DefaultCPG
  6. Right click on DefaultCPG
  7. Select Modify
  8. Set the base to decimal
  9. Enter 65001
  10. Click OK
Did this answer your question?
Have more questions? Contact us so that we can help you out.