Accented letters in CSV import

  • Resolved digbymaass

    (@digbymaass)


    6 years, 11 months ago

    When I import a CSV file from Excel (2008 for Mac) accented characters disappear.

    Eóin becomes Ein. I tested with a few common ones like ü é è etc and they all disappear. The name appears correctly in the CSV when opened in a text editor – Eóin,Lennon,35.13,37.24

    I can paste or type the corrected version into the table (on a mac I use alt+e then o)

    No-one else seems to have this issue!

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    The reason for this most likely is that your version of Excel saves the CSV file with a different character encoding (not UTF-8, but something else), or that your server has problems with UTF-8.
    Could you, in the text editor, somehow try saving the (working) CSV file in the UTF-8 character encoding?

    Regards,
    Tobias

    Thread Starter digbymaass

    (@digbymaass)

    Looks like this version of Excel doesn’t do UTF-8!

    Fortunately we have very few people with accented names so I now know to look out for them.

    I did try the xlsx import and the accent worked, but the times weren’t rounded to 2 decimal places.

    Thread Starter digbymaass

    (@digbymaass)

    Just tried exporting with the available option UTF-16 Unicode Text (.txt) and that worked!
    I thought import Format choice CSV meant you could only use CSV as the export from Excel.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    awesome! Good to hear that this worked!
    I’ll have to keep that UTF-16 option in mind ??

    Best wishes,
    Tobias

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Accented letters in CSV import’ is closed to new replies.

Tags