Support » Plugin: CSV Importer & Exporter » CSV's ANSI encoding causes problems with special characters

  • Resolved evrenk



    Your plugin is a blessing: I have an entire 900+ entries Excel spreadsheet to import into two custom post types. You just saved me a month of work.

    The values I have to import are in French. Excel’s ANSI encoding caused strings to be cut before the first accentuated character for each one. I have opened the csv in NotePad++ and converted the encoding to UTF-8. Worked like a charm!

    Maybe someone could benefit from this piece of information 🙂

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author smackcoders



    Thank you for the feedback. Really it should help others. Also kindly rate our plugin.


    Hi smackcoders,
    I have Italian special Characters like “è,à”.when i try to import it is not loading full is breaking until this characters.please help me.i did evrenk approach ,but no luck.

    Hi hansa1,

    The encoding you might get at the beginning might be different. When you open the file in a text editor, play with the encoding settings until the characters appear OK and then change the encoding to UTF-8. Does it work?

    Kind regards,


    Plugin Author smackcoders


    Hope @hansa1 got that worked to.

    Thanks evrenk!!! I was pulling my hair out about this issue. Perfect solution! Will make our client very happy not to have to search/replace foreign chars with html entity codes in the csv file! Great plugin, smackcoders – any chance of accepting ANSI-encoded files in the future?

    Merci beaucoup evrenk pour cette astuce !!! j’était en train de me prendre le choux grave sur cette histoire de uft8. J’ai moi aussi une base de plus de 4000 enregistrement à importer dans un post type ! La ac Notpad ++ ça marche nickel !

    smackcoders, i’m confirm Your plugin is a blessing !! Thank you so much 😉

    Plugin Author smackcoders


    @ LeRedac, Merci pour votre commentaire, j’espère que vous pouvez poster votre avis qui nous aident à maintenir notre plugin grandit

    Plugin Author smackcoders


    @eyoungquist, yes we do have the plan to add in upcoming versions. Check back our next release. Dont forget to pass your review as well.

    Thanks for your comment.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘CSV's ANSI encoding causes problems with special characters’ is closed to new replies.