How to Export CSV Data from Clockify and Import It into clariBI

Clockify is a popular free time tracking tool used by teams to log hours across projects and clients. Exporting your Clockify data into clariBI lets you analyze productivity trends, project profitability, and team utilization with AI-powered insights.

What You Can Export from Clockify

• Time entries with start/end times and durations
• Project and task assignments
• Client associations for each entry
• Team member names and hourly rates
• Tags and descriptions on time entries
• Billable vs. non-billable hour breakdowns
• Approval status of timesheets

Export CSV Data from Clockify

1. Log in to your Clockify account at app.clockify.me
2. Click Reports in the left sidebar
3. Select the report type you want: Detailed, Summary, or Weekly
4. Use the date range picker at the top to select the period you want to export
5. Apply any filters you need — filter by Project, Client, Team Member, Tag, or Billable status using the filter bar
6. Once your report displays the data you want, click the Export button (download icon) in the top-right corner
7. Select CSV as the export format
8. The file will download to your computer automatically

Alternative: Detailed Report Export

1. Go to Reports > Detailed
2. This gives you the most granular data with every individual time entry
3. Click Export > CSV to download all entries matching your filters

Tips for Clean Exports

• Use the Detailed report for the most complete data — it includes every individual time entry with full metadata
• Apply date range and project filters before exporting to keep your file focused and manageable
• If you track billable hours, filter by billable status to create separate reports for billable vs. non-billable analysis

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Clockify - Time Entries Q1 2025")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "Which projects consumed the most billable hours last month?"
- "Show me each team member's average daily hours over the past quarter"
- "What percentage of our total tracked time is billable vs. non-billable?"

clariBI's AI will automatically analyze your data and suggest relevant insights.