Importing working hours from a CSV file beta
Goodtime can import working hours from a CSV file. CSV is a file format
used, for example, for exporting data from Excel spreadsheets.
The CVS file for import must have at least two columns with the start and end time entries. More than two columns with mixed date and time information are also possible. All columns with dates or times can be freely assigned to the start or end time during upload. Dates and times can, for example, have the following format:
- yyyy-MM-dd'T'HH:mm:ss 2024-12-03T10:15:30
- yyyy-MMM-d H:m:s 2024-12-03 10:15:30
- yyyy-MM-dd 2024-12-03
- hh:mm:s 10:15:30
Delimiter
A delimiter separates the individual CSV data fields within a row. In most cases, the import process automatically detects the delimiter, and the Automatic preset is almost always the right choice. CSV files often follow Excel conventions; in that case, the Excel Standard setting works well. Alternatively, the delimiter used in the CSV file can be specified explicitly Enter Explicitly.
Time Types and Projects
The import data is automatically checked for time types and project names. If matching time types or projects are found in the time tracking data, the system will automatically suggest their assignment during the CSV column mapping process.
Example File
A minimal file containing data for importing three time entries:
CSV import
template
Upload CSV Data for Multiple Employees at Once
Working hours for multiple employees can be imported simultaneously. To do this, simply save the CSV files in a single ZIP file. The filename of each individual CSV file must contain either the user's login email address or their employee number so that each CSV file can be uniquely assigned to an employee.
All files contained in the ZIP archive must have the same format. For example, the number and type of columns must therefore be the same in all CSV files.
Back to Overview