Title: Import spreadsheet (csv) data
Last modified: August 21, 2016

---

# Import spreadsheet (csv) data

 *  Resolved [Thomas Brain](https://wordpress.org/support/users/beatthebog/)
 * (@beatthebog)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/import-spreadsheet-csv-data/)
 * Hi Connor,
 * Is there any facility to import spreadsheet data to WP Athletics?
 * It would be good to have some way of doing this, rather than manually (all our
   results are taken down in tables from a registration plugin called Event Espresso,
   and this data can then be exported as a spreadsheet).
 * Many thanks,
 * Tom
 * [http://wordpress.org/plugins/wp-athletics/](http://wordpress.org/plugins/wp-athletics/)

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

 *  Plugin Author [conormccauley](https://wordpress.org/support/users/conormccauley/)
 * (@conormccauley)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/import-spreadsheet-csv-data/#post-4359290)
 * Hi Thomas,
 * Thanks for your interest in the plugin. It’s a great idea and is something I 
   had considered but did not include in the first version as the focus was on basic
   functionality and getting that right before any new features are added.
 * My only concern with importing from a spreadsheet are the following ‘hurdles’
   and what to do when I hit them:
 * – assuming we are matching results by name, what happens when we come across 
   a name of which there are 2 or more people with that same name in the club, which
   user is the result assigned to?
    – how do we handle results for users not registered
   in the system, do we create a new user account, and what if that user later wishes
   to register?
 * They are a couple of head scratchers and it’s something I’d love to add in but
   I need to have a clear vision of how it will work first. Any thoughts you have
   would be much welcomed and thanks again for the feedback.
 * Conor.
 *  Thread Starter [Thomas Brain](https://wordpress.org/support/users/beatthebog/)
 * (@beatthebog)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/import-spreadsheet-csv-data/#post-4359312)
 * Hi Conor,
 * Thanks for the reply – really great plugin and I now have it working on my site
   and looking good! Thank you indeed.
 * Not being a coder, I’m not sure I’m qualified to help help with the spreadsheet
   conundrum – If you were to implement a script to upload csv data, I guess you’d
   have to have strict guidelines on the layout of the data and number of columns
   selected from the imported data (and perhaps also provide a template csv layout
   for the future users). And then also perhaps have someway of registering only
   one result per namr. The other extra name/result would then have to be input 
   manually?
 * Or use an allocated, visible registration number per name/user?
 * I really don’t know about the user registration conflict thing – I guess you’d
   have to allow a script to create the new accounts with the spreadsheet data and
   then, when a user tries to register an account with an existing name, have a 
   notification come up pointing this out? Could get complicated!
 * I guess with a new field for registration numbers, visible for each user, you
   could play it that way? (obviously the reg numbers would be unique).
 * Thanks,
 * Tom

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

The topic ‘Import spreadsheet (csv) data’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-athletics_ab6242.svg)
 * [WP Athletics](https://wordpress.org/plugins/wp-athletics/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-athletics/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-athletics/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-athletics/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-athletics/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-athletics/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Thomas Brain](https://wordpress.org/support/users/beatthebog/)
 * Last activity: [12 years, 6 months ago](https://wordpress.org/support/topic/import-spreadsheet-csv-data/#post-4359312)
 * Status: resolved