Skip to content
ClubCore

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 trial

Your 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.

Fee plansRecommended

What each plan costs and how often it is billed.

About 10 min to prepare

Show columns and rules (8)
ColumnRequired?Rules
namePlan nameRequiredText. Children are linked to a plan by this exact name in the children file.
name_arPlan name (Arabic)OptionalText.
cadenceBilling cycleRequiredOne of the allowed values. MONTHLY bills every month, TERM every three months, ANNUAL once a year.MONTHLY · TERM · ANNUAL
amountAmount per cycleRequiredNumber, digits only (no currency sign).
currencyCurrencyOptionalThree-letter currency code (QAR, SAR, AED, USD …). Empty = club currency.
installmentsInstalments per cycleOptionalWhole number. A term or year can be split into instalments (1 if left empty).
sibling_discount_pctSibling discount %OptionalNumber, digits only (no currency sign).
age_groupAge groupOptionalText.

Age groupsNeeded

Age groups and training groups for this season.

About 10 min to prepare

Show columns and rules (5)
ColumnRequired?Rules
nameTeam nameRequiredText. Write each name exactly as you will write it in the players and staff files.
name_arTeam name (Arabic)OptionalText.
age_groupAge groupOptionalText.
genderBoys or girlsOptionalOne of the allowed values. M for boys / men, F for girls / women; leave empty for mixed.M · F
league_nameLeagueOptionalText.

Coaches & staffNeeded

Coaches and office staff with their roles and the groups they coach.

About 15 min to prepare

Show columns and rules (10)
ColumnRequired?Rules
first_nameFirst nameRequiredText.
last_nameLast nameRequiredText.
first_name_arFirst name (Arabic)OptionalText.
last_name_arLast name (Arabic)OptionalText.
roleRole in ClubCoreRequiredOne 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
emailEmailOptionalEmail address. Needed to send the person a login. One person, one email.
phoneMobileOptionalMobile number with country code, e.g. +974 5555 1234.
job_titleJob titleOptionalText.
teamsTeams they coachOptionalOne or more values separated by ; Team names separated by ; — they must match the teams file.
hire_dateStart dateOptionalDate 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)
ColumnRequired?Rules
first_nameFirst nameRequiredText.
last_nameLast nameRequiredText.
first_name_arFirst name (Arabic)OptionalText.
last_name_arLast name (Arabic)OptionalText.
dobDate of birthRequiredDate 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.
teamTeamOptionalText. The team or age group exactly as in the teams file.
positionPositionOptionalOne 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
nationalitiesNationalitiesOptionalOne or more values separated by ; Two-letter country codes separated by ; (QA;EG).
shirt_numberShirt numberOptionalWhole number.
preferred_footPreferred footOptionalOne of the allowed values.LEFT · RIGHT · BOTH
height_cmHeight (cm)OptionalWhole number.
weight_kgWeight (kg)OptionalNumber, digits only (no currency sign).
joined_dateJoined onOptionalDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
registration_noRegistration numberOptionalText.
guardian_nameParent / guardian nameRequired for every child under 18Text.
guardian_relationRelationshipOptionalText.
guardian_phoneParent / guardian mobileRequired for every child under 18Mobile 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 emailOptionalEmail address.
guardian2_nameSecond parent nameOptionalText.
guardian2_phoneSecond parent mobileOptionalMobile number with country code, e.g. +974 5555 1234.
guardian2_emailSecond parent emailOptionalEmail address.
consent_signedSigned consent formRequired for every child under 18YES or NO. YES when you hold the parent's signed consent form for this child.YES · NO
fee_planFee planOptionalText. The plan name exactly as in the fee plans file. Leave empty if the child does not pay fees.
billing_dayBilling dayOptionalWhole number. Day of the month the invoice is raised (1–28).
fee_start_dateFees startOptionalDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
discount_pctScholarship / discount %OptionalNumber, 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 us

Pro

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 trial

Your 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.

TeamsNeeded

Your squads for this season.

About 5 min to prepare

Show columns and rules (5)
ColumnRequired?Rules
nameTeam nameRequiredText. Write each name exactly as you will write it in the players and staff files.
name_arTeam name (Arabic)OptionalText.
age_groupAge groupOptionalText.
genderBoys or girlsOptionalOne of the allowed values. M for boys / men, F for girls / women; leave empty for mixed.M · F
league_nameLeagueOptionalText.

StaffNeeded

Coaches, medical, office — with roles and, for Pro, contracts and document expiries.

About 30 min to prepare

