File Format

The accepted file format is a text file with values separated by tabs, providing one or more of the following values on a single line for each user:

1. user_email The user’s email address.
2. user_login The username.
3. first_name The user’s first name.
4. last_name The user’s surname.
5. user_url The URL of the user’s website.
6. user_pass The user’s password. Unless provided, a password is generated automatically.
7. roles The roles that the user should have. The user will only be assigned to existing roles, new roles are not created. The default role is assumed when empty. Roles are to be indicated by their keys, for example administrator, editor, author, contributor, subscriber.
8. groups The groups that the user is to be assigned to. The user will be assigned to existing groups, new groups are created if the option to create groups is enabled.
9. meta The complete set of extended user profile data (JSON-encoded user meta as obtained when exporting users with this tool with the option Include extended user profile data enabled).
10. meta:{meta_key} Indicates a column holding extended user profile data. This allows to provide user meta data by indicating the meta key and by providing the meta value for each user. This requires a column order declaration using a @ column order line at the beginning of the import file used. One column entry must be provided for each meta key, indicating meta: followed by the meta key. For example, to specify a column that allows to set the example meta data for each user, meta:example must be indicated.

• The user_email column is required.
• All other columns are optional.
• If no username is provided in the user_login column, the email address is taken as the username.
• Empty columns are required if values in subsequent columns are provided; a single tab is considered as an empty column.

Example:

Information and examples are also accessible through the Help tabs of the Import Users and Export Users sections.