The Excel import is a fast and easy way for admins to import any existing goals. Admins can find the import function under 'Settings' > 'Module & feature settings' > 'Goals' > 'Bulk import goals'.
To import the goals, copy the sample spreadsheet, and replace the dummy data with your actual goal data while maintaining the given column format exactly. If you change any formatting, none of your data will upload. All columns marked as (*) are required fields.
Each row is one goal and its key results. Each section after the first (past the black line) is where you will fill in Key Results (if there were any). If the goals you're uploading do not have Key Results, please leave everything after the first black line blank.
Provide the following data for each goal:
- The goal title (*)
- A description for the goal
- The goal owner's email address, team name, or company(*)
- Managed by (team/company goals only)
- Contributor email
- Goal tags (only pre-existed tags created on Leapsome will be added)
- Business goal (yes/no)
- Goal Cycles (only pre-existed tags created on Leapsome will be added)
- Whether the goal is visible to all colleagues (yes/no)(*)
- Whether the goal is archived (yes/no)(*)
- The goal's deadline
- Parent goal (business goals only)
- Link to a skill (personal development goals only)
Provide the following data for each key result :
- Title*
- metric*
- start value*
- current value*
- target value for any key results (KR1)*
- Owner email
- Contributor email
- Description
- Weight (%)
- Deadline
* Any field that is marked with an (*) is required in order to be uploaded
* Goals can only be connected to parent goals that already exist in the system, therefore it is the best practice to upload the top-level goals first, then upload child goals that link to the pre-existing parent goals.
Please note: The spreadsheet upload allows a maximum of twelve key results per goal.
Afterward, upload the file under 'Settings' > 'Module & feature settings' > 'Goals' > 'Upload' and review the newly set up goals in the Goal module!
FAQs
1. After importing my goal with a deadline, the year shows a non-existing value, e.g. ‘4547’ - How can I fix this?
Answer: This typically occurs when the field containing the deadline value in the goal import file is formatted as 'date' rather than 'text'. Please re-format and re-upload the file. If the files match exactly it will update the previously created goals.