Excel Export is messed up

  • Resolved Lettobi

    (@lettobi)


    4 years, 5 months ago

    My exported excel files look like this:

    –??°±·;?ˇ
    ‰ Users: Alle Mitglieder EXPORT Users: Alle Mitglieder EXPORT8DER FREUNDSCHAFT DIE TAT! – amr users wordpress pluginTobias Elsasser@?àgù?÷@?àgù?÷?ˇ’?’ú.ìó+,??0oHPX`hp
    xé‰
    WorksheetFeuilles de calcul
    ?—B∞=o%r8X”1?êCalibri??ˇ ?
    First nameNachnameStrasseAdresszusatz 1Adresszusatz 2PlzOrtLand
    Mobile NumberEmailE Mail Privat Ja Nein FlagE-Mail Privat 2E Mail Privat 2 Ja Nein FlagE-Mail Gesch‰ftE Mail Geschaeft Ja Nein FlagE-Mail Gesch‰ft 2E Mail Geschaeft 2 Ja Nein FlagRoles

    They used to look Ok. Any ideas, what might be going on?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author anmari

    (@anmari)

    Hi When accented characters aren’t handled well by excel, this is usually because the excel encoding and the db encoding don’t match. It’s a known excel thing.

    Google https://www.google.com.au/search?q=strange+characters+excel+import

    and read https://wpusersplugin.com/1830/exporting-a-wordpress-user-list-to-a-csv-file/

    To fix, either use the plugins text export instead OR use the EXCEL Text import wizard -see instructions in link.

    Nothing has changed recently in the code in that area.

    Plugin Author anmari

    (@anmari)

    Hi should have checked – are you using CSV export or the newer actual excel import ? either way it sounds like an encoding issue which would not be controllable by the plugin. Do let me know if you managed to sort it out.

    Thread Starter Lettobi

    (@lettobi)

    Hi anmari, thank you for looking into it.

    After hours and hours of troubleshooting I found out that it was completely my fault. Being new to PHP, I managed to include a file with ?> at the end which broke the excel export. Funny enough, the rest of the Website didn’t get affected. So sorry for bothering you with this.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Excel Export is messed up’ is closed to new replies.