# Need Auto scheduled script output in Excel format? Please help **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [October 25, 2013, 12:31pm UTC](https://forums.toadworld.com/t/need-auto-scheduled-script-output-in-excel-format-please-help/27317 "2013-10-25T12:31:44Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![varunkumar564](https://avatars.discourse-cdn.com/v4/letter/v/f9ae1b/32.png) [@varunkumar564](https://forums.toadworld.com/u/varunkumar564)\ **Post date:** [October 25, 2013, 12:31pm UTC](https://forums.toadworld.com/t/need-auto-scheduled-script-output-in-excel-format-please-help/27317/1 "2013-10-25T12:31:44Z")
Hello I am new to this community, so this mightbe too basic but i am trying to get my autoscheduled query output in Excel. Currently when i autoschedule my script using execut script i am getting my out put in .txt format. so all in all i am trying to auto schedule a small script on hourly basis and get the output in excel and i dont know how to do that. Please help... Thanks for help in advance. ---
**Author:** ![IgorM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/igorm/32/116_2.png) [@IgorM](https://forums.toadworld.com/u/IgorM)\ **Post date:** [October 25, 2013, 1:18pm UTC](https://forums.toadworld.com/t/need-auto-scheduled-script-output-in-excel-format-please-help/27317/2 "2013-10-25T13:18:03Z")
Hello Kumar, What you need to do is create a simple Automation script in TDP with ‘Select to File’ activity as a main part of it. There you can select report file format. I’m attaching a simple script for your reference. This script uses Toad Sample Database as a source of data and saves result in c:\temp folder. If you don’t want to keep all the reports from all script invocations, please select empty suffix. Is it what you’re asking for? Igor.[View:~/cfs-file.ashx/\_\_key/communityserver-discussions-components-files/111/Script\_5F00\_1.tas:550:0] ---
**Author:** ![varunkumar564](https://avatars.discourse-cdn.com/v4/letter/v/f9ae1b/32.png) [@varunkumar564](https://forums.toadworld.com/u/varunkumar564)\ **Post date:** [October 25, 2013, 1:33pm UTC](https://forums.toadworld.com/t/need-auto-scheduled-script-output-in-excel-format-please-help/27317/3 "2013-10-25T13:33:09Z")
what i need is; in toad 11.5, i want to put a sql query (using Toad) to execute on its own (auto execute) and get the query output in excel, what i am getting now is in .txt file format and i have tried alot but i dont see a way to get it in excel. also i dont know what is TDP…thanks for your response ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [October 26, 2013, 1:27pm UTC](https://forums.toadworld.com/t/need-auto-scheduled-script-output-in-excel-format-please-help/27317/4 "2013-10-26T13:27:49Z")
What product are you using? This forum is for Toad Data Point. Are you using Toad for Oracle? ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [October 26, 2013, 1:44pm UTC](https://forums.toadworld.com/t/need-auto-scheduled-script-output-in-excel-format-please-help/27317/5 "2013-10-26T13:44:42Z")
If you are using Toad Data Point, please see this video as well as the sample automation script Igor sent you. [http://www.toadworld.com/products/toad-data-point/m/media-library/590.aspx](http://www.toadworld.com/products/toad-data-point/m/media-library/590.aspx) Debbie ---
**Author:** ![varunkumar564](https://avatars.discourse-cdn.com/v4/letter/v/f9ae1b/32.png) [@varunkumar564](https://forums.toadworld.com/u/varunkumar564)\ **Post date:** [October 26, 2013, 2:28pm UTC](https://forums.toadworld.com/t/need-auto-scheduled-script-output-in-excel-format-please-help/27317/6 "2013-10-26T14:28:07Z")
Yes, I'm using toad for oracle 11.5 On Oct 26, 2013 3:28 PM, "Debbie Peabody" [bounce-Debbie\_Peabody@toadworld.com](mailto:bounce-Debbie_Peabody@toadworld.com) wrote: > **[RE: Need Auto scheduled script output in Excel format? Please help](http://www.toadworld.com/products/toad-bi-suite/f/111/p/20610/42074.aspx#42074)** > Reply by Debbie Peabody > What product are you using? This forum is for Toad Data Point. Are you using Toad for Oracle? > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-bi-suite/f/111/t/20610.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad Intelligence Central - General](http://www.toadworld.com/products/toad-bi-suite/f/111.aspx?subscribe=false) notifications altogether. > [Flag](http://www.toadworld.com/products/toad-bi-suite/f/111/p/20610/42074.aspx?AbuseContentId=2d949546-08d3-4bbb-96a9-b27f51b805de&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [October 26, 2013, 2:29pm UTC](https://forums.toadworld.com/t/need-auto-scheduled-script-output-in-excel-format-please-help/27317/7 "2013-10-26T14:29:45Z")
I see. Use this forum. [www.toadworld.com/.../10.aspx](http://www.toadworld.com/.../10.aspx) ---
**Author:** ![varunkumar564](https://avatars.discourse-cdn.com/v4/letter/v/f9ae1b/32.png) [@varunkumar564](https://forums.toadworld.com/u/varunkumar564)\ **Post date:** [October 26, 2013, 2:31pm UTC](https://forums.toadworld.com/t/need-auto-scheduled-script-output-in-excel-format-please-help/27317/8 "2013-10-26T14:31:08Z")
Thanks, I will do that. On Oct 26, 2013 4:29 PM, "Debbie Peabody" [bounce-Debbie\_Peabody@toadworld.com](mailto:bounce-Debbie_Peabody@toadworld.com) wrote: > **[RE: Need Auto scheduled script output in Excel format? Please help](http://www.toadworld.com/products/toad-bi-suite/f/111/p/20610/42078.aspx#42078)** > Reply by Debbie Peabody > I see. Use this forum. > [www.toadworld.com/.../10.aspx](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx) > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-bi-suite/f/111/t/20610.aspx?subscribe=false) on this subject. > > Or [Unsubscribe from Toad Intelligence Central - General](http://www.toadworld.com/products/toad-bi-suite/f/111.aspx?subscribe=false) notifications altogether. > [Flag](http://www.toadworld.com/products/toad-bi-suite/f/111/p/20610/42078.aspx?AbuseContentId=c79b3bf8-5776-4a12-8c70-184ac348bc8e&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)