I regularly export to excell by i find i have to export from the database which is a pain as when i download the csv it does not create an entry per column. We use postal memberships too. Is there a way i can export the member data per column horizontaly? ie Name | Address | post code thanks
Looks like your Excel uses another delimited. Try to use ; instead of , in the export settings, or vice-versa.
Hi I tried this and the results are still not quite right. I have FirstName, Lastname, Custom Address Field, PostCodei wish to export. When I export using ; I still get the info on 3 row. Now What i can work out is that the custom address is multiple lines. Also the firstname and lastname is still in the same column. What i need is these in their own collumns and the custom Address field in its own collumn too. Is this possible to do? We use This software for Online and Offline postal and export weekly so we can send our members an information pack.. but the exporting is a pain unless i do it in Mysqladmin. many thanks
I know post was a while back, but what you need to do to convert into Excel columns is to open the CSV file in excel, then select DATA -> TEXT to COLUMNS, specify your delimiter (the one you specified in the EXPORT) and it will convert into Excel format columns with a field in each col. Hope this helps.