---
title: "Configure Excel data source in Advanced Table Viewer macro"
canonical: "https://support.appfire.com/space/TBL/3122888898/Configure%20Excel%20data%20source%20in%20Advanced%20Table%20Viewer%20macro"
format: markdown
---
> Macro (aura-html)
---
This page details how to configure the Advanced Table Viewer macro for an Excel data source.
## Insert the macro
Insert the macro in a Confluence page editor using the macro browser or the macro shortcut (/).
## **Connect data source**
- On the initial setup screen, click **Connect Data Source**.
- The *Select* *data source* dialog opens.
- To configure the Excel data connector, select **Excel** from the *Select data connector *dropdown. By default, the CSV data connector is selected.
- For the Excel data connector, choose how you want to provide your Excel data. By default, **Upload file** is selected. Refer to [Configure the Excel data source](#Configure-the-Excel-data-source).
- **Upload file**: Upload an Excel file from your computer.
- **Attachment**: Use an Excel file attached to the current Confluence page.
- **URL**: Provide a direct URL to your Excel file.
## Configure the Excel data source
> Macro (refined-tabs)
>
> > Macro (refined-tab)
>
> The **Upload file** option lets you to use an Excel file from your computer.
>
> - Once you select **Upload file,** the macro displays the **Upload a file** field.
> - To upload an Excel file, click **Browse**.
> - Select an Excel file not exceeding 10 MB from your computer.
> - Once you choose a file, the macro automatically fetches the first sheet and first table and displays the sheet name and column names:
> - The **Select sheet** displays the list of sheets from the Excel file. By default, it displays the name of the first sheet.
> - To choose a different sheet, click the drop-down and select the required sheet. You can select only one sheet per macro instance.
> - The **Select columns** field displays the list of column names available from the selected sheet. By default, it displays the column names from the first sheet.
> - As you change the sheet selection, the **Select columns** field fetches the corresponding column names and updates accordingly.
> - For further configuration, proceed to the **Select and order columns** section on this page.
>
> > ❌ If the Excel file contains errors or exceeds 10 MB, the macro displays an error message.
>
>
> > Macro (refined-tab)
>
> The Attachment option lets you to use an Excel file attached to the current Confluence page as your data source.
>
> - Once you select **Attachment,** the macro displays the **Select page attachment **dropdown.
> - The **Select page attachment** dropdown lists the Excel files attached to the current page. Select the Excel file you want to use as your data source.
> - Once you choose an Excel attachment, the macro automatically fetches the first sheet and first table and displays the sheet name and column names:
> - The **Select sheet** displays the list of sheets from the Excel file. By default, it displays the name of the first sheet.
> - To choose a different sheet, click the drop-down and select the required sheet. You can select only one sheet per macro instance.
> - The **Select columns** field displays the list of column names available from the chosen sheet. By default, it displays the column names from the first sheet.
> - As you change the sheet selection, the **Select columns** field fetches the corresponding column names and updates accordingly.
> - For further configuration, proceed to the **Select and order columns** section on this page.
>
> > ❌ If the Excel file contains errors or exceeds 10 MB, the macro displays an error message.
>
>
> > Macro (refined-tab)
>
> The URL option lets you use an Excel file’s direct URL as your data source.
>
> - Once you select the **URL **option, the macro displays the **Paste file URL **field.
> - In the** Paste file URL** field, paste the direct URL to your Excel file and click **Import data**.
>
> > ℹ️ The macro supports only a direct link to an .xls or .xlsx file up to 10 MB.
> > ℹ️
> > ℹ️ :check_mark: [https://abc.example.com/../Product_Inventory.xlsx](https://abc.example.com/../Product_Inventory.xlsx)
> > ℹ️
> > ℹ️ :cross_mark: [https://abc.example.com/…/Product_Inventory_download](https://abc.example.com/taxables_download)
>
> - Once you click Import data, the macro automatically fetches the first sheet and first table and displays the sheet name and column names:
> - The **Select sheet** displays the list of sheets from the Excel file. By default, it displays the name of the first sheet.
> - To choose a different sheet, click the drop-down and select the required sheet. You can select only one sheet per macro instance.
>
> The **Select columns** field displays the list of column names available from the selected sheet. By default, it displays the column names from the first sheet.
>
> -
> - As you change the sheet selection, the **Select columns** field fetches the corresponding column names and updates accordingly.
> - For further configuration, proceed to the **Select and order columns** section on this page.
>
> > ❌ If the Excel URL is invalid, or the file contains errors, or exceeds 10 MB, the macro displays an error message.
>
>
> > Macro (refined-tab)
>
> The **Select columns** field displays the column names available to display in the table.
>
> You can remove, select, and reorder the column names as needed. The column names appear in the Confluence table in the order you select them.
>
> - **To clear all selected columns**
> - To remove all column selections at once, click Clear All (:cross_circle: ). After clearing, click the field and re-select column names in the required order.
> - **To remove a specific column**
> - Next to the column name, click :cross_circle: to remove it from the selection.
> - **To select columns**
> - Click the **Select columns** field and choose the column names from the dropdown. The order you select determines the column order in the table.
>
> > ℹ️ The order in which you select the column names determines the column order displayed in the Confluence table.
>
> Once you have selected the required columns, proceed to the **Save and publish **section.
>
>
> > Macro (refined-tab)
>
> - In the *Select data source* dialog, click **Save**.
> - The macro opens in setup mode, displaying the table with the selected column names and data.
> - In setup mode, you can configure various available features, such as column filtering, row styling, search, row numbering, sorting, download, and sum-up. Refer to [Setup the Advanced Table Viewer macro features](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1765147138).
> - To apply the configurations, click **Save**.
> - The configured table appears on the Confluence page in edit mode.
> - **Publish** the page to view the table in the page view mode.
> - Your Excel data is now ready to view and analyze directly within Confluence. The full-screen view opens as an overlay on the Confluence page to provide a maximized view of data.
> ℹ️ To know about the various terms used in the macro, refer to the [Advanced Table Viewer macro glossary](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1765245023).