CSV encoding in Excel

This short tutorial shows, how to simply correctly encode a CSV file (for example UTF-8) in Excel correctly so you get rid of the hieroglyphs and wrong formatted text. There are many different special keyboard letters, that can get displayed wrong if you open them with a different program. Normally Microsoft Excel encodes it with UTF-8, but sometimes you need to adjust the format of the letters yourself otherwise, you get strange symbols in your file, which makes it unreadable or even unusable.

To get rid of this problem, you need to read the CSV text file through a news Excel sheet and import text in the data tab. There you can specify your encoding standard, that the text gets displayed correctly.

[sinandurmaz]

oh mate, ive been working on a tedious enough task and on top of that my excel file had tons of broken characters so my work couldn't continue, thanks to you I am back on track, appreciate it.

[HaleemaRajpoot-ib]

Thank you so much ..i have been working on it from hours...and finally I got solution

[trivenigudla]

You've saved me, this is just what I need!!! Thank you very much!♥️

[rickysharma]

Thank you brother its working for me, you don't know what you did for me. thanks alot

[ahmetturk]

Thanks, I'm a new Mac user and most of the videos for windows