Ask Your Question

How can I import csv file with French words and accents?

asked 2017-09-10 13:21:58 +0200

Deckboy gravatar image

When I open a csv file with French, Spanish etc town names, all the accents are shown as a black diamond with ? in the centre. I have tried using Unicode (UTF-8) French and also W Europe (Apple Macintosh) French. How can I import the words WITH the accents?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-09-10 13:53:29 +0200

Deckboy gravatar image

Think I've solved it myself. Import Character Set: Western European (Windows-1252/WinLatin 1) Certainly works with French. Will try others later.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-10 13:21:58 +0200

Seen: 188 times

Last updated: Sep 10 '17