Need to make changes or updates to your accounts or subscriptions? Visit the Account Management Page
QuickBooks HelpQuickBooksHelpIntuit

Fix error “invalid byte sequence in UTF-8”

SOLVEDby QuickBooksQuickBooks OnlineUpdated 3 weeks ago

Learn how to fix “invalid byte sequence in UTF-8” when you import a CSV file in QuickBooks Commerce.

QuickBooks Commerce is no longer available for purchase as a stand-alone product.
The features referred to in this article are only relevant for customers who still have QuickBooks Commerce bundled with their QuickBooks Online subscription.
If you want to learn more about e-commerce accounting features that are part of QuickBooks Online, check out Accounting for e-commerce FAQ.

If your CSV file has non-English or special characters, you can encode your file in the UTF-8 format so QuickBooks Commerce can easily read its content. Here’s how.

Microsoft Excel 2016 for Windows and Mac

  1. Open your CSV file Excel document.
  2. Go to the File menu.
  3. Select Save As.
  4. From the File format ▼ dropdown, select CSV UTF-8 (Comma Delimited) (*.CSV).
  5. Save your file, then upload it to QuickBooks Commerce.

Google Sheets

  1. Open your CSV file in Google Sheets.
  2. Go to the File menu.
  3. Select Download.
  4. Select Comma-separated values (.csv, current sheet).
  5. Save your file, then upload it to QuickBooks Commerce.

Notepad++

  1. Create the file as an Excel workbook. Make sure the first entry contains a special character.
  2. Save the file as Unicode Text. 
  3. Download and open Notepad++.
  4. Open the file in Notepad++.
  5. Replace the tabs with commas.
  6. Select Encoding, then change it to UTF-8. 
  7. Save the file as an All Types file and add “.csv” at the end of the file name.
    Note: Make sure not to open the file in Excel.
  8. Upload the file to QuickBooks Commerce.

Do you use a different app? Use the 'Help' button in-app to reach out to us so we can help you create a .CSV file.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Commerce CoreQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this