Encoding

4 lessons in order

Learn how to save Excel file as CSV with UTF-8 encoding using Save As, Google Sheets as a bridge, or a VBA macro for proper data formatting.

Learn how to change encoding in Excel using UTF-8, Web Options, Text Import Wizard, manual file opening, or Notepad to fix character issues.

Learn how to fix missing CSV UTF-8 in Excel using Save As, Notepad encoding, and the Text Import Wizard for correct data import.

Learn how to decode Base64 in Excel using a VBA macro or custom UDF, and easily convert entire columns of Base64-encoded text for analysis.