Import Data
Bring your time tracking data from other tools into TeeckIn.
Overview
Switching from another time tracker? TeeckIn can import your existing data so you don't lose your tracking history. We support direct imports from popular tools, a generic CSV format, and full restoration from TeeckIn exports.
Supported Formats
Toggl Track
Direct import from Toggl exports. Categories map to projects, entries preserve all metadata.
Clockify
Import Clockify detailed reports. Projects become topics, tags are preserved.
Harvest
Import Harvest time entries. Clients, projects, and tasks are mapped automatically.
Generic CSV
Import from any tool using our standard CSV format. Map columns during import.
TeeckIn Export (v3)
Restore from a previous TeeckIn export. Perfect for backups or migrating between accounts.
Importing from Toggl
- 1In Toggl: Go to Reports then Detailed
- 2Select the date range you want to export
- 3Click Export and choose CSV
- 4In TeeckIn: Go to Account Settings then Data
- 5Click Import Data
- 6Select Toggl Track as the source
- 7Upload the CSV file
- 8Review the preview and mapping
- 9Click Import
Note
Importing from Clockify
- 1In Clockify: Go to Reports then Detailed
- 2Set your date range and any filters
- 3Click Export and choose CSV
- 4In TeeckIn: Go to Account Settings then Data
- 5Click Import Data
- 6Select Clockify as the source
- 7Upload the CSV file
- 8Review the mapping and adjust if needed
- 9Click Import
Generic CSV Import
For tools without direct support, use a CSV with these columns:
| Column | Required | Format |
|---|---|---|
| date | Yes | YYYY-MM-DD |
| start_time | Yes* | HH:MM or HH:MM:SS |
| end_time | Yes* | HH:MM or HH:MM:SS |
| duration | Yes* | HH:MM:SS or minutes |
| project | No | Text (becomes topic) |
| category | No | Text |
| description | No | Text (becomes notes) |
| tags | No | Comma-separated |
| hourly_rate | No | Number |
| billable | No | true/false or yes/no |
* Provide either start_time + end_time OR duration
Tip
Restoring from TeeckIn Export
You can restore your data from a TeeckIn v3 export. This is useful for:
- Restoring from a backup after data loss
- Migrating data to a new TeeckIn account
- Moving between self-hosted and cloud versions
- 1Go to Account Settings then Data
- 2Click Import Data
- 3Select TeeckIn Export as the source
- 4Upload your JSON export file
- 5Confirm by entering your password
- 6Wait while the import completes
Warning
What Gets Restored
- Your account settings and preferences
- All personal workspace data (categories, topics, time entries)
- Clients, invoices, and transactions
- Tags and accounting labels
- Recurring entries and time goals
- Gamification progress (streaks, XP, achievements)
- Organizations you own (with all their data)
What Must Be Reconfigured
Warning
- SMTP email settings — Your email configuration must be re-entered after import
- Agent credentials — OAuth secrets must be regenerated; only agent metadata (names, types) is preserved
- Attachment files — Only metadata is restored; the actual files cannot be recovered
- Two-factor authentication — Must be set up fresh for security
Note
Column Mapping
When importing, the wizard shows a mapping screen:
You can change mappings, skip columns, or set default values for missing data.
Import Preview
Before importing, you'll see a preview showing:
- Number of entries to import
- Date range of the data
- Categories and topics that will be created
- Any warnings about duplicate or invalid entries
Warning
Handling Duplicates
TeeckIn checks for potential duplicates during import:
Skip Duplicates
Entries with the same date, start time, and topic are skipped.
Import Anyway
Import all entries even if they might be duplicates.
Review Each
Show potential duplicates and let you decide for each one.
After Import
Once the import completes:
- 1Check the import summary for any skipped entries
- 2Go to the Calendar to verify entries appear correctly
- 3Review the new categories and topics in Settings
- 4Set hourly rates on topics if not imported
- 5Delete any unwanted imported entries if needed
Note
Troubleshooting
Import fails with 'Invalid date format'
Ensure dates use YYYY-MM-DD format. Convert in Excel/Sheets before importing.
Times are off by several hours
Check timezone settings. TeeckIn uses your account timezone for imports.
Some entries are missing
Check the import summary for skipped entries. Common reasons: duplicate detection, missing required fields.
Categories/topics not created correctly
Review the column mapping. Make sure project/category columns are mapped correctly.
TeeckIn import fails with 'Invalid format'
Make sure you're using a v3.0.0 export. Older exports use a different format and cannot be imported directly.
SMTP/email not working after restore
SMTP credentials are not included in exports for security. Re-enter your email settings in Account Settings.