Employee Goals β Export to Excel and CSV
Managers can export the Employee Goals grid to an Excel or CSV file directly from the Employee Goals page. The export reflects whatever filters and selections are currently applied, so the downloaded file contains only the data visible in the grid at the time of export.
Audience: Managers and administrators who review employee performance targets and need to share or analyze goal data outside Zenoti.
On this page
Before you begin
- Employee targets must be enabled for your organization. An administrator can turn this on at Configuration > Employee > Essentials by enabling Enable employee targets.
- You must have the Manage check box enabled under the Employee Targets row in the Employee Manager section of your security role (Configuration > Security > Security roles > the role > Permissions).
Permission: Manage (under Employee Targets) β Required to access the Employee Goals page and use the export action. Grant it on the Employee Targets row in the Employee Manager section of the security role (Configuration > Security > Security roles > the role > Permissions).
- Before exporting, apply any filters you want reflected in the file. The export captures the current state of the grid, including the active view and date range.
Steps
Export the Employee Goals grid
- Navigate to Data & insights > Employee targets.
- Apply any filters β such as view, date range, or employee selection β that you want the exported file to reflect.
- Select export from the page toolbar.
- Choose the file format:
- Excel (.xlsx) β Downloads an Excel workbook.
- CSV β Downloads a comma-separated values file.
- Save the file when your browser prompts you.
Note: The export button label in the UI is export (lowercase). It does not open a separate configuration dialog β clicking it and selecting a format begins the download immediately.
Understanding the exported file
The exported file contains the same rows and columns shown in the grid at the time of export, with contextual header information prepended before the data.
Excel (.xlsx) file structure
The Excel file includes a report header before the data rows:
| Row | Content |
|---|---|
| 1 | Organization name (bold, large font) |
| 2 | Center name, prefixed with Center: (bold, medium font) |
| 3 | Details line β report title ("Employee Goals"), current view, date range (From: β¦ / To: β¦), exporting user (By: β¦), and export timestamp (Report Exported On: β¦), all on one row |
| 4 | Blank spacer row |
| 5 onward | Column headers, then data rows |
Worked example: If your organization is "Glow Wellness," your center is "Downtown," you are logged in as Alex Rivera, and you export on July 14, 2025 with a date range of July 1β14, the top of the Excel file reads:
- Row 1: Glow Wellness
- Row 2: Center: Downtown
- Row 3: Employee Goals | (current view) | From: 07/01/2025 | To: 07/14/2025 | By: Alex Rivera | Report Exported On: 07/14/2025
CSV file structure
The CSV file contains the same contextual header lines as the Excel file β organization name, center name, and the details line β prepended before the column headers and data rows. Each header cell value is enclosed in double quotes. Any value that begins with =, +, -, or @ is prefixed with a single quote to prevent formula injection in spreadsheet applications.
Note: The system temporarily swaps in export-specific column definitions (with the Actual/Target column shape required for the file) during the export process and restores the original live column definitions when the download is complete. This happens automatically, whether the export succeeds or fails, and requires no action from you.
Tips
- Filter before you export. The export reflects the current grid state. Set your view scope, date range, and any employee selection before clicking export so the file contains exactly the data you need.
- Use Excel format for formatted sharing. The Excel file includes bold organization and center names in the header, making it easier to share with stakeholders as a standalone report.
- Use CSV format for data processing. CSV files are easier to import into third-party analytics or payroll tools. The safety prefixes on formula-starting characters (such as a value beginning with
=) prevent accidental formula execution in other spreadsheet applications. - Check the date range before downloading. The details line in both formats records the date range active at export time. Confirm the From and To fields reflect the period you intend to report on before selecting export.
Troubleshooting
| Symptom | Likely cause | Resolution |
|---|---|---|
| The export button is not visible on the Employee Goals page | Your security role does not have the Manage check box enabled under Employee Targets | Ask your administrator to grant the Manage permission on the Employee Targets row in your security role. See Before you begin for the exact path. |
| The Employee Goals page is not accessible from Data & insights | Enable employee targets is turned off for your organization | Ask your administrator to enable Enable employee targets at Configuration > Employee > Essentials. |
| The exported file contains fewer rows than expected | Filters were active at the time of export | Return to the Employee Goals page, clear or adjust the filters to include all intended records, and export again. |