Title: Import without special characters Last modified: January 10, 2019 --- # Import without special characters * Resolved [gurudlan](https://wordpress.org/support/users/gurudlan/) * (@gurudlan) * [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/) * Hello, * i have a csv file with UTF-8 coding… When i import users it’s like a good import result as you can see here: [https://ctrlv.cz/5NHW](https://ctrlv.cz/5NHW) (screenshot), but after -> i go to users and new imported users is without special characters( stored to db). This printscreen: [https://ctrlv.cz/Llnw](https://ctrlv.cz/Llnw) * Special characters like: ščťžýáň… * How to solve that please? * Thank you Viewing 9 replies - 1 through 9 (of 9 total) * Thread Starter [gurudlan](https://wordpress.org/support/users/gurudlan/) * (@gurudlan) * [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/#post-11074497) * + i check my WP DB and it is set to utf8mb4 coding, but that is not problem…. or? * Thread Starter [gurudlan](https://wordpress.org/support/users/gurudlan/) * (@gurudlan) * [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/#post-11074701) * + when i create user manually with special characters, WP save user with special characters to DB too…That is info about special characters working in my DB… * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/#post-11074803) * [@gurudlan](https://wordpress.org/support/users/gurudlan/), * Good evening, if the problem persists also doing it manually, this is not in the plugin. * Talk with your hosting, maybe there is some kind of bad configuration. * Thread Starter [gurudlan](https://wordpress.org/support/users/gurudlan/) * (@gurudlan) * [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/#post-11075103) * Hello, * i make test about that import on my different web with wp (different hosting) and result was the same… * here is my csv…can you try it? link: [https://ufile.io/ih9dg](https://ufile.io/ih9dg) * Thank you * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/#post-11075124) * [@gurudlan](https://wordpress.org/support/users/gurudlan/), * Sorry but we do not provide personal support (not here at least, if you contact us we can provide you proffessional support). * Opening the file in LibreOffice appears to be ok. * Thread Starter [gurudlan](https://wordpress.org/support/users/gurudlan/) * (@gurudlan) * [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/#post-11075191) * Hello, * yes, but i report it as bug of plugin… Because it’s not working with special characters… * Thank you * Thread Starter [gurudlan](https://wordpress.org/support/users/gurudlan/) * (@gurudlan) * [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/#post-11075364) * Hello, * I fix that. * It was because in your plugin is user-name and user-login the same. But i need user-login for example set to email and user-name to show from my csv username +lastname(with specialcharacters…). * But user-login in default in WP is blocked for special characters…Wp remove them. * Solution is to change tags in csv: * Username(user-login),email,display_name(=this is for user name display in WP for example: Jaňkoš Hraľko)… * But i found this solution by debuging WP and user.php where i found how wp create user… * You maybe need re-name your expected(needed column) Username to => UserLogin and add new needed UserName or UserDisplayName… * Thank you * Thread Starter [gurudlan](https://wordpress.org/support/users/gurudlan/) * (@gurudlan) * [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/#post-11075371) * Solved * Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/) * (@carazo) * [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/#post-11076800) * [@gurudlan](https://wordpress.org/support/users/gurudlan/) good morning, * Ok but do not worry, you can: - User in the first column the username - In any other column from the 3rd one the user_displayname * Plugin now supports it. Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘Import without special characters’ is closed to new replies. * ![](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/) * 9 replies * 2 participants * Last reply from: [Javier Carazo](https://wordpress.org/support/users/carazo/) * Last activity: [7 years, 5 months ago](https://wordpress.org/support/topic/import-without-special-characters/#post-11076800) * Status: resolved