Title: Add users from spreadsheet broken?
Last modified: August 30, 2016

---

# Add users from spreadsheet broken?

 *  Resolved [webmarc](https://wordpress.org/support/users/webmarc/)
 * (@webmarc)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/add-users-from-spreadsheet-broken/)
 * Or perhaps I’m doing something wrong:
 * I’ve tried uploading an xls and an xlsx file that has column headings that match
   the fields in addition to the username field (Username First Name Last Name Outlet
   Phone). None of the fields are empty for any of the rows…
 * … every attempt to upload is met with an error message at the top of page with
   a red vertical bar, “File must be .xls or .xlsx”
 * To create the sheet, I first used the “Export to Excel” function, edited it in
   Excel for Mac 2011, and selected the file and uploaded it. I removed columns 
   such as Date Added and Last Login.
 * Help? I have about 1000 users to import, so doing it by hand isn’t really an 
   option. Alternatively, can I just slam some SQL together and attack the table
   by hand?
 * [https://wordpress.org/plugins/front-end-only-users/](https://wordpress.org/plugins/front-end-only-users/)

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

 *  Plugin Author [Rustaurius](https://wordpress.org/support/users/rustaurius/)
 * (@rustaurius)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/add-users-from-spreadsheet-broken/#post-6483806)
 * Hi Marc,
 * We loosened up the file type checking, so there should be less false positives,
   if you want to update to 2.2.10 and give it another go.
 *  Thread Starter [webmarc](https://wordpress.org/support/users/webmarc/)
 * (@webmarc)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/add-users-from-spreadsheet-broken/#post-6483827)
 * First, thanks for being super responsive.
 * I just updated to 2.2.11, but no change in behavior: still getting the same message.
   Anything I can do to help troubleshoot?
 *  Plugin Author [Rustaurius](https://wordpress.org/support/users/rustaurius/)
 * (@rustaurius)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/add-users-from-spreadsheet-broken/#post-6483876)
 * Hi Marc,
 * Sorry, that was our fault; we ended up not including the updated file. We’ve 
   uploaded a new version and tested with it, and it seems to be working fine now.
 *  Thread Starter [webmarc](https://wordpress.org/support/users/webmarc/)
 * (@webmarc)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/add-users-from-spreadsheet-broken/#post-6483890)
 * Nailed it. Thanks so much!

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

The topic ‘Add users from spreadsheet broken?’ is closed to new replies.

 * ![](https://ps.w.org/front-end-only-users/assets/icon-128x128.png?rev=1805921)
 * [Front End Users](https://wordpress.org/plugins/front-end-only-users/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/front-end-only-users/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/front-end-only-users/)
 * [Active Topics](https://wordpress.org/support/plugin/front-end-only-users/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/front-end-only-users/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/front-end-only-users/reviews/)

## Tags

 * [bulk add](https://wordpress.org/support/topic-tag/bulk-add/)
 * [spreadsheet](https://wordpress.org/support/topic-tag/spreadsheet/)
 * [upload](https://wordpress.org/support/topic-tag/upload/)

 * 4 replies
 * 2 participants
 * Last reply from: [webmarc](https://wordpress.org/support/users/webmarc/)
 * Last activity: [10 years, 9 months ago](https://wordpress.org/support/topic/add-users-from-spreadsheet-broken/#post-6483890)
 * Status: resolved