Title: Bulk Edit and Create User Profiles – WP Sheet Editor Author: Jose Vega Published: 2018 年 4 月 8 日 Last modified: 2026 年 1 月 17 日 --- 搜索插件 ![](https://ps.w.org/bulk-edit-user-profiles-in-spreadsheet/assets/banner-772x250. png?rev=1854670) ![](https://ps.w.org/bulk-edit-user-profiles-in-spreadsheet/assets/icon-256x256. png?rev=1854670) # Bulk Edit and Create User Profiles – WP Sheet Editor 作者：[Jose Vega](https://profiles.wordpress.org/josevega/) [下载](https://downloads.wordpress.org/plugin/bulk-edit-user-profiles-in-spreadsheet.1.5.43.zip) * [详情](https://cn.wordpress.org/plugins/bulk-edit-user-profiles-in-spreadsheet/#description) * [评价](https://cn.wordpress.org/plugins/bulk-edit-user-profiles-in-spreadsheet/#reviews) * [安装](https://cn.wordpress.org/plugins/bulk-edit-user-profiles-in-spreadsheet/#installation) * [开发进展](https://cn.wordpress.org/plugins/bulk-edit-user-profiles-in-spreadsheet/#developers) [支持](https://wordpress.org/support/plugin/bulk-edit-user-profiles-in-spreadsheet/) ## 描述 Edit User Profiles Quickly. You can view all fields at once, edit, and create new users in bulk. #### Use Cases * WooCommerce stores : you can view all your customers in a single page * BuddyPress : View all profile fields in the spreadsheet * You want to Create a lot of Users Quickly * You want to Edit User Profiles Quickly * You have a website with a lot of Users * You need to Update User Profiles in Bulk #### Free Features * View all your users in a table * Edit users quickly in a table similar to a spreadsheet * Sort the users list by name, email, and any profile field * You can edit all CORE fields in the user profiles: Email, Username, Password, Role, First name, Last name, description, nicename, website, display name, nickname, rich editing, comment shortcuts, admin color scheme, show admin bar on frontend, language. Limitations in the free version: * You can only edit users with “subscriber” role. * You can not edit custom fields * You can not edit WooCommerce Billing and Shipping fields * You can not edit the BuddyPress custom fields #### Premium features [Buy premium plugin](https://wpsheeteditor.com/go/users-addon?utm_source=wp.org&utm_medium=web&utm_campaign=users-lite-buy) ** Money back guarantee.** We´ll give you a refund if the plugin doesn´t work. * Bulk Edit BuddyPress Profiles: The spreadsheet shows all custom fields automatically, view and edit all field types. * WooCommerce Stores: View all customers in a Table or Spreadsheet * WooCommerce Stores: Edit Customers Profiles * WooCommerce Stores: Edit Customers Shipping Information * WooCommerce Stores: Edit Customers Billing Information * WooCommerce Stores: Advanced search for customers. Find customers by address, city, state, billing info, shipping info, phone, etc. * Advanced search for Users. Find Users by Email, Role, Sign up date, Custom Fields. Use multiple search criterias and advanced operators during the search. * Edit Users with ANY role. * Edit Administrators, Editors, Authors * Edit Custom Fields. Add new fields to the bulk editor * Edit fields in user profiles added by other plugins * Edit YOAST SEO fields for authors * Update hundreds of users at once * And more. [Buy premium plugin](https://wpsheeteditor.com/go/users-addon?utm_source=wp.org&utm_medium=web&utm_campaign=users-lite-buy) ** Money back guarantee.** We´ll give you a refund if the plugin doesn´t work. #### Spanish / Español Este plugin te permite editar perfiles de usuarios usando una hoja de cálculo dentro de WP admin. Tú puedes ver todos los usuarios con rol “suscriptor” en la hoja de cálculo y rápidamente editar los campos de WordPress. La versión gratuita te permite: – Ver usuarios con rol “suscriptor” en la hoja de cálculo – Crear y editar usuarios – Puedes buscar usuarios por email y rol – Puedes copiar información de un usuario a otro – Puedes editar estos campos: Email, Nombre de usuario, Contraseña, Rol, Primer nombre, Apellido, Descripción, sitio web, esquema de colores, idioma La versión de pago te permite: – Editar todos los roles de usuarios: Edita administradores, administradores de tienda, editores, clientes, miembros de foros – Exportar e importar perfiles de usuarios para editar en excel o Google Sheets – Editar todos los campos, el editor mostrará todos los campos del perfil de usuario, incluyendo información de envío, información de pago de clientes de WooCommerce, etc. – Hacer búsquedas avanzadas por cualquier combinación de campos (ej. buscar por dirección, teléfono, usuarios inactivos, etc.) – Editar miles de usuarios a la vez en un segundo (ej. eliminar cientos de usuarios inactivos, reemplazar textos, establecer direcciones, copiar direcciones y teléfonos, etc.) [Descarga versión de pago](https://wpsheeteditor.com/go/users-addon?utm_source=wp.org&utm_medium=web&utm_campaign=users-lite-buy) ** Garantía de devolución de dinero si no te funciona el plugin.** ## 屏幕截图 * [[ * bulk editor ## 安装 #### Automatic installation Automatic installation is the easiest option as WordPress handles the file transfers itself and you don’t need to leave your web browser. To do an automatic install log in to your WordPress dashboard, navigate to the Plugins menu and click Add New. In the search field type WP Sheet Editor and click Search Plugins. Once you’ve found our plugin you can install it by simply clicking “Install Now”. #### Manual installation The manual installation method involves downloading our plugin and uploading it to your webserver via your favourite FTP application. The WordPress codex contains [instructions on how to do this here.](https://codex.wordpress.org/Managing_Plugins#Manual_Plugin_Installation) ## 常见问题 ### What user roles can I edit? The free version lets you edit subscribers only. The premium version lets you edit all user roles, including administrators, editors, authors, shop managers, customers, etc. [Buy premium plugin](https://wpsheeteditor.com/go/users-addon?utm_source=wp.org&utm_medium=web&utm_campaign=users-lite-buy) ### What user information can I edit? The free version lets you edit these fields: Email, Username, Password, Role, First name, Last name, description, nicename, website, display name, nickname, rich editing, comment shortcuts, admin color scheme, show admin bar on frontend , language. The premium version lets you edit all fields, including custom fields. You can create new columns for editing new fields. [Buy premium plugin](https://wpsheeteditor.com/go/users-addon?utm_source=wp.org&utm_medium=web&utm_campaign=users-lite-buy) ### Can I use this plugin on cheap / shared servers? Yes. You can set up the number of posts to save per batch and the waiting between batches. Tweaking those settings you can make it work with any server. ## 评价 ![](https://secure.gravatar.com/avatar/ba2ee5653d49b66f6fdc91a11704877b8b70c2eaa28cf31024e51eb432b113f2? s=60&d=retro&r=g) ### 󠀁[Saved me DAY OF WORK!!](https://wordpress.org/support/topic/saved-me-day-of-work/)󠁿 [Don](https://profiles.wordpress.org/d_random/) 2025 年 2 月 23 日 Adding users and editing information, this plugin is PERFECT!! Thank you!! ![](https://secure.gravatar.com/avatar/dd9201839abab93389b1c355ab4a473d51da8f2188d7e42a520d08f87c2e1710? s=60&d=retro&r=g) ### 󠀁[Amazing Results – Reduced DB from 75k users to 7k without errors](https://wordpress.org/support/topic/amazing-results-reduced-db-from-75k-users-to-7k-without-errors/)󠁿 [xpconversions](https://profiles.wordpress.org/xpconversions/) 2024 年 8 月 14 日 Firstly, I’d like to give special thanks to the support agent Teresa Melgar, who helped me clean my database step by step, and not with just some random copy-paste replies, or “here is the link to the plugin documentation” kind of support. She actually shared screenshots and step-by-step process via chat. Regarding the plugin, it was just amazing, I had a 75k users database with some complexities. I wanted to delete users with the role “subscriber” but excluding the “affiliate” role, customers, users that had pending payments orders, users with posts, etc. Add the complexity that I also have Woocommerce Subscriptions, which some of them are in the middle of the dunning process… I checked other plugins for this task but none of them was able to exclude specific roles, they would allow excluding users with purchases, but not with incomplete orders, for example, and definitely, excluding roles was not supported unless you pay for custom development. The result… a wonderful cleanup of the database from 75k to 7k users without a single error, without crashing, without out-of-time errors, etc. Just amazing. I wish all the plugins were developed this well. ![](https://secure.gravatar.com/avatar/807747ed5f9101acd8d0f0888cc165eaebad2da24250e7ff80a66ac59395abe5? s=60&d=retro&r=g) ### 󠀁[Amazing product and superb support!](https://wordpress.org/support/topic/amazing-product-and-superb-support/)󠁿 [amnonma](https://profiles.wordpress.org/amnonma/) 2024 年 6 月 26 日 Not only this is the most powerful editor for all our data editing needs, but the support is unparalleled. We had a complex issue with importing a lot of data to our new Woocommerce store. Their support team was courteous, quick, and professional. They did not give up on us even though the problems were not always in their court. When it was, they quickly issued a fix and even deployed it for us on our site and tested it. Really, I have not experienced anything close to this level of care. Would highly recommend this plugin to any Woocemrce store out there! ![](https://secure.gravatar.com/avatar/39318fcbdd651b2293444a6a58753e1811f213947ac537e5def3ce25936ce0da? s=60&d=retro&r=g) ### 󠀁[Great for viewing and editing WordPress data, users and pages](https://wordpress.org/support/topic/great-for-viewing-and-editing-wordpress-data-users-and-pages/)󠁿 [Mr David C Markwell](https://profiles.wordpress.org/davidmarkwell/) 2023 年 5 月 9 日 These speadsheets are an excellent way to simplify viewing and editing of users and other data in WordPress. ![](https://secure.gravatar.com/avatar/668610fb8ae1159d0de9907e186855772325b629d0e60159ad6f44b91006f31d? s=60&d=retro&r=g) ### 󠀁[Exactly what I needed](https://wordpress.org/support/topic/exactly-what-i-needed-903/)󠁿 [Wayne Ingraham](https://profiles.wordpress.org/wane27/) 2023 年 4 月 9 日 Was able to quickly edit a ton of users’ custom fields for a membership directory site. Super helpful for easy editing of fields. ![](https://secure.gravatar.com/avatar/e0f8a1b13df3d09b7e4a4ed2ba7e8b6f739b91fb21e3f61906e462f7d70a0ec0? s=60&d=retro&r=g) ### 󠀁[Did the job at a fair price](https://wordpress.org/support/topic/did-the-job-at-a-fair-price/)󠁿 [webdev2022](https://profiles.wordpress.org/webdev2022/) 2023 年 1 月 29 日 I needed to remove thousands of spam accounts from a site based on certain criteria and this plugin accomplished it nicely. Support was responsive, too. [ 阅读所有19条评价 ](https://wordpress.org/support/plugin/bulk-edit-user-profiles-in-spreadsheet/reviews/) ## 贡献者及开发者 「Bulk Edit and Create User Profiles – WP Sheet Editor」是开源软件。 以下人员对此 插件做出了贡献。 贡献者 * [ Jose Vega ](https://profiles.wordpress.org/josevega/) * [ wpsheeteditor ](https://profiles.wordpress.org/wpsheeteditor/) * [ vegacorp ](https://profiles.wordpress.org/vegacorp/) [帮助将「Bulk Edit and Create User Profiles – WP Sheet Editor」翻译成简体中文。](https://translate.wordpress.org/projects/wp-plugins/bulk-edit-user-profiles-in-spreadsheet) ### 对开发感兴趣吗? 您可以[浏览代码](https://plugins.trac.wordpress.org/browser/bulk-edit-user-profiles-in-spreadsheet/)， 查看[SVN仓库](https://plugins.svn.wordpress.org/bulk-edit-user-profiles-in-spreadsheet/)， 或通过[RSS](https://plugins.trac.wordpress.org/log/bulk-edit-user-profiles-in-spreadsheet/?limit=100&mode=stop_on_copy&format=rss) 订阅[开发日志](https://plugins.trac.wordpress.org/log/bulk-edit-user-profiles-in-spreadsheet/)。 ## 更新日志 #### V 1.5.43 – 2026-01-18 * Updated to CORE v2.26.1 #### V 1.5.42 – 2026-01-06 * Updated to CORE v2.26.0 #### V 1.5.41 – 2025-07-11 * Updated to CORE v2.25.19 #### V 1.5.40 – 2025-05-23 * Updated to CORE v2.25.18 #### V 1.5.39 – 2025-01-28 * Updated to CORE v2.25.17 #### V 1.5.38 – 2025-01-07 * Updated to CORE v2.25.16 #### V 1.5.37 – 2024-10-26 * Updated to CORE v2.25.15 #### V 1.5.36 – 2024-08-01 * CHANGE – USERS – General improvements * FIX – USERS – Multidimensional arrays in meta data aren’t being saved * FIX – USERS – WC – Search by product bought is not working #### V 1.5.35 – 2024-03-28 * Updated to CORE v2.25.13 #### V 1.5.34 – 2024-03-28 * Updated to CORE v2.25.12 #### V 1.5.33 – 2024-03-27 * Updated to CORE v2.25.11 #### V 1.5.32 – 2024-03-22 * Updated to CORE v2.25.10 #### V 1.5.31 – 2024-01-26 * Updated to CORE v2.25.9 #### V 1.5.30 – 2023-12-13 * Updated to CORE v2.25.8 #### V 1.5.29 – 2023-11-02 * Updated to CORE v2.25.7 #### V 1.5.28 – 2023-09-13 * CHANGE – USERS – Add more columns * CHANGE – USERS – Add compatibility with WC HPOS #### V 1.5.27 – 2023-07-23 * Updated to CORE v2.25.5 #### V 1.5.26 – 2023-07-13 * Updated to CORE v2.25.4 #### V 1.5.25 – 2023-07-06 * Updated to CORE v2.25.3 #### V 1.5.24 – 2023-04-13 * Updated to CORE v2.25.2 #### V 1.5.23 – 2023-02-03 * Updated to CORE v2.25.1 #### V 1.5.22 – 2022-12-15 * Updated to CORE v2.25.0 #### V 1.5.21 – 2022-11-11 * Updated to CORE v2.24.21 #### V 1.5.20 – 2022-09-29 * Updated to CORE v2.24.20 #### V 1.5.19 – 2022-08-19 * Updated to CORE v2.24.19 #### V 1.5.18 – 2022-07-31 * Updated to CORE v2.24.18 #### V 1.5.17 – 2022-06-23 * Updated to CORE v2.24.17 #### V 1.5.16 – 2022-05-25 * Updated to CORE v2.24.16 #### V 1.5.15 – 2022-04-19 * Updated to CORE v2.24.15 #### V 1.5.14 – 2022-04-06 * FIX – USERS – Sanitize login values when saving to prevent Stored Cross-Site Scripting attacks #### V 1.5.13 – 2022-03-02 * Updated to CORE v2.24.13 #### V 1.5.12 – 2022-01-26 * Updated to CORE v2.24.12 #### V 1.5.11 – 2021-12-08 * Updated to CORE v2.24.11 #### V 1.5.10 – 2021-10-20 * Updated to CORE v2.24.10 #### V 1.5.9 – 2021-09-10 * Updated to CORE v2.24.9 #### V 1.5.8 – 2021-08-18 * Updated to CORE v2.24.8 #### V 1.5.7 – 2021-07-14 * Updated to CORE v2.24.7 #### V 1.5.6 – 2021-06-19 * CHANGE – USERS – Improve the buddypress integration #### V 1.5.5 – 2021-06-03 * CHANGE – USERS – Improve the search form #### V 1.5.4 – 2021-05-19 * Updated to CORE v2.24.4 #### V 1.5.3 – 2021-04-21 * FIX – USERS – Small bug fixes #### V 1.5.2 – 2021-03-12 * CHANGE – USERS – Improve customer search #### V 1.5.1 – 2021-02-24 * Updated to CORE v2.24.1 #### V 1.5.0 – 2021-02-10 * NEW – USERS – More WC integrations * CHANGE – USERS – Improve support for wc memberships #### V 1.4.1 – 2020-12-19 * Updated to CORE v2.23.0 #### V 1.4.0 – 2020-11-21 * NEW – USERS – Compatibility for EDD * NEW – USERS – Add options to filter rows globally * CHANGE – USERS – Add warnings to the import screen #### V 1.3.7 – 2020-10-22 * Updated to CORE v2.21.3 #### V 1.3.6 – 2020-10-11 * Updated to CORE v2.21.2 #### V 1.3.5 – 2020-10-07 * Updated to CORE v2.21.1 #### V 1.3.4 – 2020-10-07 * CHANGE – USERS – Improve the handling of WC customers #### V 1.3.3 – 2020-09-08 * CHANGE – USERS – Improve the removal of customers #### V 1.3.2 – 2020-07-22 * CHANGE – USERS – Allow to hide some columns * CHANGE – USERS – Add more options to the import process * FIX – USERS – It sends the emails to the wrong address #### V 1.3.1 – 2020-06-26 * CHANGE – USERS – Add more columns #### V 1.3.0 – 2020-05-20 * NEW – USERS – Integrate with WC Memberships #### V 1.2.0 – 2020-04-20 * NEW – USERS – Allow to troubleshoot WC customer lookup issues * CHANGE – USERS – Add support for WooCommerce 4.0 * CHANGE – USERS – Improve the search #### V 1.1.25 – 2020-03-17 * Updated to CORE v2.18.1 #### V 1.1.24 – 2020-03-16 * CHANGE – USERS – Capitalize the “Edit Users” option in the wp-admin menu dropdown * CHANGE – USERS – The role column should be type select * FIX – USERS – Fatal error when saving a taxonomy column #### V 1.1.23 – 2020-02-19 * CHANGE – USERS – Exclude private fields of ninjaforms: wpw0_nf_form_preview_tmp- 1560123582_actions=tmp-3=settings=submitter_email * CHANGE – USERS – Exclude private fields of learndash: _sfwd-course_progress_45 =topics=74=203 * CHANGE – USERS – FREE – Add message above indicating the limitations similar to the wc products sheet * CHANGE – USERS – Allow to unlock the “registration date” column to edit #### V 1.1.22 – 2020-01-13 * Updated to CORE v2.16.0 #### V 1.1.21 – 2019-11-24 * Updated to CORE v2.15.4 #### V 1.1.20 – 2019-11-18 * Updated to CORE v2.15.3 * CHANGE – USERS – Make the search by keyword search on the user_login, display name, and nice name * FIX – USERS – Remove internal fields from learndash that should never be edited #### V 1.1.18.1 – 2019-10-18 * Updated to CORE v2.15.2 #### V 1.1.17 – 2019-10-01 * Updated to CORE v2.15.0 —— V 1.1.16 – 2019-09-06 —— Updated to CORE v2.14.0 —— V 1.1.15 – 2019-08-11 —— Updated to CORE v2.13.1 —— V 1.1.14 – 2019-08-08 —— FIX – USERS – BULK EDIT – the status dropdown doesn’t have the right values Updated to CORE v2.13.0 —— V 1.1.13 – 2019-07-02 —— Updated to CORE v2.12.0 —— V 1.1.12 – 2019-05-27 —— NEW – USERS – Added quick access buttons above the users lists CHANGE – USERS – If the user is not allowed to create users, don’t show the option in the toolbar CHANGE – USERS – If the user is not allowed to upgrade user roles, make the roles column readonly FIX – USERS – IMPORT – Allow to identify existing users by id, email, or username only FIX – USERS – Private wpse columns aren’t being excluded FIX – USERS – The status column was blacklisted by mistake Updated to CORE v2.11.2 —— V 1.1.11 – 2019-04-23 —— Updated to CORE v2.11.1 FIX – USERS – Advanced filters > exclude keywords – it wasn’t returning the right results —— V 1.1.10 – 2019-04-17 —— Updated to CORE v2.11.0 CHANGE – USERS – Removed the columns with prefixes bookmark_id and bpbm-last-seen-thread- CHANGE – USERS – exclude columns with key prefix meta-box-order_ FIX – USERS – The sheet rows were empty when a post types sheet was active FIX – USERS – The “Show admin bar on frontend” cell appears checked regardless of the value [See full changelog.](https://wpsheeteditor.com/changelog/users-spreadsheet/?utm_source=wp.org&utm_medium=web&utm_campaign=users-lite-changelog) ## 额外信息 * 版本 **1.5.43** * 最后更新：**4 月前** * 活跃安装数量 **1,000+** * WordPress 版本 ** 4.7 或更高版本 ** * 已测试的最高版本为 **6.9.4** * 语言 * [English (US)](https://wordpress.org/plugins/bulk-edit-user-profiles-in-spreadsheet/) * 标签 * [buddypress](https://cn.wordpress.org/plugins/tags/buddypress/)[bulk edit](https://cn.wordpress.org/plugins/tags/bulk-edit/) [spreadsheet](https://cn.wordpress.org/plugins/tags/spreadsheet/)[users](https://cn.wordpress.org/plugins/tags/users/) [woocommerce](https://cn.wordpress.org/plugins/tags/woocommerce/) * [高级视图](https://cn.wordpress.org/plugins/bulk-edit-user-profiles-in-spreadsheet/advanced/) ## 评级 5 星（最高 5 星）。 * [ 19 条 5 星评价 ](https://wordpress.org/support/plugin/bulk-edit-user-profiles-in-spreadsheet/reviews/?filter=5) * [ 0 条 4 星评价 ](https://wordpress.org/support/plugin/bulk-edit-user-profiles-in-spreadsheet/reviews/?filter=4) * [ 0 条 3 星评价 ](https://wordpress.org/support/plugin/bulk-edit-user-profiles-in-spreadsheet/reviews/?filter=3) * [ 0 条 2 星评价 ](https://wordpress.org/support/plugin/bulk-edit-user-profiles-in-spreadsheet/reviews/?filter=2) * [ 0 条 1 星评价 ](https://wordpress.org/support/plugin/bulk-edit-user-profiles-in-spreadsheet/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/bulk-edit-user-profiles-in-spreadsheet/reviews/#new-post) [查看全部评论](https://wordpress.org/support/plugin/bulk-edit-user-profiles-in-spreadsheet/reviews/) ## 贡献者 * [ Jose Vega ](https://profiles.wordpress.org/josevega/) * [ wpsheeteditor ](https://profiles.wordpress.org/wpsheeteditor/) * [ vegacorp ](https://profiles.wordpress.org/vegacorp/) ## 支持 有话要说吗？是否需要帮助？ [查看支持论坛](https://wordpress.org/support/plugin/bulk-edit-user-profiles-in-spreadsheet/)