Title: Cannot insert user without email
Last modified: July 24, 2017

---

# Cannot insert user without email

 *  Resolved [websitewendy](https://wordpress.org/support/users/websitewendy/)
 * (@websitewendy)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/cannot-insert-user-without-email/)
 * I used the sample sheet to add my user data .. all fields except URL are filled,
   there are no extra spaces in any field, and there are only 267 rows, but the 
   import runs endlessly until I close the page, with every line item spouting this
   error ..
    – – – – – – – – Cannot insert user without email – – – – – – – –
 * I have tried with the existing users and without..
    as it is attempting the import..
   the row number increases (1,2,3,4 etc) but EVERY user id it returns is ‘1’ EVERY
   user status it returns is ‘1-1’
 * Your assistance/advice appreciated
    -  This topic was modified 8 years, 10 months ago by [websitewendy](https://wordpress.org/support/users/websitewendy/).

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

 *  Thread Starter [websitewendy](https://wordpress.org/support/users/websitewendy/)
 * (@websitewendy)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/cannot-insert-user-without-email/#post-9348041)
 * I knew as soon as I posted something here I would figure it out ….
    .. I was 
   using the mac program ‘numbers’ and although the file extension was .csv, it 
   wasn’t reading properly .. I re-exported and it worked as expected. thank you!
 *  [xadapter](https://wordpress.org/support/users/xadapter/)
 * (@xadapter)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/cannot-insert-user-without-email/#post-9350004)
 * Hello Wendy,
 * In order to import and export customer data into woocommerce by using our plugin,
   you need to have csv file and whichis UTF-8 encoded. we glad that your issue 
   got reslved.
    Please get back to us if you need any help.
 * Regards,
    Veeresh Team XA
 *  [mujeebur](https://wordpress.org/support/users/mujeebur/)
 * (@mujeebur)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/cannot-insert-user-without-email/#post-9353115)
 * Hi [@websitewendy](https://wordpress.org/support/users/websitewendy/),
 * Please leave a [review ](https://wordpress.org/support/plugin/users-customers-import-export-for-wp-woocommerce/reviews/#new-post)
   if the plugin/support helped you.

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

The topic ‘Cannot insert user without email’ is closed to new replies.

 * ![](https://ps.w.org/users-customers-import-export-for-wp-woocommerce/assets/
   icon-256x256.gif?rev=3065206)
 * [Export and Import Users and Customers](https://wordpress.org/plugins/users-customers-import-export-for-wp-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/users-customers-import-export-for-wp-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/users-customers-import-export-for-wp-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/users-customers-import-export-for-wp-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/users-customers-import-export-for-wp-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/users-customers-import-export-for-wp-woocommerce/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [mujeebur](https://wordpress.org/support/users/mujeebur/)
 * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/cannot-insert-user-without-email/#post-9353115)
 * Status: resolved