Title: Importing CSV
Last modified: August 21, 2016

---

# Importing CSV

 *  [HockeyRiveNord](https://wordpress.org/support/users/hockeyrivenord/)
 * (@hockeyrivenord)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/importing-csv/)
 * Hi there,
 * New to WP and SportsPress, and I have a hard time figuring out how to import 
   CSV files to facilitate my creation of events and players.
 * Please advise;
 * [https://wordpress.org/plugins/sportspress/](https://wordpress.org/plugins/sportspress/)

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

 *  Plugin Author [ThemeBoy](https://wordpress.org/support/users/themeboy/)
 * (@themeboy)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/importing-csv/#post-5042568)
 * Hi [@hockeyrivenord](https://wordpress.org/support/users/hockeyrivenord/),
 * We’re working on a bit of documentation around this, but here is an outline of
   how to use the csv importer:
 * 1. Download the sample CSV file via Tools > Import > SportsPress Events (CSV)
   > “Click here to download a sample.”
 * 2. Open the CSV file in your favorite spreadsheet program. We recommend Google
   Drive because it ensures proper line endings and encoding.
 * 3. If you’re not using the default soccer preset, change the column names after
   the “Player” column to reflect the performance values used on your site. To find
   a list of performance values, go to SportsPress > Settings > Configure > Performance.
 * 4. The date field can be tricky. SportsPress requires the date format:
 *     ```
       yyyy/mm/dd
       ```
   
 * You can change the date format in most spreadsheet programs including Excel and
   Google Drive.
 * 5. Save (as UTF-8) and upload.
 * I hope this helps! I’ll let you know when the official documentation becomes 
   available.
 *  [lstephan](https://wordpress.org/support/users/lstephan/)
 * (@lstephan)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/importing-csv/#post-5042700)
 * Hi,
 * I have some pb too with importing events.
 * L Stephan
 *  [lstephan](https://wordpress.org/support/users/lstephan/)
 * (@lstephan)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/importing-csv/#post-5042763)
 * So i followed the procedure to import events from Google Drive but only one event
   is imported instead of the 2 events in spreadsheet…
 * If someone succeeded in importing events?
 * Thanks a lot
 *  Plugin Author [ThemeBoy](https://wordpress.org/support/users/themeboy/)
 * (@themeboy)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/importing-csv/#post-5042775)
 * Hi [@lstephan](https://wordpress.org/support/users/lstephan/),
 * I’d like to have a look at the imported file. Could you open the CSV file (using
   notepad or similar) and paste it in below?
 *  [lstephan](https://wordpress.org/support/users/lstephan/)
 * (@lstephan)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/importing-csv/#post-5042779)
 * Hi,
 * Here my csv file open from notepad (fromm google drive):
 * 2015-12-10,,Stade Francis Le Blé,Stade Brestois 29
    ,,,combrit 2015-12-10,,Stade
   Francis Le Blé,Stade Brestois 29 ,,,quimper
 * Thanks a lot.
 *  Plugin Author [ThemeBoy](https://wordpress.org/support/users/themeboy/)
 * (@themeboy)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/importing-csv/#post-5042795)
 * Hi again!
 * Just wondering, does the csv file have a header row, or is it just those 2 rows?
 * If it’s just the 2 rows, you’ll need to insert a header row (since the first 
   row gets discarded during import). The header row should be something like this:
 *     ```
       Date,Time,Venue,Teams,Results,Outcome,Players,Goals,Assists,Yellow Cards,Red Cards
       ```
   
 * Let me know if this was the issue.
 *  [lstephan](https://wordpress.org/support/users/lstephan/)
 * (@lstephan)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/importing-csv/#post-5042812)
 * Oh thanks i will try with first row.
 * Regards
    L Stephan

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

The topic ‘Importing CSV’ is closed to new replies.

 * ![](https://ps.w.org/sportspress/assets/icon-256x256.png?rev=1252005)
 * [SportsPress - Sports Club & League Manager](https://wordpress.org/plugins/sportspress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/sportspress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/sportspress/)
 * [Active Topics](https://wordpress.org/support/plugin/sportspress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/sportspress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/sportspress/reviews/)

 * 7 replies
 * 3 participants
 * Last reply from: [lstephan](https://wordpress.org/support/users/lstephan/)
 * Last activity: [11 years, 10 months ago](https://wordpress.org/support/topic/importing-csv/#post-5042812)
 * Status: not resolved