Connect to Excel

Easy to use for everyone, available for smaller data quantities

No more copy-pasting, but making a direct connection from a report in ClockWise to, for example, Excel.

  • Easy to use
  • Live data connection
  • Easy to implement
  • No need to have a technical background

This is made possible by using webservices light. We call it light because it is easy to implement, but also because it applies to smaller quantities of data.

If you want to import bigger amounts of data into your data warehouse, there's also possibilities of using PowerBI, Qlik or our API.

Connection between a ClockWise report and Excel

  1. Run a report in ClockWise and save your (filter) settings with the key icon.

Now we have a static url or endpoint.

static url
  1. Click on the key icon to go to the saved url and copie it by clicking the csv icon.
  2. Open a data sheet in Excel and go to 'Get data' -> 'web' or 'Data from web'
  3. Paste the url in the pop-up and load the data
  4. The connection is established!
import excel

You can choose refresh to get the live data.
Use this data in other tabs to make the reports you like.
Hours that have just been written will be directly available in your report!