Languages

Export excel to CSV with UTF-8 encoding - problem

1 points
Asked by:
AnnLen
12160

How can I export excel to CSV file with UTF-8 encoding?

If I export with default excel encoding I get some artifacts like wrong letters - eg I have some Polish characters like: ├│, ┼║, ─ů, ─Ö, ┼é etc.

When I export to csv all those characters get wrong encoding. 

Example:

3,Pozna?
4,Warszawa
5,Krak├│w
7,Rzesz├│w
8,Wroc?aw

First row should be: 3, Poznań

But instead I get: 3,Pozna?

How to solve this problem?

Entire data after export should looks like this:

3,Poznań
4,Warszawa
5,Krak├│w
7,Rzesz├│w
8,Wrocław

I use Microsoft Office Excel 2013

2 answers
3 points
Answered by:
AnnLen
12160

Easiest way to solve this problem is to copy from excel to google docs excel and export data from there.

In google docs excel go to:

File -> Download -> Comma-separated values (.csv, current sheet)

Screenshot:

 

Your data in google docs excel:

Your data after export from google docs excel:

 

0 comments Add comment
2 points
Answered by:
AnnLen
12160

Coppied from following wiki article: https://dirask.com/posts/p59o0p

Do followin steps:

  1. go to: File -> Export -> Change File Type -> Save as Another File Type -> Save As,
  2. set Save as type to CSV UTF-8 (Comma dellimited) (*.csv)

Export -> Save As option screenshot: 

Export excel data to UTF-8 csv file.
Export excel data to UTF-8 csv file.

File preview with Notepad++:

Exported excel data to UTF-8 csv file.
Exported excel data to UTF-8 csv file.
1 comments
AnnLen
I don't have such option, I use excel 2013.
Add comment
Native Advertising
­čÜÇ
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

ÔŁĄ´ŞĆ­čĺ╗ ­čÖé

Join