How frequently can I sync data from Clockify to Excel Online?

Flatly allows you to set custom sync frequencies ranging from every 10 minutes to once daily, depending on your Flatly pricing plan.

Does Flatly modify my Clockify data during the sync?

No. Flatly provides a strict one-way sync. It extracts your historical and dynamic data from Clockify and securely loads it into Excel Online without altering your original source data.

Do I need to write code to connect Clockify to Excel Online?

No code is required. Flatly is a turnkey, no-code integration platform designed for non-technical users to securely connect their data sources and destinations in minutes.

Projects Cloud Drives

Sync Clockify to Excel Online

Automatically sync your Clockify data into Excel Online with Flatly's no-code, triggerless, turnkey integration service.

Historical & Dynamic Data

One-way Sync

For Non-technical Users

Connect Clockify to Excel Online Which Clockify API does Flatly use?

Source: Clockify

Clockify is a simple time tracker and timesheet app that lets you and your team track work hours across projects.

Auth: Basic Authentication

Available datasets

CustomFields
Projects-All
Projects+Tasks-All Combo
Tags-All
Tasks-All by Project
Tasks-Active by Project
Users+TimeEntries AllTime Combo
Users+TimeEntries Last X days Combo Date-ranged

Destination: Excel Online

PowerBI reads CSV or XLSX files directly from OneDrive for Business.

Auth: OAuth

Supported file formats

XLSX (Parsed)
XLSX (Raw)
CSV (Parsed)
CSV (Raw)
NDJSON
Markdown (Table)
Markdown (Key-Value)

How it works

1
Connect Clockify

Authenticate Clockify (Basic Authentication) and Excel Online (OAuth) in the Flatly dashboard. You only have to do this once.
2
Choose your datasets

Pick which Clockify datasets to sync and set your sync frequency. The frequencies available to you depend on your Flatly plan.
3
Data lands in Excel Online

Flatly uploads your Clockify data to Excel Online automatically and refreshes it based on your sync frequency.

What Clockify Users + TimeEntries look like in Excel Online

Flatly writes a header row to Excel Online, then one row per record. Nested Clockify fields are flattened into their own columns, so the Users+TimeEntries AllTime dataset arrives as 64 columns.

Clockify Users+TimeEntries AllTime

Sample Clockify Users+TimeEntries AllTime rows in Excel Online, showing 8 of 64 columns
	A	B	C	D	E	F	G	H
1	activeWorkspace	email	id	name	settings_dateFormat	status	time_entries_costRate_amount	time_entries_costRate_currency
2	64a687e29ae1f428e7ebe303	johndoe@example.com	5a0ab5acb07987125438b60f	John Doe	MM/DD/YYYY	ACTIVE	10500	USD
3	64a687e29ae1f428e7ebe303	johndoe@example.com	5a0ab5acb07987125438b60f	John Doe	MM/DD/YYYY	ACTIVE	21000	USD
4	64a687e29ae1f428e7ebe303	priya.patel@example.com	5a0ab5acb07987125438b61f	Priya Patel	MM/DD/YYYY	ACTIVE	10500	USD
5	64a687e29ae1f428e7ebe303	priya.patel@example.com	5a0ab5acb07987125438b61f	Priya Patel	MM/DD/YYYY	ACTIVE	21000	USD
6	64a687e29ae1f428e7ebe303	marcus.okafor@example.com	5a0ab5acb07987125438b62f	Marcus Okafor	MM/DD/YYYY	ACTIVE	10500	USD
7	64a687e29ae1f428e7ebe303	marcus.okafor@example.com	5a0ab5acb07987125438b62f	Marcus Okafor	MM/DD/YYYY	ACTIVE	21000	USD

Users + TimeEntries

Example data. Showing 8 of 64 columns.

All 64 Clockify Users+TimeEntries AllTime columns

