How to Import WordPress Users from Google Sheets

In this tutorial, we will show you how to import WordPress users from Google Sheets. You will be able to create or update users from Google Sheets.

The best thing is that you won’t need to install any browser extensions nor run any scripts. This makes it easy to connect WordPress to Google Sheets and import users, since you will be able to do it all from the WordPress dashboard.

What you need to import WordPress users from Google Sheets

Let’s see what elements you need to import WordPress users from Google Sheets:

WP Sheet Editor – WordPress Users

This plugin allows you to manage your WordPress users in an intuitive spreadsheet.

You can do advanced searches, apply bulk changes with a few clicks, export user profiles to a CSV file, or import user profiles from a CSV file to WordPress.

Google Sheets Sync

This service provided by wpsheeteditor.com allows you to connect your WordPress site to Google Sheets to easily export and import content.

It works with all WP Sheet Editor spreadsheets running in the backend, so you will be able to export and import posts, pages, products, orders, users, events, courses, donation forms, etc.

When you sign up to the Google Sheets Sync service, you will receive a plugin helper that will allow you to connect your WordPress site to your Google account from any WP Sheet Editor spreadsheet.

You can follow this guide.

1- Prepare a Google Sheet with users data

The first thing you need to do in order to import users from Google Sheets to WordPress is prepare the Google spreadsheet you want to import.

You need to add the necessary information for each user.

Important:

• The Google Sheets Sync service will only accept importing Google Sheets files that have been generated with the service itself.
• Therefore, you will need to first export even one user and then add the information in that file.
• This is good because we protect your privacy by not having access to any other files.
• We also do not store your Google Sheets files on our servers.

Here is a tutorial on how to export WordPress users to Google Sheets.

You should have a spreadsheet like this:

2- Import user profiles from Google Sheets into WordPress

Having the Google Sheets file we want to import ready, we can now proceed to import it into WordPress by following these steps:

First, open the Import tool on the WordPress users spreadsheet:

Second, select the Google Sheet you want to import.

Select Google Sheets in the Source drop-down.

Now select the file in the Google Sheet file field. As we have explained, only Google Sheet files generated with the Google Sheets Sync service will be read here.

If you don’t find the file you want to import, you can click on the refresh button.

Once you have selected the file, click on Next.

Third, select the columns you want to import.

WP Sheet Editor allows two options here:

• Import all the columns
• Select individual columns to import

Fourth, you need to select how you want to import the data.

In this case, we will Create new items and update existing items.

Since we will import existing items, we can match the existing rows by ID.

Now click on Next.

Fifth, click on The preview is fine, start import if everything looks OK.

Once the process is complete, you’ll see the details of how many items were processed and, in this case, how many items were updated and how many items were created.

As you can see in the screenshot below, we updated 11 rows and created 89 rows.

With WP Sheet Editor – WordPress Users and Google Sheets Sync, you can manage WordPress user profiles with Google Sheets. You can create new users from Google Sheets, or bulk update existing user profiles using a Google Spreadsheet.