Extract tables and saved in one excel file

Hi Community,

I would like to ask how can we extract the tables and save in one excel file.

Currently the tables extracted and saved in the multiple excel file as per screenshot below:

For the above result, i follow the video guidance and i not sure how to change it so that the tables can be extracted in just one excel file.

Many thanks for your help.


Instead of write range use APPEND RANGE ACTIVITY and give a try

So that it will get written in same file and gets appended in the same file

Cheers @SH_94

1 Like


When you want the result to write in one excel sheet, then as you mentioned table.TableName just replace this with Sheet1

and instead of write Range use Append Range

because everytime loop runs the sheet you specify is Sheet1 and it will append the data instead of write range

Hope this may help you


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.