Qlik Automate: Copy data to Microsoft excel sheets using automations (small datasets)

AfeefaTk — Thu, 15 Jan 2026 14:38:56 GMT

This article describes the templates available in Qlik Automate which allow you to synchronize data from a Qlik Sense straight table to Microsoft Excel.

We have two templates currently available

Copy and update data from a Qlik Sense straight table to an Excel sheet (for more info check Copy and update data to Microsoft Excel sheet using automations (small datasets))
Copy data from a Qlik Sense straight table to an Excel sheet

Let's discuss the automation configured in Qlik Automate to copy data from the Qlik Sense straight table to Microsoft Excel.

Similar to the 'Copy and update data from a Qlik Sense straight table to an Excel sheet' template, we'll use a Qlik Sense straight table as the source data set.

The main difference between these two templates is that in the 'Copy data from a Qlik Sense straight table to an Excel sheet' template we don't sync data to an already existing Microsoft Excel worksheet or table, instead, we will create a new worksheet and table within this worksheet with the required headers. For this template to work, you need to have an empty Excel file created beforehand.

Full automation

Step-by-step description

Start your automation with the Create Workbook Session block from the Microsoft Excel connector.
Configure it with the following settings:
1. Drive id -> use do lookup
2. Item id -> use do lookup to find the empty destination file, if you don't know the path of your file, you can do an empty search (if it isn't located in a folder)
Use the session id that's returned by this block in all subsequent blocks that have a Session Id input field. The session id field can be found by navigating to the settings of Microsoft Excel blocks as shown in the below screenshot.
Note that when using a Microsoft Excel workbook session in an automation, the session must be closed at the end of the automation by adding a Close Workbook Session block.

Session id for Microsoft Excel blocks
Create a new worksheet using the Add Worksheet block from the Microsoft Excel connector. Use the same Drive Id & Item Id from the previous step and configure the Name parameter to a string of your choice.
Use the Get Straight Table Data block from the Qlik Cloud Services connector to get data from the straight table for a specific app that we want to sync to the Microsoft Excel worksheet.

Note the limit of 100 000 records that can be retrieved through the Get Straight Table Data block.
The response from the Get Straight Table Data block will be as shown in the below screenshot. The keys will act as headers and the values will act as rows corresponding to the keys in the Microsoft Excel table.

Response from qlik sense straight table
Create a new table in the worksheet created in the previous step using the Create Excel Table With Headers block from the Microsoft Excel connector. Use the same Drive Id & Item Id from the step 1 and configure the Name parameter to a string of your choice.

As mentioned in the above step, the table's headers should be the keys from the Get Straight Table Data block response as shown in the screenshot below.

Keep in mind that the number of columns selected using the start column and end column has to match with the headers array. E.g. C-E as column start/end for an array of 3 headers. If the headers array doesn't match with the column range added as an input(Start Column, End Column) to the 'Create Table With Headers' block, this block fails to execute with an error message "The number of rows or columns in the input array doesn't match the size or dimensions of the range."

Create table in excel
Use Loop batch block to loop over all items from the straight table and processes them in batch.
Initialize a variable called 'RowsString' of type string which is used to generate payload as an array of rows containing the values for the Add Rows To Table (Batch) block from the Microsoft Excel connector.
Use another Loop block to loop over each item in the batch and initialize another variable called 'SingleRow' of type string which is used to build a single row that corresponds to an item from the straight table.
Use the Add Rows To Table (Batch) block from the Microsoft Excel connector to insert an array of rows to the table. Use the same Drive Id & Item Id from the step 1.
Make sure to close the workbook session by adding the Close Workbook Session block from the Microsoft Excel connector at the end of the automation. Use the same Drive Id & Item Id from the step 1.

Please check out the attached JSON file containing the above automation.

Follow the steps provided in this article Upload Automation Workspace to import the automation from the copy-data-qlik-sense-excel.json file that's attached to this article.

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

Visual_Intelligence_Support — Thu, 07 Sep 2023 05:36:53 GMT

Stuck at the step 1. You didn't explain how to set up "Create workbook session" but straight go to the second step to add worksheet.

In step 1, it asks drive ID and item ID. Where do we have them?

Thanks

Fei

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

moshea — Sun, 10 Dec 2023 08:14:24 GMT

what is the item ID?

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

ccaporaso — Tue, 16 Jan 2024 14:42:09 GMT

Hi @AfeefaTk

Thanks for your article.

I have a similar use case to the one described in your post. The difference is that the straight table content must be copied and updated to an SQL Table.

¿Are you aware of a similar solution? ¿Any warning or advice?

Thanks in advance for your help.

Cecilia.

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

Sonja_Bauernfeind — Tue, 16 Jan 2024 14:43:47 GMT

Hello @ccaporaso

Please post your question and requirements in the Qlik Application Automation forum to get access to not only our active userbase, but our active support agents.

All the best,
Sonja

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

ccaporaso — Tue, 16 Jan 2024 14:45:48 GMT

Thanks, @Sonja_Bauernfeind ! I'll do it!

Regads,

Cecilia.

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

AfeefaTk — Fri, 19 Jan 2024 01:22:23 GMT

Hi @Visual_Intelligence_Support

You can use the do look up functionality to choose value from available options.

Please read through the help text below the input parameters to get a better understanding of how to use it.

Regards

Afeefa TK

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

sogloqlik — Sun, 28 Dec 2025 07:14:10 GMT

Hi,

Got to this automation and was surprised to read the answer to the questions. Why do I have to go to the forum and ask there? How can I learn something from the lookup if I don’t understand what it does?

To summarise: the first step is vague and not clear and your support answers doesn’t help to get any progress.

Very disappointing.

article Qlik Automate: Copy data to Microsoft excel sheets using automations (small datasets) in Official Support Articles

Qlik Automate: Copy data to Microsoft excel sheets using automations (small datasets)

Full automation

Step-by-step description

Related Content

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)

Re: Qlik Application Automation: Copy data to Microsoft excel sheets using automations (small datasets)