Import Users from CSV

Описание

This plugin allows you to import users from an uploaded CSV file. It will add users with basic information as well as meta fields and user role.

You can also choose to send a notification to the new users and to display password nag on user login.

Check out our other free plugins.

Особенности

  • Imports all users fields
  • Imports user meta
  • Update existing users by specifying ID field
  • Allows setting user role
  • Sends new user notification (if the option is selected)
  • Shows password nag on user login (if the option is selected)

For feature request and bug reports, please use the forums.
Code contributions are welcome on Github.

Import Users From Any CSV/Excel/XML with WP All Import Pro

WP All Import Pro can import WordPress users, WooCommerce products, ACF, custom post types, custom fields, taxonomies, and everything else:

  • Drag & Drop to Import Any File: Give any CSV or XML to WP All Import, then drag and drop to map data from your file into WordPress.
  • Any Custom Post Type, Every Data Type: Import data to custom post types, with support for WooCommerce, ACF, custom fields, taxonomies, and everything else.
  • Import Images & Galleries: Images can be uploaded, downloaded, or matched to media already in WordPress. Full support for WooCommerce product images and variation galleries.
  • Import Files from URL: Download and import files from external websites, even if they are password protected. URL imports are can be re-run to add, edit, and delete posts.
  • Scheduled Imports: WP All Import Pro can check periodically check a file for updates and then add, update, or delete to the imported posts accordingly.
  • Developer Friendly: Pass data through custom PHP functions. For example, use something like [my_function( {user_email[1]} )] in your template, to pass the value of {user_email[1]} to my_function and display whatever it returns.
  • Priority Support: Personal support from our team of expert developers with over a decade of experience importing and exporting WordPress data.
  • 90 Day Money Back Guarantee: Not 100% happy? Let us know, and we’ll promptly send you a refund. No questions asked.

Check out WP All Import today.

Скриншоты

  • User import screen

Установка

Для автоматической установки через WordPress:

  1. Нажать ‘Добавить новый’ на страницы управления плагинами в панели администрирования WordPress
  2. Search for ‘Import Users from CSV’
  3. Нажать Установить и Активировать плагин
  4. Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’

Для установки через FTP:

  1. Upload the import-users-from-csv directory to the /wp-content/plugins/ directory
  2. Активация плагина через закладку Плагины в панели администраирования WordPress
  3. Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’

Для загрузки через WordPress без FTP:

  1. В админ панели WordPress в закладках Плагины, надо нажать Добавить новый, а выбрать скачанный zip файл плагина, затем нажать Активировать.
  2. Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’

Часто задаваемые вопросы

How to use?

Click on the ‘Import From CSV’ link in the ‘Users’ menu, choose your CSV file, choose if you want to send a notification email to new users and if you want the password nag to be displayed when they login, then click ‘Import’.

Each row in your CSV file should represent a user; each column identifies user data or meta data.

If a column name matches a field in the user table, data from this column is imported in that field; if not, data is imported in a user meta field with the name of the column.

Look at the example.csv file in the plugin directory to have a better understanding of how the your CSV file should be organized.

You can try importing that file and look at the result.

Credits

Thanks to Ulrich Sossou for initially creating this plugin. Be sure to check out his other WordPress plugins or GitHub profile.

Отзывы

09.04.2024
The external plug-in used to work perfectly, since they force us to use this plugin for Paid Memberships Pro I have had nothing but failures. Constantly exceeds the memory of the server, error 500 constantly, I deleted the import_membership_id field damaging many logical programming that I have on my site with this field … They should give the option to use this or the previous one.
01.09.2022
Worked really well. Two tips for new users: 1) Use the example CSV file to get your data formatted for import 2) Ensure you use ALL the columns required (you don't need to worry about the custom ones) Thanks for saving me loads of pain importing multiple users.
18.05.2022
I downloaded this plugin in desperation yesterday and it did exactly what I needed it to. The sample of what the csv file should look like enabled me to merge data from MailChimp and WooCommerce to add user to the site, so they could log in. Terrific plug-in!
11.08.2021
It met my need immediately. Thank you for creating and maintaining this plugin.
21.01.2019
Update 1.0.1 works great, definitely recommend this plugin. Thanks
19.02.2017
Hello, Just I want to say thanks very much for your plugin. it helps me to develop my custom plugin to import a custum database. BIG thanks :))
Посмотреть все 42 отзыва

Участники и разработчики

«Import Users from CSV» — проект с открытым исходным кодом. В развитие плагина внесли свой вклад следующие участники:

Участники

«Import Users from CSV» переведён на 6 языков. Благодарим переводчиков за их работу.

Перевести «Import Users from CSV» на ваш язык.

Заинтересованы в разработке?

Посмотрите код, проверьте SVN репозиторий, или подпишитесь на журнал разработки по RSS.

Журнал изменений

1.3

  • bug fix: don’t instantiate serialized objects

1.2

  • BUG FIX: Ensure user running import has the ability to add users
  • Update tested to
  • minor UI update

1.1

  • ENHANCEMENT: Added support for WPCLI (@mircobabini)
  • ENHANCEMENT: Added support for multiple roles during import, use comma-separated value for multiple roles (@mircobabini)
  • ENHANCEMENT: Removed password nag option as this is no longer supported.
  • ENHANCEMENT: New filter added ‘is_iu_errors_filter’ for throwing error messages. Helpful for third party developers extending onto IUCSV functionality.

1.0.1

  • Fixed timeout bug on import.
  • Improved settings area layout.
  • General code refactor and improved security.
  • Screenshot update.

1.0.0

  • Fixed bug where importing fields with «0» value doesn’t work
  • Added option to update existing users by username or email

0.5.1

  • Removed example plugin file to avoid invalid header error on
    installation

0.5

  • Changed code to allow running import from another plugin

0.4

  • Switched to RFC 4180 compliant library for CSV parsing
  • Introduced IS_IU_CSV_DELIMITER constant to allow changing the CSV delimiter
  • Improved memory usage by reading the CSV file line by line
  • Fixed bug where any serialized CSV column content is serialized again
    on import

0.3.2

  • Fixed php notice when importing

0.3.1

  • Don’t process empty columns in the csv file

0.3

  • Fixed bug where password field was overwritten for existing users
  • Use fgetcsv instead of str_getcsv
  • Don’t run insert or update user function when only user ID was
    provided (performance improvement)
  • Internationalization
  • Added display name to example csv file

0.2.2

  • Added role to example file
  • Fixed bug with users not imported when no user meta is set

0.2.1

  • Added missing example file
  • Fixed bug with redirection after csv processing
  • Fixed error logging
  • Fixed typos in documentation
  • Other bug fixes

0.2

  • First public release.
  • Code cleanup.
  • Added readme.txt.

0.1

  • First release.