error “Your file is not in UTF-8 format”

  • Resolved peteratomic

    (@peteratomic)


    2 years, 2 months ago

    Couldn’t find any explanation of this error in either your documentation or this forum.

    I can’t find any settings options in Excel for choosing UTF-8 format for CSVs.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter peteratomic

    (@peteratomic)

    Solved it by uploading to Google Sheets then redownloading as a new CSV.

    Plugin Contributor Smackcoders Support

    (@smacksupport)

    Hello @peteratomic

    You can resolve the UTF-8 format by uploading it to Google Sheets, then downloading it as a new CSV file. In the same way that you have already done.

    You can evaluate your CSV on lint.io

    Plugin Author smackcoders

    (@smackcoders)

    Additionally you can use notepad++ to solve UTF-8 encode issues. You can open your csv using notepad++ and go to encoding tab to verify the format. It may be ANSI.

    1. There is an option convert to UTF-8 in the same menu. Just click to convert and save the changes to overwrite the file. But in this method you may loose the original file.
    Or
    2. Just select all and copy the ANSI content to clipboard. Now open a new note, make sure to change to UTF-8 format from menu > Encoding. Then paste the copied content. Save the file with new name leaving old one as safe backup.

    Now you can open the converted file in Excel without issues.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘error “Your file is not in UTF-8 format”’ is closed to new replies.