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
Back to Overview