Force file encoding in Microsoft Excel

Asked Apr 03 '18 at 15:49

Active Apr 03 '18 at 15:57

Viewed 61 times

I am dynamically creating CSV files using php, and I have a problem with the encoding when I open it with Microsoft Excel. The problem is with the french characters ' , é , à ...

When I changed my Excel's encoding to UTF-8 it works just fine. But I don't want to make a manual for each user who downloads the file.

Is there a way to force Excel to open the file with UTF-8 encoding?

edited Apr 03 '18 at 15:57

RiggsFolly

93,638
21
103
149

asked Apr 03 '18 at 15:49

Yassine Younes

2

Why not just convert the csv to UTF-8? – Pratik Patil Apr 03 '18 at 15:57
1

Just add the BOM to the beginning of the file, as in one of the dupe answers. – miken32 Apr 04 '18 at 03:13

Force file encoding in Microsoft Excel

0 Answers0