Title: CSV Export, Excel Problem
Last modified: August 21, 2016

---

# CSV Export, Excel Problem

 *  Resolved [Phinick](https://wordpress.org/support/users/phinick/)
 * (@phinick)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/csv-export-excel-problem/)
 * Hey 🙂 !
 * I am currently strugling with the CSV export of the events manager.
 * I am on following version:
 * Events Manager 5.3.9
    Events Manager PRO 2.2.5
 * Every time I make an export, the structure looks like that (viewed in notepad
   ++):
 * Veranstaltung : Leppner Almtrophy | 10 Jahre Jubiläum
    Wo – Gemeindeplatz Irschen
   Wann : 16/06/2013 – 09:00 – 16:00 Reservierungen exportiert am Do 25 Apr 2013
   12:08 “Buchungsid”,”Nachname”,”Vorname”,”Geschlecht”,”Geburtsjahr”,”Mannschaft”,”
   Klasse” 63,”Philipp Benedikt”,Philipp,m,1986,”Team Awesome”,Walker 64,”Philipp
   Benedikt”,Melanie,w,1993,”Team Pussy”,Walker 65,Geiler,Peter,m,1666,”Geiler Hengste”,
   Walker
 * The Problem I am having about that?
 * I am searching a way to modify that output.
 * The data being seperated by an “,” instead of an “;” –
    doesn’t make Excel to
   view the data in a proper way:
 * [http://tinypic.com/r/am9v8h/4](http://tinypic.com/r/am9v8h/4)
 * I am now searching for a way, to change that way of behavior in one of the php
   files.
    (in addition, I would also like to get rid of all the additional information
   like: “Veranstaltung : Leppner Almtrophy | 10 Jahre Jubiläum”…)
 * I am 99% sure to need to fix it in this file:
 * …/events-manager-pro/add-ons/bookings-form.php
 * …somewhere around here:
 * /*
    * ———————————————————- * Booking Table and CSV Export * ———————————————————-*/
 * I just can’t find a way to get it work.
 * Any help on this, would be more than welcome.
 * Thank you guys.
 * All the best,
    Philipp
 * [http://wordpress.org/extend/plugins/events-manager/](http://wordpress.org/extend/plugins/events-manager/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [agelonwl](https://wordpress.org/support/users/angelonwl/)
 * (@angelonwl)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/csv-export-excel-problem/#post-3691601)
 * hi,
 * seems to work fine on my test site and opening the csv using excel; can you try
   the following using excel
 * – click ‘DATA Tab’
    – click ‘From Text’ – open the csv file and change delimiter(
   if necessary)
 *  Thread Starter [Phinick](https://wordpress.org/support/users/phinick/)
 * (@phinick)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/csv-export-excel-problem/#post-3691606)
 * Thank you for your quick reply.
 * Seems to work again if I change the delimiter within excel to comma.
 * Must be a problem with the German Office Package that it won’t work from scratch.(
   I tried it on some more german versions, everywhere the same issue)
 * The thing is – I was able to change that “, ” / “; ” issue about one year ago
   somewhere in one of the plugins php files. I just can’t find it any more within
   the newer version – probably the structure changed due an update.
 * Why I still want to change some code if the excel delimiter workaround works 
   as well 🙂 ?
 * I would just love that everyone who opens the csv (with a german excel), doesn’t
   have to change anything within excel first to make it work.
 * Thank you for your help so far – maybe we could find a better solution for this
   issue.
 * Thank you,
    Philipp
 *  [agelonwl](https://wordpress.org/support/users/angelonwl/)
 * (@angelonwl)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/csv-export-excel-problem/#post-3691609)
 * hi,
 * I found your previous post in pro forum and you edited em-actions.php and now
   it’s in lines 619 and 623
 * e.g. `fputcsv($handle, $row, ";");`
 *  Thread Starter [Phinick](https://wordpress.org/support/users/phinick/)
 * (@phinick)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/csv-export-excel-problem/#post-3691654)
 * Haha thank you 🙂 !
 * I just couldn’t login to my pro account any more because my license is already
   expired!
 * Haha…what a workflow 😀
 * I knew I posted somewhere the solution.
 * I will give it a try 🙂
 *  Thread Starter [Phinick](https://wordpress.org/support/users/phinick/)
 * (@phinick)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/csv-export-excel-problem/#post-3691667)
 * Worked perfectly!
 * Thanks for heading me to my “own” lost workflow 🙂

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘CSV Export, Excel Problem’ is closed to new replies.

 * ![](https://ps.w.org/events-manager/assets/icon-256x256.png?rev=3550347)
 * [Events Manager - Calendar, Bookings, Tickets, and more!](https://wordpress.org/plugins/events-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/events-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/events-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/events-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/events-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/events-manager/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Phinick](https://wordpress.org/support/users/phinick/)
 * Last activity: [13 years, 1 month ago](https://wordpress.org/support/topic/csv-export-excel-problem/#post-3691667)
 * Status: resolved