Before you start
Get ready to move to ClubCore
Gather these before you start and the import takes minutes, not days. Everything here can also be added later.
Academy
Get your academy ready for ClubCore
- Preparing the files
- 2 h
- Setting up in ClubCore
- 50 min
You can stop at any point — your progress is saved.
Start your free trialYour checklist
Ticks are saved on this device.
Common mistakes
- Dates written as text like "12 April 2017" — use 2017-04-12.
- Month first (04/12/2017). We read DD/MM/YYYY, so 04/12 is the 4th of December.
- Two children on one row, or a family on one row. One child per row; siblings repeat the parent's details.
- Parent mobiles without the country code, or two numbers in one cell.
- A team spelt differently in two files ("U10 boys" vs "Under 10 Boys"). Copy the names from the teams file.
- Merged cells, totals rows, colours used as data, or several tables on one sheet. One header row, then data.
- Siblings entered with different parent phone numbers — the sibling discount then does not apply.
Templates
One file per kind of data. Keep the first row exactly as it is — that is how ClubCore recognises the columns. Delete the example rows before uploading. Gold columns are required.
Show columns and rules (8)
| Column | Required? | Rules |
|---|---|---|
namePlan name | Required | Text. Children are linked to a plan by this exact name in the children file. |
name_arPlan name (Arabic) | Optional | Text. |
cadenceBilling cycle | Required | One of the allowed values. MONTHLY bills every month, TERM every three months, ANNUAL once a year.MONTHLY · TERM · ANNUAL |
amountAmount per cycle | Required | Number, digits only (no currency sign). |
currencyCurrency | Optional | Three-letter currency code (QAR, SAR, AED, USD …). Empty = club currency. |
installmentsInstalments per cycle | Optional | Whole number. A term or year can be split into instalments (1 if left empty). |
sibling_discount_pctSibling discount % | Optional | Number, digits only (no currency sign). |
age_groupAge group | Optional | Text. |
Show columns and rules (5)
| Column | Required? | Rules |
|---|---|---|
nameTeam name | Required | Text. Write each name exactly as you will write it in the players and staff files. |
name_arTeam name (Arabic) | Optional | Text. |
age_groupAge group | Optional | Text. |
genderBoys or girls | Optional | One of the allowed values. M for boys / men, F for girls / women; leave empty for mixed.M · F |
league_nameLeague | Optional | Text. |
Coaches & staffNeeded
Coaches and office staff with their roles and the groups they coach.
About 15 min to prepare
Show columns and rules (10)
| Column | Required? | Rules |
|---|---|---|
first_nameFirst name | Required | Text. |
last_nameLast name | Required | Text. |
first_name_arFirst name (Arabic) | Optional | Text. |
last_name_arLast name (Arabic) | Optional | Text. |
roleRole in ClubCore | Required | One of the allowed values. Decides what the person sees. Coaches: HEAD_COACH or ASSISTANT_COACH; office: OPERATIONS; fees: FINANCE.OWNER · GENERAL_MANAGER · SPORTING_DIRECTOR · HEAD_COACH · ASSISTANT_COACH · MEDICAL · PSYCHOLOGIST · SCOUT · FINANCE · HR · OPERATIONS · MEDIA |
emailEmail | Optional | Email address. Needed to send the person a login. One person, one email. |
phoneMobile | Optional | Mobile number with country code, e.g. +974 5555 1234. |
job_titleJob title | Optional | Text. |
teamsTeams they coach | Optional | One or more values separated by ; Team names separated by ; — they must match the teams file. |
hire_dateStart date | Optional | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
Children & parentsNeeded
One row per child: date of birth, group, parent contact, consent and fee plan.
About 60 min to prepare
Show columns and rules (26)
| Column | Required? | Rules |
|---|---|---|
first_nameFirst name | Required | Text. |
last_nameLast name | Required | Text. |
first_name_arFirst name (Arabic) | Optional | Text. |
last_name_arLast name (Arabic) | Optional | Text. |
dobDate of birth | Required | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. Used to group children by age and to find the same person again on a re-import. |
teamTeam | Optional | Text. The team or age group exactly as in the teams file. |
positionPosition | Optional | One of the allowed values. If empty, CM is used until a coach sets it.GK · RB · RWB · CB · LB · LWB · CDM · CM · CAM · RM · LM · RW · LW · CF · ST |
nationalitiesNationalities | Optional | One or more values separated by ; Two-letter country codes separated by ; (QA;EG). |
shirt_numberShirt number | Optional | Whole number. |
preferred_footPreferred foot | Optional | One of the allowed values.LEFT · RIGHT · BOTH |
height_cmHeight (cm) | Optional | Whole number. |
weight_kgWeight (kg) | Optional | Number, digits only (no currency sign). |
joined_dateJoined on | Optional | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
registration_noRegistration number | Optional | Text. |
guardian_nameParent / guardian name | Required for every child under 18 | Text. |
guardian_relationRelationship | Optional | Text. |
guardian_phoneParent / guardian mobile | Required for every child under 18 | Mobile number with country code, e.g. +974 5555 1234. Include the country code (+974 …). Siblings share the same parent row details, so the parent is created once. |
guardian_emailParent / guardian email | Optional | Email address. |
guardian2_nameSecond parent name | Optional | Text. |
guardian2_phoneSecond parent mobile | Optional | Mobile number with country code, e.g. +974 5555 1234. |
guardian2_emailSecond parent email | Optional | Email address. |
consent_signedSigned consent form | Required for every child under 18 | YES or NO. YES when you hold the parent's signed consent form for this child.YES · NO |
fee_planFee plan | Optional | Text. The plan name exactly as in the fee plans file. Leave empty if the child does not pay fees. |
billing_dayBilling day | Optional | Whole number. Day of the month the invoice is raised (1–28). |
fee_start_dateFees start | Optional | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
discount_pctScholarship / discount % | Optional | Number, digits only (no currency sign). |
Prefer we do it?
Send your files to our team and we load them for you; you only review and confirm.
Contact usPro
Get ready to move to ClubCore
- Preparing the files
- 2 h
- Setting up in ClubCore
- 60 min
You can stop at any point — your progress is saved.
Start your free trialYour checklist
Ticks are saved on this device.
Common mistakes
- Dates written as text like "12 April 2017" — use 2017-04-12.
- Month first (04/12/2017). We read DD/MM/YYYY, so 04/12 is the 4th of December.
- A team spelt differently in two files ("U10 boys" vs "Under 10 Boys"). Copy the names from the teams file.
- Contract end dates missing or before the start date.
- Annual salaries in the monthly salary column.
- Merged cells, totals rows, colours used as data, or several tables on one sheet. One header row, then data.
- Medical notes pasted into spreadsheets — leave them out; they go into Medical.
Templates
One file per kind of data. Keep the first row exactly as it is — that is how ClubCore recognises the columns. Delete the example rows before uploading. Gold columns are required.
Show columns and rules (5)
| Column | Required? | Rules |
|---|---|---|
nameTeam name | Required | Text. Write each name exactly as you will write it in the players and staff files. |
name_arTeam name (Arabic) | Optional | Text. |
age_groupAge group | Optional | Text. |
genderBoys or girls | Optional | One of the allowed values. M for boys / men, F for girls / women; leave empty for mixed.M · F |
league_nameLeague | Optional | Text. |
StaffNeeded
Coaches, medical, office — with roles and, for Pro, contracts and document expiries.
About 30 min to prepare
Show columns and rules (16)
| Column | Required? | Rules |
|---|---|---|
first_nameFirst name | Required | Text. |
last_nameLast name | Required | Text. |
first_name_arFirst name (Arabic) | Optional | Text. |
last_name_arLast name (Arabic) | Optional | Text. |
roleRole in ClubCore | Required | One of the allowed values. Decides what the person sees. Coaches: HEAD_COACH or ASSISTANT_COACH; office: OPERATIONS; fees: FINANCE.OWNER · GENERAL_MANAGER · SPORTING_DIRECTOR · HEAD_COACH · ASSISTANT_COACH · MEDICAL · PSYCHOLOGIST · SCOUT · FINANCE · HR · OPERATIONS · MEDIA |
emailEmail | Optional | Email address. Needed to send the person a login. One person, one email. |
phoneMobile | Optional | Mobile number with country code, e.g. +974 5555 1234. |
job_titleJob title | Optional | Text. |
teamsTeams they coach | Optional | One or more values separated by ; Team names separated by ; — they must match the teams file. |
hire_dateStart date | Optional | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
contract_startContract start | Optional | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
contract_endContract end | Optional | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
salary_monthlyMonthly salary | Optional | Number, digits only (no currency sign). Gross monthly salary in the club currency, digits only. |
qid_expiryQID expiry | Optional | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
visa_expiryVisa expiry | Optional | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
passport_expiryPassport expiry | Optional | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
SquadNeeded
Every registered player, their team and (for under-18s) a guardian.
About 30 min to prepare
Show columns and rules (21)
| Column | Required? | Rules |
|---|---|---|
first_nameFirst name | Required | Text. |
last_nameLast name | Required | Text. |
first_name_arFirst name (Arabic) | Optional | Text. |
last_name_arLast name (Arabic) | Optional | Text. |
dobDate of birth | Required | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. Used to group children by age and to find the same person again on a re-import. |
teamTeam | Optional | Text. The team or age group exactly as in the teams file. |
positionPosition | Required | One of the allowed values. If empty, CM is used until a coach sets it.GK · RB · RWB · CB · LB · LWB · CDM · CM · CAM · RM · LM · RW · LW · CF · ST |
nationalitiesNationalities | Optional | One or more values separated by ; Two-letter country codes separated by ; (QA;EG). |
shirt_numberShirt number | Optional | Whole number. |
preferred_footPreferred foot | Optional | One of the allowed values.LEFT · RIGHT · BOTH |
height_cmHeight (cm) | Optional | Whole number. |
weight_kgWeight (kg) | Optional | Number, digits only (no currency sign). |
joined_dateJoined on | Optional | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
registration_noRegistration number | Optional | Text. |
guardian_nameParent / guardian name | Recommended for players under 18 | Text. |
guardian_relationRelationship | Optional | Text. |
guardian_phoneParent / guardian mobile | Recommended for players under 18 | Mobile number with country code, e.g. +974 5555 1234. Include the country code (+974 …). Siblings share the same parent row details, so the parent is created once. |
guardian_emailParent / guardian email | Optional | Email address. |
guardian2_nameSecond parent name | Optional | Text. |
guardian2_phoneSecond parent mobile | Optional | Mobile number with country code, e.g. +974 5555 1234. |
guardian2_emailSecond parent email | Optional | Email address. |
Player contractsRecommended
Dates, wages and bonuses — the basis for payroll and contract alerts.
About 45 min to prepare
Show columns and rules (14)
| Column | Required? | Rules |
|---|---|---|
player_first_namePlayer first name | Required | Text. The player is found by first name, last name and date of birth — exactly as in the squad file. |
player_last_namePlayer last name | Required | Text. |
player_dobPlayer date of birth | Required | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
typeContract type | Required | One of the allowed values.PRO · SCHOLAR · AMATEUR · LOAN |
start_dateStart date | Required | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
end_dateEnd date | Required | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
salary_monthlyMonthly salary | Required | Number, digits only (no currency sign). Monthly, not yearly. |
currencyCurrency | Optional | Three-letter currency code (QAR, SAR, AED, USD …). Empty = club currency. |
signing_bonusSigning bonus | Optional | Number, digits only (no currency sign). |
release_clauseRelease clause | Optional | Number, digits only (no currency sign). |
agent_feeAgent fee | Optional | Number, digits only (no currency sign). |
bonus_appearanceBonus per appearance | Optional | Number, digits only (no currency sign). |
bonus_goalBonus per goal | Optional | Number, digits only (no currency sign). |
bonus_clean_sheetBonus per clean sheet | Optional | Number, digits only (no currency sign). |
Sponsors & commercial dealsOptional
Sponsorship and partner agreements with their value and dates.
About 15 min to prepare
Show columns and rules (7)
| Column | Required? | Rules |
|---|---|---|
sponsorSponsor / partner | Required | Text. |
typeDeal type | Optional | One of the allowed values.BROADCAST · SPONSORSHIP · NAMING_RIGHTS · MERCHANDISE · LICENSING · RETAIL_LEASE · CONCESSION · PRIZE_SCHEME · OTHER |
valueTotal value | Required | Number, digits only (no currency sign). The total value of the whole agreement. |
currencyCurrency | Optional | Three-letter currency code (QAR, SAR, AED, USD …). Empty = club currency. |
start_dateStart date | Required | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
end_dateEnd date | Required | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
descriptionDescription | Optional | Text. |
Finance: opening balance & ledgerOptional
Your cash in the bank on the start date, plus this season's income and costs so far.
About 30 min to prepare
Show columns and rules (8)
| Column | Required? | Rules |
|---|---|---|
dateDate | Required | Date as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted. |
typeIncome or expense | Required | One of the allowed values. OPENING_BALANCE is the cash in the bank on your start date: it counts in your cash position, never as income in reports or the P&L.INCOME · EXPENSE · OPENING_BALANCE |
categoryCategory | Optional | One of the allowed values. Required for INCOME and EXPENSE (income categories for INCOME, expense categories for EXPENSE); leave empty for OPENING_BALANCE.SPONSORSHIP · TRANSFER_FEE · ACADEMY_FEES · MEMBERSHIP · MATCHDAY · GRANT · VENUE_RENTAL · OTHER_INCOME · SALARIES · MEDICAL · EQUIPMENT · TRAVEL · FACILITIES · UTILITIES · INSURANCE · DEPRECIATION · OTHER_EXPENSE · BROADCAST · MERCHANDISE · HOSPITALITY · PRIZE_MONEY · PLAYER_LOAN_FEE · SELL_ON · NAMING_RIGHTS · RETAIL_LEASE · DONATION · AGENT_FEES · TRANSFER_FEE_PAID · AMORTISATION · MARKETING · ADMIN · YOUTH_ACADEMY · MATCHDAY_OPS · TAXES · FINANCE_COSTS · RENT · KIT_SUPPLY · SECURITY · CATERING |
amountAmount | Required | Number, digits only (no currency sign). Positive for INCOME and EXPENSE. For OPENING_BALANCE a negative amount means an overdraft. |
currencyCurrency | Optional | Three-letter currency code (QAR, SAR, AED, USD …). Empty = club currency. |
counterpartyPaid to / received from | Optional | Text. |
referenceReference | Optional | Text. Give each line a unique reference so a re-import never books it twice. |
detailDetail | Optional | Text. |
Prefer we do it?
Send your files to our team and we load them for you; you only review and confirm.
Contact us