Save CSV file with encoding UTF-8 with Java

Question

I'm trying to create a CSV file with java contains some data in Arabic letters but when I open the file I found Arabic letters appears as symbols. here is my code :

String csvFilePath = "test.csv";
BufferedWriter fileWriter = new BufferedWriter(new FileWriter(csvFilePath));
fileWriter.write("الاسم ، السن ، العنوان");

and data in CSV file appears like that

ط´ط±ظٹط·

so How can I solve this issue ?

If you rename the file from .csv to .txt does it then show correctly? Besides UTF-8 there is also the Right-To-Left control and CSV is also column based. — Joop Eggen, Jul 14 '20 at 12:04

fcdt · Answer 1 · 2020-07-14T11:50:07.797

3

As mentioned in Write a file in UTF-8 using FileWriter (Java)? you should use OutputStreamWriter and FileOutputStream instead of FileWriter and specify the encoding:

String csvFilePath = "test.csv";
FileOutputStream file = new FileOutputStream(csvFilePath);
OutputStreamWriter fileWriter = new OutputStreamWriter(file, StandardCharsets.UTF_8);
fileWriter.write("الاسم ، السن ، العنوان");
fileWriter.close();

Edit after comment:

To make sure the source code's encoding is not the problem, escape your unicode string like this:

fileWriter.write("\u0627\u0644\u0627\u0633\u0645\u0020\u060c\u0020\u0627\u0644\u0633\u0646\u0020\u060c\u0020\u0627\u0644\u0639\u0646\u0648\u0627\u0646");

edited Jul 14 '20 at 11:50

answered Jul 14 '20 at 11:20

fcdt

2,371
5
14
26

Even better: use try-with-resources. This makes sure it's always closed, no matter any exceptions occurring while opening and using the fileWiter. – John Smith Jul 14 '20 at 11:41
Maybe your source code is wrongly encoded? How is your editor or your IDE set? – fcdt Jul 14 '20 at 11:48
I tried to write the same code but print data into txt file and Arabic letters appears normal but this issue happened in csv – Mohamed Hoosam Jul 14 '20 at 11:57
What program did you use to open the csv file? – fcdt Jul 14 '20 at 11:58
Microsoft excel 365 – Mohamed Hoosam Jul 14 '20 at 12:01
Maybe that's the problem. Try it with your browser or a simple text editor. – fcdt Jul 14 '20 at 12:01
I tried to open it with notepad and Arabic letters appears normal – Mohamed Hoosam Jul 14 '20 at 12:05
That means the problem is solved? Was it just the program that opened the csv file or the code too? – fcdt Jul 14 '20 at 18:05

score 0 · Answer 2 · answered Mar 15 '21 at 21:33

In my case, the file is defined as follows.

String file = fileName+"."+fileExtension;

The variable fileName is locale-dependent, i.e in Arabic it contains "تصدير" and in English "export". The variable fileExtension always contains "csv".

Now, the problem is that the variable file looks like "csv.تصدير" in Arabic and "export.csv" in English.

Is this the correct way for a file in Arabic or should it look like "تصدير.csv"?

Ask this as a separate question. – the Hutt Mar 16 '21 at 03:30 — the Hutt, Mar 16 '21 at 03:30

score 0 · Answer 3 · answered Mar 15 '21 at 21:55

0

As others have mentioned: use an OutputStreamWriter. Additionally you can write “\uFEFF” as a first character. This will act as a byte order mark and it helps applications like excel to know which encoding you used.

answered Mar 15 '21 at 21:55

Kristof Neirynck

3,934
1
33
47

Save CSV file with encoding UTF-8 with Java

3 Answers3