Title: Data in separate columns when exporting Last modified: December 8, 2025 --- # Data in separate columns when exporting * Resolved [wolfdesigndk](https://wordpress.org/support/users/wolfdesigndk/) * (@wolfdesigndk) * [4 months, 2 weeks ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/) * Hello * I would like to export some data on my users. I have figured out how to set the system so that it only exports what I need. * Where the problem comes is after export where all the data is in the same column. All the data is in column A, when you open it in Excel, where I would like to have the Registration date in column A, First name in column B Last name in column C etc. So it gives the possibility to sort the data for example by date * I have use this setup Indmeldelsesdato=>Indmeldelsedato,”Medlemsnummer “=>Medlemsnummer, Fornavn=>Fornavn,Efternavn=>Efternavn, * I have also tried with dobbelt colon :: * Because when I look at your example the data is divided, but I must be doing something wrong regards Maria * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdata-in-separate-columns-when-exporting%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 14 replies - 1 through 14 (of 14 total) * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [4 months, 2 weeks ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18747916) * First of all, as you may have read in the plugin and here in this forum, I recommend NOT using Microsoft Excel to work with CSV files. * In GNU/Linux, I simply cannot use Excel, but I can tell you that in other operating systems where you do have a choice, Excel may be a good choice for other uses, but it causes problems like the one you mention when handling CSV data. * You should try opening the file with LibreOffice Calc or OpenOffice Calc. * Thread Starter [wolfdesigndk](https://wordpress.org/support/users/wolfdesigndk/) * (@wolfdesigndk) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18751920) * ```wp-block-code Hello and thank you very much for your answer.I can easily see that those programs can easily split the files as they look on your preview.. But I also found a way to do it in Excel, so it shows the same thing. It just needs a little data processing :)I have another question. I would like to get the following data from my members, Member ID, First name, Last name, Address, Zip code and city.I have the following data columns set up:Indmeldelsesdato,"Medlemsnummer",Fornavn,Efternavn,E-mail,Adresse,Postnr.,"By ",Telefonnr.," Fødselsdato",Land,Region,"Passager 1 fornavn ","Passager 1 efternavn","Passager 2 fornavn","Passager 2 efternavn","Passager 3 fornavn","Passager 3 efternavn","Om medlemmet ","Goldwing model ","Betalt år",Betalingsmetode,"Kontingent beløb","PBS nr "," Landekode",Titel,"Titel medlemskort",bp_group_id,bp_member_type,and I do the search:user_nicename=>Medlemsnummer,Fornavn=>Fornavn,Efternavn=>Efternavn,Adresse=>Adresse,Postnr.=>Postnr.,"By "=>By,All other data is included, but not city (by).If I download a full datasheet, all data is included, but in a specific column search I can't get that data to appearWhat am I doing wrong? can you see it? ``` * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18752058) * Which kind of data is city? A standard metadata? If yes, this should work. * Thread Starter [wolfdesigndk](https://wordpress.org/support/users/wolfdesigndk/) * (@wolfdesigndk) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18752080) * It is text data and i have added it to the system the same way as postnummer and adress and they are working and that is why i do not understand why it is not working with city, i have also tried it with Medlemsnummer there is a number, i could not get that to work as well. * Any idear what i can do, because i need this to mu customer 🙂 * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18752083) * So this is not a standard metadata, how did you add this? * Thread Starter [wolfdesigndk](https://wordpress.org/support/users/wolfdesigndk/) * (@wolfdesigndk) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18752100) * You would guess that you would call this normal meta data. * These areas are added as extra profile fields, which I can see that the system can retrieve because some of them are listed on the page. * That’s also what makes it a bit strange 🙂 * Thread Starter [wolfdesigndk](https://wordpress.org/support/users/wolfdesigndk/) * (@wolfdesigndk) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18752137) * Would you like to have access to the site so you can see how things are structured there? * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18752142) * Please delete your last comment. In this type of forum, NEVER offer access. It is a very serious security issue. * Regarding your problem, it is not normal metadata; it seems that you are using something like BuddyPress or similar to create the fields. * And indeed, the plugin does not yet offer support for exporting numeric data in this way when listing fields like the ones you use. * I will work to make it available in the future. * Thread Starter [wolfdesigndk](https://wordpress.org/support/users/wolfdesigndk/) * (@wolfdesigndk) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18753464) * The ones I’ve found I have problems with from the list are the ones with “” around them, like * “Medlemsnummer”, – number “By “, – text * I can’t quite understand that you say I use a different system, because inside your plugin many of them are shown how to write them. Too bad I can’t show you on a screenprint * The others are made in exactly the same way * Fornavn, – text Efternavn, – textE-mail, – textAdresse, – textPostnr., – numbers * And I can easily get something from those. It’s the ones with “” that won’t. Does that help you in any way * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18753627) * So that’s the problem, that’s right, I never imagined that anyone could use a character like that in a field. * Surely in some filtering I do on the strings (necessary for security reasons, by the way) that character is lost when you use it, and that’s why it doesn’t work. * The solution is to reformulate the fields and use names without strange characters. * Thread Starter [wolfdesigndk](https://wordpress.org/support/users/wolfdesigndk/) * (@wolfdesigndk) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18756158) * I agree that the “” should not be the lines, but they came by themselves. I did not name them. I just wrote City and Member Number when I named them. That’s why I’m wondering 🙂 * Could it be due to spaces or other invisible characters that they appear on some and not others? * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18756164) * Try changing those names where you created them. You probably copied and pasted them from somewhere else, and that’s where the problem originated. * Thread Starter [wolfdesigndk](https://wordpress.org/support/users/wolfdesigndk/) * (@wolfdesigndk) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18756179) * No, they are not copy pasted.. I have experienced that too many times that it causes problems. * I’ll see what I can do. Because the strange thing is that the data comes in so well if I ask it to fetch everything, but when I want to make a specification, it doesn’t come. * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18756180) * Yes, I told you why. When you made a specification you have to send variables. Those variables have to be managed and the security filters remove all strange characters (because of SQLi) so as you are using bad characters inside names, it does not work. Viewing 14 replies - 1 through 14 (of 14 total) You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdata-in-separate-columns-when-exporting%2F%3Foutput_format%3Dmd&locale=en_US) to reply to this topic. * ![](https://ps.w.org/import-users-from-csv-with-meta/assets/icon-256x256.png? rev=1174343) * [Import and export users and customers](https://wordpress.org/plugins/import-users-from-csv-with-meta/) * [Frequently Asked Questions](https://wordpress.org/plugins/import-users-from-csv-with-meta/#faq) * [Support Threads](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/) * [Active Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/unresolved/) * [Reviews](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/reviews/) * 14 replies * 2 participants * Last reply from: [Javier Carazo](https://wordpress.org/support/users/carazo/) * Last activity: [4 months, 1 week ago](https://wordpress.org/support/topic/data-in-separate-columns-when-exporting/#post-18756180) * Status: resolved