Member Avatar for Buppy

Hi,

I have a PHP acript that generates csv files and then automatically forces downloading them. Before i have added this line - header("Content-type: application/csv; charset=UTF-8");. When opening file in editors like Notepad, every character shows fine, but when importing the csv into applications like MS Excel, it does not detect the charset automatically and i have to select it manually to display all the characters normally. Is that an Excel thing or i have done something wrong in generation and download process?

Thanks

  • 2 Contributors
  • 1 Reply
  • 57 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

It's an Excel thing, although on my 2007 at work, the charset is detected correctly. If you use the import dialog, you can select which charset to use.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.