# Export multiple scripts to one excel report

**URL:** <https://forums.toadworld.com/t/export-multiple-scripts-to-one-excel-report/38148>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [August 9, 2016, 2:28pm UTC](https://forums.toadworld.com/t/export-multiple-scripts-to-one-excel-report/38148 "2016-08-09T14:28:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Blair800](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@Blair800](https://forums.toadworld.com/u/Blair800)\
**Post date:** [August 9, 2016, 2:28pm UTC](https://forums.toadworld.com/t/export-multiple-scripts-to-one-excel-report/38148/1 "2016-08-09T14:28:07Z")

</div>

I use TOAD Data point 4.0 Automate to execute two scripts and will export the results to Excel file

The steps are as the following:

1. Go to Automate

2. Select file 1 and export the result to Excel file , start export at A1

3. Select file 2 and export the result to the same Excel file, start export at B1

After running the scripts, only the second files export to excel file

---

<div class="post-metadata">

**Author:** ![Martin.Holkovic](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin.holkovic/32/318_2.png) [@Martin.Holkovic](https://forums.toadworld.com/u/Martin.Holkovic)\
**Post date:** [August 10, 2016, 12:32am UTC](https://forums.toadworld.com/t/export-multiple-scripts-to-one-excel-report/38148/2 "2016-08-10T00:32:12Z")

</div>

Hello Blair,

Can you please clarify - did you uncheck the “Overwrite” checkbox on the Select file 2 activity? Also please note that there is a “Advanced properties” button right next to it where you can further specify export settings - especially the “Append rows” checkbox.

If that does not help you, can you please attach a sample automation script (.tas file) with this problem? If you are unable to attach it here on the forum post, you might want to send it to my email address: [martin.holkovic@quest.com](mailto:martin.holkovic@quest.com).

Thank you

---

<div class="post-metadata">

**Author:** ![Blair800](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@Blair800](https://forums.toadworld.com/u/Blair800)\
**Post date:** [August 15, 2016, 8:19am UTC](https://forums.toadworld.com/t/export-multiple-scripts-to-one-excel-report/38148/3 "2016-08-15T08:19:33Z")

</div>

Hi Martin,

Thank you ! It works with the following steps:

1. Go to Automate
2. Select file 1 and export the result to Excel file ,
3. Uncheck “Overwrite” checkbox on the Select file 1 activity, and select static sheet name from the list
4. Check Use column name for a header row, and check Auto fit Column -start export at A1
5. Select file 2 and export the result to Excel file ,
6. Uncheck “Overwrite” checkbox on the Select file 2 activity, and select static sheet name from the list
7. Check Use column name for a header row, and check Auto fit Column -start export at B1