> ## Content Index
> Fetch the complete content index at: https://www.vizney.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to Import Different Tables from One Excel Sheet into Tableau
- URL: https://www.vizney.com/how-to-import-different-tables-from-one-excel-sheet-into-tableau/
- Published: 2025-09-25T02:11:00.000Z
- Updated: 2025-09-25T02:11:50.000Z
- Author: Yehwan Hwang
- Tags: Knowledge Base

Users who are accustomed to Excel’s high degree of flexibility often store different types of tables within a single worksheet. While the standard approach for importing such data into Tableau is to separate each table into its own worksheet, you can instead use Excel’s **Name Manager** feature to bring in specific data ranges without having to split the sheet.

For example, if your data is structured like the following:

![](https://kr.vizney.com/content/images/2025/09/Original.jpg)

You can define named ranges for each distinct area using **`Formulas > Name Manager`** in Excel.

![](https://kr.vizney.com/content/images/2025/09/Name-Manager.png)

These named ranges will then appear as individual tables in Tableau, allowing you to import and use them as if they were on separate sheets.

![](https://kr.vizney.com/content/images/2025/09/List.jpg)

![](https://kr.vizney.com/content/images/2025/09/Regional-Manager.jpg)

![](https://kr.vizney.com/content/images/2025/09/Category-Manager.jpg)

Furthermore, these named ranges can be treated just like regular sheets in Tableau—meaning you can **join**, **union**, or otherwise manipulate them within your data model.

![](https://kr.vizney.com/content/images/2025/09/Join.jpg)