Title: Import users from a sheet
Last modified: August 24, 2016

---

# Import users from a sheet

 *  [Klokwerk-design](https://wordpress.org/support/users/klokwerk-design/)
 * (@klokwerk-design)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/import-users-from-a-sheet/)
 * Hi there,
 * First, wonderful plugin. Love the junction with wp-invoice. I was wondering, 
   however, if it would be possible to add a set of users by spreadsheet (csv or
   xml). I have an administration of 89 customers and quite a lot of additional 
   fields, so that would be brilliant. Alas, I can’t find a function like that in
   the plugin. More of a pity, the importer-plugins I checked didn’t seem to be 
   finding the additional fields made by the plugin, so that doesn’t work out either.
   And looking at the MySQL itself for sorting out the option to add the users by
   query I couldn’t find the location of the additional fields either.
 * So I hope you have an answer to either of this three questions:
 * 1. Is it possible to insert a set of data in the free version or payed version?
   
   2. If not, do you perhaps know an appropriate xml or csv plugin that suits this
   plugin for importing users? 3. And if not, could you give me the tables I should
   update when writing mySQL-queries on the WP database?
 * Hope to hear from you soon.
 * _[ [Signature moderated](http://codex.wordpress.org/Forum_Welcome#Signatures)]_
   
   [http://www.klokwerk-design.nl](http://www.klokwerk-design.nl)
 * [https://wordpress.org/plugins/wp-crm/](https://wordpress.org/plugins/wp-crm/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [Klokwerk-design](https://wordpress.org/support/users/klokwerk-design/)
 * (@klokwerk-design)
 * [11 years ago](https://wordpress.org/support/topic/import-users-from-a-sheet/#post-6011889)
 * OK well thanks for not answering, I see the question has been running for a few
   years, so here’s my answer to help some others:
 * The data are all set in the tables wp_users and wp_usermeta, which makes “Import
   users from CSV with meta” the best plugin to use for this purpose.
 *  [Marcus](https://wordpress.org/support/users/marcdeshon/)
 * (@marcdeshon)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/import-users-from-a-sheet/#post-6011947)
 * [@klokwerk-design](https://wordpress.org/support/users/klokwerk-design/):
    Thanks!
   I would have passed on this plugin without your info here…

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Import users from a sheet’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-crm_c36510.svg)
 * [WP-CRM - Customer Relations Management for WordPress](https://wordpress.org/plugins/wp-crm/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-crm/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-crm/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-crm/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-crm/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-crm/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [xml](https://wordpress.org/support/topic-tag/xml/)

 * 2 replies
 * 2 participants
 * Last reply from: [Marcus](https://wordpress.org/support/users/marcdeshon/)
 * Last activity: [10 years, 8 months ago](https://wordpress.org/support/topic/import-users-from-a-sheet/#post-6011947)
 * Status: not resolved