Show columns and rules (16)
ColumnRequired?Rules
first_nameFirst nameRequiredText.
last_nameLast nameRequiredText.
first_name_arFirst name (Arabic)OptionalText.
last_name_arLast name (Arabic)OptionalText.
roleRole in ClubCoreRequiredOne 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
emailEmailOptionalEmail address. Needed to send the person a login. One person, one email.
phoneMobileOptionalMobile number with country code, e.g. +974 5555 1234.
job_titleJob titleOptionalText.
teamsTeams they coachOptionalOne or more values separated by ; Team names separated by ; — they must match the teams file.
hire_dateStart dateOptionalDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
contract_startContract startOptionalDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
contract_endContract endOptionalDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
salary_monthlyMonthly salaryOptionalNumber, digits only (no currency sign). Gross monthly salary in the club currency, digits only.
qid_expiryQID expiryOptionalDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
visa_expiryVisa expiryOptionalDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
passport_expiryPassport expiryOptionalDate 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)
ColumnRequired?Rules
first_nameFirst nameRequiredText.
last_nameLast nameRequiredText.
first_name_arFirst name (Arabic)OptionalText.
last_name_arLast name (Arabic)OptionalText.
dobDate of birthRequiredDate 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.
teamTeamOptionalText. The team or age group exactly as in the teams file.
positionPositionRequiredOne 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
nationalitiesNationalitiesOptionalOne or more values separated by ; Two-letter country codes separated by ; (QA;EG).
shirt_numberShirt numberOptionalWhole number.
preferred_footPreferred footOptionalOne of the allowed values.LEFT · RIGHT · BOTH
height_cmHeight (cm)OptionalWhole number.
weight_kgWeight (kg)OptionalNumber, digits only (no currency sign).
joined_dateJoined onOptionalDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
registration_noRegistration numberOptionalText.
guardian_nameParent / guardian nameRecommended for players under 18Text.
guardian_relationRelationshipOptionalText.
guardian_phoneParent / guardian mobileRecommended for players under 18Mobile 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 emailOptionalEmail address.
guardian2_nameSecond parent nameOptionalText.
guardian2_phoneSecond parent mobileOptionalMobile number with country code, e.g. +974 5555 1234.
guardian2_emailSecond parent emailOptionalEmail address.

Player contractsRecommended

Dates, wages and bonuses — the basis for payroll and contract alerts.

About 45 min to prepare

Show columns and rules (14)
ColumnRequired?Rules
player_first_namePlayer first nameRequiredText. The player is found by first name, last name and date of birth — exactly as in the squad file.
player_last_namePlayer last nameRequiredText.
player_dobPlayer date of birthRequiredDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
typeContract typeRequiredOne of the allowed values.PRO · SCHOLAR · AMATEUR · LOAN
start_dateStart dateRequiredDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
end_dateEnd dateRequiredDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
salary_monthlyMonthly salaryRequiredNumber, digits only (no currency sign). Monthly, not yearly.
currencyCurrencyOptionalThree-letter currency code (QAR, SAR, AED, USD …). Empty = club currency.
signing_bonusSigning bonusOptionalNumber, digits only (no currency sign).
release_clauseRelease clauseOptionalNumber, digits only (no currency sign).
agent_feeAgent feeOptionalNumber, digits only (no currency sign).
bonus_appearanceBonus per appearanceOptionalNumber, digits only (no currency sign).
bonus_goalBonus per goalOptionalNumber, digits only (no currency sign).
bonus_clean_sheetBonus per clean sheetOptionalNumber, 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)
ColumnRequired?Rules
sponsorSponsor / partnerRequiredText.
typeDeal typeOptionalOne of the allowed values.BROADCAST · SPONSORSHIP · NAMING_RIGHTS · MERCHANDISE · LICENSING · RETAIL_LEASE · CONCESSION · PRIZE_SCHEME · OTHER
valueTotal valueRequiredNumber, digits only (no currency sign). The total value of the whole agreement.
currencyCurrencyOptionalThree-letter currency code (QAR, SAR, AED, USD …). Empty = club currency.
start_dateStart dateRequiredDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
end_dateEnd dateRequiredDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
descriptionDescriptionOptionalText.

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)
ColumnRequired?Rules
dateDateRequiredDate as YYYY-MM-DD (2017-04-12). DD/MM/YYYY is also accepted.
typeIncome or expenseRequiredOne 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
categoryCategoryOptionalOne 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
amountAmountRequiredNumber, digits only (no currency sign). Positive for INCOME and EXPENSE. For OPENING_BALANCE a negative amount means an overdraft.
currencyCurrencyOptionalThree-letter currency code (QAR, SAR, AED, USD …). Empty = club currency.
counterpartyPaid to / received fromOptionalText.
referenceReferenceOptionalText. Give each line a unique reference so a re-import never books it twice.
detailDetailOptionalText.

Prefer we do it?

Send your files to our team and we load them for you; you only review and confirm.

Contact us
Book a demo