Bulk Edit and Create User Profiles – WP Sheet Editor


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
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
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
Garantía de devolución de dinero si no te funciona el plugin.

Capturas de pantalla

  • 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.


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

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

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.


3 de Mayo de 2020
Was initially reluctant tying it out. Had already already activate another plugin to commence the export-process-import process to load data. Whao! is was a huge time-saver. I'm very comfortable with spreadsheet. I couldn't alter the custom field (it was a pro version feature). The free version however solve 70% of my problem
23 de Marzo de 2020
This is an incredible time saver if you have to manage, bulk edit, search (or advanced search), or sort users — or all of them. Especially a lot of users. Great work to the team and so many thanks to them for making this.
10 de Marzo de 2020
I've stumbled upon this plugin, via DuckDuckGo One of my clients handed me spreadsheet with 27 customers. Task was to create WP account for each on the list. Thanks to the WP Sheed Editor plugin, this was done quickly and effortlessly . WP Sheet Editor was very easy to use, and its editable fields worked and responded just like any other spreadsheet desktop app. Seriously good tool.
2 de Marzo de 2020
I just needed to switch all my default "subscriber" roles to a custom role. This plugin made it easy for me to switch the 100+ users that I had in about 5 minutes. It did exactly what I needed it to do. Thanks!
26 de Noviembre de 2019
I had to clean up user data on a membership site. Sheet editor just made it so much more manageable to clean up the data. It is stable and has the same functional feel of a worksheet and really provides an easier overview of data. Has no problems finding meta fields created by other plugin programs and has plenty of functionality to find and update data.
17 de Septiembre de 2019
This plugin has saved me so so much time. You will not regret getting the full version to automate your import processes. I’ve used it for Easy Digital Downloads imports, bulk media imports (using download links from S3 even!), and bulk user imports. They all work seamlessly well. Jose is absolutely wonderful. I needed this plugin to do things very specific for my project and he was able to go above and beyond to help me fulfill those needs. Definitely 100% recommend this plugin. If you need to import data to WordPress, this is the plugin to go to.
Leer los 9 comentarios

Colaboradores & Desarrolladores

“Bulk Edit and Create User Profiles – WP Sheet Editor” es software de código abierto. Las siguientes personas han contribuido a este plugin.


Historial de cambios

V 1.3.7 – 2020-10-22

  • Updated to CORE v2.21.3

V 1.3.7 – 2020-10-11

  • Updated to CORE v2.21.2

V 1.3.7 – 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.4 – 2020-09-08

  • CHANGE – USERS – Improve the removal of customers

V 1.3.4 – 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.4 – 2020-06-26

  • CHANGE – USERS – Add more columns

V 1.3.4 – 2020-05-20

  • NEW – USERS – Integrate with WC Memberships

V 1.3.4 – 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.3.4 – 2020-03-17

  • Updated to CORE v2.18.1

V 1.3.4 – 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.3.4 – 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.3.4 – 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 – 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
* NEW – ACF – Add support for gallery field
* NEW – CORE – Add contextual option: realign cells to fix rare scenarios when cell borders don’t match
* NEW – FILTERS – Add option to locate column to save time when searching for a column in the sheet.
* NEW – UNIVERSAL SHEET – IMPORT – Add advanced setting to skip the first N rows, so we can start imports from where we left off
* NEW – WC Products – Add “All” option to the dropdown of global attributes columns, which automatically selects all the options in the dropdown while saving
* NEW – WC Products – Add contextual menu to copy variations from the selected row, which opens the modal and auto-selects the product
* NEW – WC Products – Add contextual menu to create variations for the selected row, which opens the create variations modal and auto-selects the product
* NEW – WC Products – Add the “product_variation” option to the post types column to convert any product into a variation
* NEW – WC Products – Allow to edit the parent product of variations
* CHANGE – CORE – Added internal cache of conversion from file URLs to file IDs to speed up imports and savings
* CHANGE – CORE – Added internal cache of conversion from friendly terms to IDs to speed up imports and savings
* CHANGE – CORE – Free – make the pro columns more subtle, highlight the cell value
* CHANGE – CORE – Show “menu order” column for all post types because some post types use it for unorthodox purposes
* CHANGE – CSV Import – Optimize the reading of CSV files to use less memory and read huge files faster
* CHANGE – POSTS TEMPLATE – when duplicating posts, don’t copy the post date, so the new posts have new dates
* CHANGE – SPREADSHEET SETUP – Don’t allow to save new custom post types when the custom post types module is not available
* CHANGE – UNIVERSAL SHEET – Delete old csvs when the sheet loads because the cron job doesn’t run on rare server setups
* CHANGE – UNIVERSAL SHEET – EXPORT – Add indications at the end of the process to answer questions like download didn’t start, where to find the file, when are the files deleted.
* CHANGE – UNIVERSAL SHEET – EXPORT – Optimize the download of large files to use less memory and start faster
* CHANGE – UNIVERSAL SHEET – IMPORT – Add an advanced option to auto-retry failed batches
* CHANGE – WC Products – Free – Enable columns: ‘view_post’, ‘open_wp_editor’, ‘post_status’, ‘post_modified’, ‘post_date’, ‘_length’, ‘_height’, ‘_width’, ‘_weight’,
* CHANGE – WC Products – When we add attributes and at least one is “allow for variations”, automatically set the product as variable
* CHANGE. UNIVERSAL SHEET. deactivate the rest api by default and add option to settings page to activate manually to avoid compatibility issues with other REST API configurations or external apps.
* FIX – CORE – SERIALIZED FIELDS – When the field contains a single level and subfields have integers as keys, it only shows the value of the first subfield in the cells and the other subfields appear empty
* FIX – CORE – VIEW column has the wrong link when viewing custom post types as a draft
* FIX – FORMULAS – When deleting thousands of rows completely, it only deletes half
* FIX – WC Products – EXPORT – Some column headers when exporting attributes are missing because the first line of the file is not read properly
* FIX – WC Products – Export – Some columns were excluded from the export when it was a custom field used by variations
* FIX – WC Products – Import – Remove the & symbol from the SKU before saving. WC returns a duplicate SKU error when it’s not duplicate.
* FIX – WC Products – The internal caches of WC aren’t cleared after saving, causing changes not to appear when sites use aggressive cache like wp.com
* FIX – WC Products – When we delete a product completely, we remove the parent row but we should remove the child variation rows as well
* FIX – WC Products – when we edit global attributes in their own columns and change product type from simple to variable at the same time, automatically set the attribute as “used in variation”
* FIX – WC Products > copy variations – When saving meta data in the copied variations, unserialize to prevent double serialization from WP
* FIX – WC Products > create variations > create for every combination of attributes – PHP warning
* FIX. CORE. delete all traces of the plugin on uninstall

See full changelog.