Importing Staff via CSV
SportsPress includes a CSV importer for bulk-creating staff members. Navigate to Tools → Import, then click SportsPress Staff (CSV) and follow the on-screen steps.
File Format
The CSV must contain exactly 6 columns in the following fixed order. Column headers in the file are ignored — only column position matters.
Column | Field | Required |
1 | Name | Yes |
2 | Jobs | No |
3 | Teams | No |
4 | Leagues | No |
5 | Seasons | No |
6 | Nationality | No |
A sample file is available from the importer's greeting screen via the "Click here to download a sample" link.
Field Reference
Name — The staff member's name. Rows without a name value are skipped.
Jobs — One or more job titles (the
sp_roletaxonomy). Separate multiple values with a vertical pipe|. Job terms are created automatically if they do not exist.Teams — One or more team names. Separate multiple teams with
|. Teams that do not exist are created automatically and assigned to the same leagues and seasons as the staff member.Leagues — One or more league names. Separate multiple values with
|. Leagues are created automatically if absent.Seasons — One or more season names. Separate multiple values with
|. Seasons are created automatically if absent.Nationality — A single nationality code. Use the 3-letter country codes documented in the Country Codes reference. The value is stored as
sp_nationalitypost meta.
Import Options
Merge duplicates — Checked by default. When enabled, if an existing published staff record with the same name is found, the importer updates that record instead of creating a new one. Uncheck to always create new records.
Team Assignment Behaviour
The first team listed in the Teams column is set as the staff member's current team (sp_current_team post meta). All listed teams are also stored as sp_team post meta entries.
After Import
When the import completes, a summary shows how many staff members were imported and how many rows were skipped. Click View Staff to go directly to the Staff list screen.