activeWorkspace
defaultWorkspace
email
id
name
profilePicture
settings_alerts
settings_approval
settings_collapseAllProjectLists
settings_dashboardPinToTop
settings_dashboardSelection
settings_dashboardViewType
settings_dateFormat
settings_groupSimilarEntriesDisabled
settings_invoiceReminders
settings_isCompactViewOn
settings_lang
settings_longRunning
settings_multiFactorEnabled
settings_myStartOfDay
settings_onboarding
settings_projectListCollapse
settings_projectPickerTaskFilter
settings_pto
settings_reminders
settings_scheduledReports
settings_scheduling
settings_sendNewsletter
settings_showOnlyWorkingDays
settings_summaryReportSettings_group
settings_summaryReportSettings_subgroup
settings_theme
settings_timeFormat
settings_timeTrackingManual
settings_timeZone
settings_weekStart
settings_weeklyUpdates
status
time_entries_billable
time_entries_costRate_amount
time_entries_costRate_currency
time_entries_customFieldValues_1_customFieldId
time_entries_customFieldValues_1_name
time_entries_customFieldValues_1_timeEntryId
time_entries_customFieldValues_1_type
time_entries_customFieldValues_1_value
time_entries_description
time_entries_hourlyRate_amount
time_entries_hourlyRate_currency
time_entries_id
time_entries_isLocked
time_entries_kioskId
time_entries_projectId
time_entries_tagIds
time_entries_taskId
time_entries_timeInterval_duration
time_entries_timeInterval_end
time_entries_timeInterval_start
time_entries_timeInterval_timeZone
time_entries_timeInterval_zonedEnd
time_entries_timeInterval_zonedStart
time_entries_type
time_entries_userId
time_entries_workspaceId

FAQ: Clockify to Excel Online

How frequently can I sync data from Clockify to Excel Online?: Flatly allows you to set custom sync frequencies ranging from every 10 minutes to once daily, depending on your Flatly pricing plan.
Does Flatly modify my Clockify data during the sync?: No. Flatly provides a strict one-way sync. It extracts your historical and dynamic data from Clockify and securely loads it into Excel Online without altering your original source data.
Do I need to write code to connect Clockify to Excel Online?: No code is required. Flatly is a turnkey, no-code integration platform designed for non-technical users to securely connect their data sources and destinations in minutes.

“The interface is unbelievable. Flatly is so easy to use. After years of struggling with Zapier this is life changing.”

Melissa Cable

Project Manager, Aeolidia

Full data refresh

Maintain up-to-date flat files when any nested or bundled data changes in your source app.

Connection Management

Manage multiple tenants, with connection health monitoring.

Bulk Job Management

Control multiple jobs at the same time, with live progress monitoring.

Merged datasets

Export left-joined combo objects like deals+products.

Write options

Refresh one flat file or create a stack of timestamped versions.

Filterability

Include only the columns or views essential for your reporting.

Notifications

Get alerts about your syncs via email, webhooks or Slack notifications.

Logging

Access up to one thousand log entries for your sync operations.

Custom Field Enrichment

Get useful values in your data instead of identifiers or definitions.

Metadata Attachment

See file statistics alongside your flat files to keep track of their origins.

Dark UI Mode

Reduce eye strain and save energy by using our built in dark mode.

Programmatic Jobs

Queue jobs by making API calls or agent requests.

Time Stamp Enrichment

Get human-readable dates and times from UNIX timestamps.

High frequency

10-minute refresh cycles mean your data store is near real-time.

High capacity

Reliably flatten billions of cells to CSV files without hiccups.

Advanced Security

Two-factor authentication and Destination Lock controls.

Stripe-powered Billing

Reliable payments provider with automatic, familiar invoicing and 1% of Sales to Stripe Climate.

Mobile access

Manage your sync operations from your phone if you are traveling.

Connect Clockify to Excel Online

Get started today with a 14-day free trial. No credit card required. Both human and AI support are available.

Get started Compare pricing