---
title: Importing call data manually
description: Can't your telephony be connected? Then import the number of calls per hour yourself for your forecast and staffing template.
---

[Skip to content](https://kennisbank.teamlead.io/en/importing-call-data-manually#main-content)

- [English](https://kennisbank.teamlead.io/en/importing-call-data-manually)
- [Nederlands](https://kennisbank.teamlead.io/nl/gespreksdata-handmatig-importeren)

English

Show submenu for translations

![Teamlead](https://kennisbank.teamlead.io/hs-fs/hubfs/main-logo-horizontal-png-dark.png?width=176&height=32&name=main-logo-horizontal-png-dark.png)

Open main navigation

Close main navigation

- - [English](https://kennisbank.teamlead.io/en/importing-call-data-manually)
    - [Nederlands](https://kennisbank.teamlead.io/nl/gespreksdata-handmatig-importeren)

  English
  
  Show submenu for translations
- [Tickets](https://servicedesk.teamlead.nl/tickets)

[Tickets](https://servicedesk.teamlead.nl/tickets?hsLang=en)

 Hi. How can we help you?

- There are no suggestions because the search field is empty.

1. [Teamlead Knowledge Base](https://kennisbank.teamlead.io/en?hsLang=en)
2. [Connections](https://kennisbank.teamlead.io/en/connections?hsLang=en)

# Importing call data manually

## Can't your telephony be connected? Then import the number of calls per hour yourself for your forecast and staffing template.

Not every contact centre system can be connected directly yet. With the Call data import, you upload your call history in an Excel file, and Teamlead uses it to calculate the required staffing.

### How to do it

1. Go to **Settings** \> **Connections** and click **Call data import**.
2. In the **Queues** table, use **New queue** to create a queue for each call flow, for example Customer service or Outages.
3. Click **Import** next to the queue.
4. Click **Download example file**.
5. Fill in the number of calls per hour from your contact centre system. Keep the layout of the file the same.
6. Choose the file under **File** and click **Next**.
7. Check the **Period**, the **Number of calls** and the **Hours filled in**. If everything is correct, click **Import**.
8. Link the queue to a skill in a staffing template. The **Go to staffing templates** button takes you there.

### What the file looks like

- One tab per year, with the year as its name.
- Column A is called "Weeknummer". It is followed by one column per week (1 to 52 or 53).
- A header row for each weekday, with a row below it for each hour within the opening hours of your location.
- In each cell, fill in the number of calls in that hour. Only numbers greater than 0 count.

### Good to know

- An import is a snapshot: it does not update itself. If you want to include recent weeks, import a new export.
- If you import again for the same period, Teamlead replaces the earlier call data for that period.
- **Use call data import** lets you decide whether the imported data counts in forecasts and staffing templates.
- You adjust the target values for each queue yourself, such as **After-call work time**, **Service level** and **Speed of answer**.
- About a year of data is a good basis.
- Have the opening hours of your location changed? Then download a new example file.
- Does phone no longer count towards staffing from a certain week? Then your imported data has run out. Import new data.

### Not working?

- **Could not process the call data file**: the layout of the file has changed. Check that the tab name is the year, that the week numbers and hours are correct and that the day names have not been translated. Do not leave any cells empty; enter 0 if there were no calls.
- **Could not load Excel file**: use an .xlsx file, preferably the example file.

### See also

- [Overview: which connections are available?](https://kennisbank.teamlead.io/en/overview-which-connections-are-available?hsLang=en)
- [Setting up staffing templates](https://kennisbank.teamlead.io/en/setting-up-staffing-templates?hsLang=en)
- [Forecast: required staffing from telephony data](https://kennisbank.teamlead.io/en/forecast-required-staffing-from-telephony-data?hsLang=en)
- [Phone no longer counts towards staffing](https://kennisbank.teamlead.io/en/phone-no-longer-counts-towards-staffing?hsLang=en)

- [Get started](https://kennisbank.teamlead.io/en/get-started?hsLang=en)
- [For employees](https://kennisbank.teamlead.io/en/for-employees?hsLang=en)
- [For planners and team leads](https://kennisbank.teamlead.io/en/for-planners-and-team-leads?hsLang=en#main-content)

    - [Schedule](https://kennisbank.teamlead.io/en/for-planners-and-team-leads?hsLang=en#schedule)
    - [Shift templates and automatic scheduling](https://kennisbank.teamlead.io/en/for-planners-and-team-leads?hsLang=en#shift-templates-and-automatic-scheduling)
    - [Leave](https://kennisbank.teamlead.io/en/for-planners-and-team-leads?hsLang=en#leave)
    - [Staffing and forecast](https://kennisbank.teamlead.io/en/for-planners-and-team-leads?hsLang=en#staffing-and-forecast)
    - [Adherence and statistics](https://kennisbank.teamlead.io/en/for-planners-and-team-leads?hsLang=en#adherence-and-statistics)
- [For administrators](https://kennisbank.teamlead.io/en/for-administrators?hsLang=en)
- [Connections](https://kennisbank.teamlead.io/en/connections?hsLang=en)
- [Frequently asked questions](https://kennisbank.teamlead.io/en/frequently-asked-questions?hsLang=en)

[![](https://kennisbank.teamlead.io/hs-fs/hubfs/Teamlead-logo.png?width=500&height=105&name=Teamlead-logo.png)](http://teamlead.io)

[Website](https://teamlead.io)[Create a ticket](https://servicedesk.teamlead.nl/tickets?hsLang=en)© 2026 Teamlead