Import Joomla Users from Excel or CSV File

Migrate users with custom data fields as User-Profile plugin is supported

User import extension supports wide range of fields:

• Joomla core user data: Id, Name, Username, Password, Email, Params, Register Date and Group(s).
• Joomla Users Fields: Any custom fields created by new Joomla 3.7+ Fields system, read more.
• Preinstalled User-Profile plugin: Address 1, Address 2, City, Region, Country, Postal/ZIP Code, Phone, Website, Date of Birth, About, and any other custom fields.

Main features of user import:

• Creates new users, update data of existing users or does both actions at the same time.
• Columns order in Excel/CSV file is not essential.
• Allows you to import users into one or a few Joomla groups.
• Gives possibility to set new password for users (plain or already encrypted one).
• If there are no passwords in your file - import can create passwords for new users automatically.
• Notifies new users by email about registration and provides with login/password, read more.
• "Email Sending Report" is available, so you can check if emails were sent to users.
• Allows to save import settings into "Profile" for frequent import, read more.
• Makes it possible to block users automatically that are no longer exist in Excel/CSV file.
• Grants and revokes access to import extension for your coworkers.
• Imports multiple checkbox values.
• Provides auto user import by schedule(using Cron).
• Imports into "Improved AJAX Import & Register" extension fields.
• Supports most of the third party components like "K2" or "AcyMailing".

What people say about import extension:

"Incredible professional solution! Super easy to use. Works perfectly on my Joomla 3.7 with enabled User-Profile plugin. All 4235 users with extra data like Company, Position, Address, City - were imported successfully without any problems! I extremely recommend it!!!"
Mike, Manager, USA

"We were using custom made user import which cost us $1000. But each month we had problems with import and developers had different excuses all the time (wrong format, wrong columns, etc...). I still can't believe that this "user import" for €19.99 replaced our custom made import for $1000 with no additional customizations!!! I wish I found this extension much earlier. Thank you for such a great tool!" - Jan, CEO, Germany

"Very fast and responsive support! My Joomla had compatibility problems and a lot of extensions didn't work properly. I just gave support access to my Joomla and they make work not only import but solved compatibility problems permanently for all extensions!!! Thank you a lot!!
Daniela, Owner of Web Design agency, United Kingdom

Next

Difference between "User-Profile Plugin" fields and "Joomla User Fields".

User-Profile plugin is a preinstalled Joomla extension which is disabled by default.
You can enable it here: Admin panel->Extensions->Plugins:

Plugin allows you to extend Joomla core user fields and adds one more tab with additional fields to user profile.
You can find these additional fields here: Admin panel->Users->Manage->Select any user:

Plugin also puts these fields for each registered user in his profile on the website, so he can edit data in these fields. Unfortunately there is no easy way to customize/add/remove these fields without additional extension or extra codding work (however if you're familiar with XML, you can do it). Our import extension supports all these fields and can import data from excel/csv file in these fields. Even if you customized or created new fields via XML - import extension will support them.

Joomla User Fields supported by Joomla 3.7 and later. These fields have a huge advantage compared to User-Profile plugin - you can customize/add/remove them as you need. The wide range of available fields include: text, dropdown, link, check box and much more. You can find these fields in Admin panel->Users->Fields

On the screenshot you can see that four fields have been created, three regular text fields (skype, Tax Id and Position) and one dropdown field with car models. These fields are available in the admin panel and in user's account on website, so admin and user can read and change this data.

All fields created with "Joomla User Fields" system supported by our user import extension.

Conclusion: User-Profile plugin is a much older and less flexible way to store users data. So if you are looking for a way to store more data about users then it is better to start with new "Joomla User Fields". However if your website uses "User-Profile" fields for a long time and it perfectly meets your needs then there is no necessity to stop using it.

Import "Profiles" for regular use.

"Profile" is like a template with stored import settings. It was developed to save your time by setting up import settings once instead of doing this for each import.

Let's see how to set it up. For example, we've got a file with users from a third-party website and we need to create accounts for those users in our Joomla website. Since we must update users every week - it's better to use "Profiles" feature.

How to create "Profile":
1. Upload excel/CSV file.
2. Select Joomla group, match file's columns with user fields and specify other settings you may need.
3. Click on "SAVE PROFILE" button and give "Profile" a name. That's it, a new "Profile" has been created.

How to use "Profiles":
1. Start a new import. On step 1 you will see recently created profile. Click on upload button and select excel/CSV file.
2. Click "Next" and on step 2 all settings we’ve chosen before are already pulled up from "Profile" and automatically applied. So we only need to check if everything is okay and go to the next step.

Here is some useful cases when "Profile" feature comes in handy:
- file with users information has to be imported regularly, e.g. each day or week;
- you have two or more different excel/CSV files and each file has its own columns’ order;
- you need to import all users from file #1 into e.g. "Managers" group and users from file #2 into "Editors" group.

That's all you need to know to start saving time now!

Sending emails to imported and/or updated users.

“Import Users” tool provides option to notify new and/or existing users. With this option you can send personalized messages along with users' data like Name, Address, Password, etc.

In the example, we’ll show how to set up email sending to newly imported users. Since the user mailing is turned off by default, let’s enable it by the following steps:

1. Go to 2nd step.

2. In "Email Settings" select "Notify..." options.

3. Write email message.

“Import Users” offers two types of variables:

• “Default” – pre-defined variables list that includes commonly used variables, like Name, Username, Website;
• “Dynamic” – they pull values from imported file on the fly.

You can use “Default” & “Dynamic” variables in the "Email Template" popup. Both types of variables can be put into email “Subject” and email “Body”. Using of "Default" variables is easy, just place in editor listed variables like %username% and it will be replaced with the real username.

Data for "Dynamic" variables are taken from uploaded excel or csv file. So, to use these variables it's required to have already matched columns to Joomla fields. For example if we match “Name”, “Username”, “Email”, “Address”, “Country” and “Postal code” on step 2 we will be able to use these variable in Email Template popup.

Then click at "Add Fields" button and we'll see dynamic variables of matched columns. To insert any of the above variables, just click on it. If list of variables is empty, that means that columns from the file haven’t been matched with Joomla fields, so match the columns first.

In case you want to use custom text colors, insert images or change sizes, please use “Source Code”. With it you can change HTML the way you need. To turn it on, go to “Tools” - > “Source Code”:

After finishing configuration of email template click “Save”.

In case you want to email the existing users as well, enable “Notify existing users” option and set it up as before.