How To Export Timesheets from CrewCenter Web

  • Updated

Roles: Admin | Interface: Web

Overview

Exporting timesheets and absence data in CrewCenter Web enables you to transfer approved working time and absences into payroll, ERP and reporting systems. CrewCenter supports both human-readable Excel reports and machine-readable ERP/CSV formats.


Note: Export files may contain personal data. Handle them according to your company’s data protection requirements.

Open the Export Panel

  • Go to the Timesheets page in CrewCenter Web.

  • Select Export in the top-left corner.

Choose an Export Template

The export panel will open and by clicking in the Export templates dropdown you can see the available export templates.

CrewCenter provides several standard export templates:

  • BRZ export template (BRZ File) - if your ERP team imports these formats.

  • Employee time sheets (Excel file) - for payroll-style monthly reports.

  • CrewCenter standard export (Excel file) - for flexible summaries

  • MOS’aik (Moser Software GmbH) - if your ERP team imports these formats.

  • Raw data export (CSV) - for integrations or data analysis. 

  • BRZ of Working hours with Breaks - - if your ERP team imports these formats.

Tip: Use an Excel template for readable reports. Use ERP or raw data exports when importing data into another system.

Important: Selecting a different export template resets all currently applied filters, including the selected time period, employees, and projects. To avoid losing your settings, first choose the export template and then configure all other export options.
 

Employee assignment in export reports

(the same process applies to all templates)


Beneath the export template and time period sections, you can choose which employees to include in your export. Click on All Employees to modify the selection, manually select users or sort by role. To select users based on role, click Sort by: Employee and select the desired role and order in which the users will appear.



In the employee selection screen, you have the following options:

  1. Select / Deselect all


    Following icons apply:

    • When all employees are selected, you'll see a check mark next to Select all:
    • When a partial selection of the employees has been chosen, you'll see a dash next to Select All:
    • When no employees are selected, the box will remain unfilled:
  2. To select specific employees, you can manually check the box next to the user's name.
     


Additionally, you have the possibility to review the selected employees in a separate view. 
 


Sorting options: Sort by employee or by supervisor, in ascending or descending order.

Click Update to save your changes or Cancel if you do not wish to proceed with the selection.
 

 

Project assignment in export reports

Users can apply a Project Filter and enable reports for all projects or specify certain project(s) according to their need. 

 

 

To apply a filter to all projects, toggle the "All projects" option on. 

 

 

If you'd like to select specific projects, toggle off the "All Employees" option and choose the desired projects from the list.

 

Select the Export Time Frame

(the same process applies to all templates)

To define the time frame for your export, open the Export time frame drop‑down menu.
 

 

The following options are available:

  • Last week
  • Custom range
  • Month

Please note: the previous full month is selected by default:

Use a Custom Range

 

When a Custom range is selected, start and end date fields appear, where you can enter the desired dates to generate an export for a specific time period.

Employee timesheets template

Employees: Select one, multiple, or all employees. For Employee timesheets, you can include up to 500 employees in one file.

Time period: Use presets such as last week or last month, or select a custom date range. For future absences, use the custom date selection (no predefined filter).

Time format: Choose the time display. For example, H,MM or H:MM.

Note: No rounding is available for "Employee time sheets".

 

Employee Timesheets – Exported Data (Excel)

When exporting employee timesheets, the resulting Excel file contains the following sections:

1. Employee overview (name of the employee.)
2. Employee details (employee ID, company, overtime at start, changes, and overtime at end.)
3. Report details (timeframe, month and year, and calendar weeks)
4. Report body (date, day, start, end, type, break, planned hours, actual hours, extra hours, and working time)
5. Employee tabs (Each employee selected for the report is exported into a separate tab containing all corresponding information.)
 


 

CrewCenter standard export template

In the CrewCenter standard exports, you can choose to show results for each employee, each project and/or each day. Selecting these options will enable further selection criteria for time types and other data fields.
Multiple groupings are permitted and at least one export field type (eg. Total work time) must be selected. 

 

Available export time types and fields

Show results:

Include Time Types: 

Other data fields:

Rounding: Choose between Round to full hours, round to half hour, no rounding or Round to quarter hour.
This does not alter stored data.
 

 

Tip: Enable time range to show a specific work period.

The top row in the exported Excel sheet will correspond to the selections made in the export menu:
 



Exports in H:MM format with comma separators will display both positive and negative values immediately:


However, exporting in H:MM formats may result in hidden values in Excel:
 


To correct this issue, please follow the instructions in the following article:

How to fix correctly display negative time values in CrewCenter Excel exports

Export for ERP Integration

BRZ export template: 

Use when importing CrewCenter data into the BRZ ERP system. 

Note: Do not modify BRZ files before import.

MOS’aik export: 

Ensure external tenant ID is set and cost centers/project data match MOS’aik requirements. Output is a tab-separated UTF-8 text file with fixed columns.


Raw data export (CSV) template

  • The raw data export produces a ZIP archive including CSVs for work logs, absences, employees, projects, and cost codes/special conditions.

  • Data contains exact unrounded time entries as recorded by users.

The following image shows an Employees.csv 
 


Example of Extended work log.csv
 


An example of Projects.csv

 

 
work log.csv
 

 

Save Export Preferences

CrewCenter remembers your export settings for each template. This includes preferences such as:

  • Time formats
  • Rounding options
  • Selected data fields
  • Other export configuration choices

When you export data again using the same template, the export dialog will automatically load your previous settings. This reduces manual input and speeds up repeated exports.

Note: Each export template stores only one saved preference set per template.

 

Troubleshooting Exports

  • If an export takes a long time, reduce the number of employees or shorten the date range selected.

  • If export fails or does not download, check your internet connection, refresh the page, or try fewer employees or a shorter period.

  • If data is missing, confirm the date range, employee selection, and verify time types and ERP configuration settings.

  • Note: Only CSV files in UTF-8 encoding are supported for import; only ";" is supported as column separator.

 

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request