0

I'm trying to create -through PHP code- a CSV file that the user will download as a sample, fill it up (probably with Excel), and then re-upload it in order to upload data.

Problem is that the user may decide to use special characters of Russian, Greek languages, etc. (for example Δ,Γ,θ,з,в,и, etc)

What encoding should I use? Because I've noticed that UTF-8 CSV files are not supported when double-clicked to open direct with Excel. (Shows strange characters instead of actual ones)

In all my tries I cant create a sample file that if I will open it directly in Excel it will read those special characters...

I've also tried to use UTF8 with BOM and when i open it with Notepad++ it always shows it is UTF8 format not UTF8-BOM

Improve this question
2
  • 1
    Excel doesn't support UTF8 well, not a PHP issue. You could use PHPOffice I think... or see stackoverflow.com/questions/4348802/… Commented Jun 13, 2022 at 15:23
  • I've created (through Notepad++) 3 files in 3 formats ANSI,UTF8, and UTF8BOM, when i edit them and save them Excel saves it to ANSI. So maybe i could just create the csv in ANSI format. Commented Jun 13, 2022 at 15:31
Related questions
5135
Reference Guide: What does this symbol mean in PHP? (PHP Syntax)
232
How can I output a UTF-8 CSV in PHP that Excel will read properly?
154
Which encoding opens CSV files correctly with Excel on both Mac and Windows?
Load 4 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.