# Naming Worksheets, with multiple queries

**URL:** <https://forums.toadworld.com/t/naming-worksheets-with-multiple-queries/27630>\
**Category:** Toad for SQL Server\
**Created:** [November 14, 2013, 9:13am UTC](https://forums.toadworld.com/t/naming-worksheets-with-multiple-queries/27630 "2013-11-14T09:13:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jamesgriff](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@jamesgriff](https://forums.toadworld.com/u/jamesgriff)\
**Post date:** [November 14, 2013, 9:13am UTC](https://forums.toadworld.com/t/naming-worksheets-with-multiple-queries/27630/1 "2013-11-14T09:13:11Z")

</div>

Is there a way to automate naming worksheets within sql or a toad option? As of now multiple queries export to Sheet1, Sheet2, Sheet3 etc.

---

<div class="post-metadata">

**Author:** ![siva\_pp](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@siva\_pp](https://forums.toadworld.com/u/siva_pp)\
**Post date:** [November 10, 2015, 12:04pm UTC](https://forums.toadworld.com/t/naming-worksheets-with-multiple-queries/27630/2 "2015-11-10T12:04:16Z")

</div>

Even I am looking for answer for this. Can someone let me now how to set predefined worksheet name for each SQL.

---

<div class="post-metadata">

**Author:** ![Kelly.Chen](https://avatars.discourse-cdn.com/v4/letter/k/dfb087/32.png) [@Kelly.Chen](https://forums.toadworld.com/u/Kelly.Chen)\
**Post date:** [November 12, 2015, 2:15am UTC](https://forums.toadworld.com/t/naming-worksheets-with-multiple-queries/27630/3 "2015-11-12T02:15:39Z")

</div>

Hi,

In Tools-\>Export-\>Export Wizard.

When we select mutiple object to export. In Select Excel Output Options Page, there is a option Worksheet name.

From Help Doc. In page Export Data with the Export Wizard.

Worksheet name

Enter the name of the worksheet.

This field is only available if you are exporting a single object. If you leave this field blank or are exporting multiple objects, the worksheet name defaults to the name of the object.

If you are exporting using multiple queries, each query exports to a separate worksheet (Sheet 1, Sheet 2, etc.).

Best Regards,

Kelly
