How to Connect Tableau to SharePoint Excel File

Trying to connect Tableau to an Excel file stored in SharePoint feels like it should be simple, but it can quickly become a frustrating roadblock. You have your clean, collaborative data waiting in the cloud, but Tableau doesn't offer a direct "Connect to SharePoint Excel" option. This tutorial will walk you through the most reliable method for creating a live, refreshable connection between your Tableau workbooks and your SharePoint Online Excel files.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Connect Tableau to a SharePoint Excel File?

Before diving into the "how," let's quickly cover the "why." Using a SharePoint Excel file as a data source is about creating a "single source of truth." When your team updates the numbers in that one central spreadsheet, you want your Tableau dashboards to reflect those changes automatically after a refresh.

Here’s what you gain:

• Collaboration: Your entire team can contribute to and update the same Excel file without sending different versions back and forth via email.
• Version Control: SharePoint Online automatically tracks file versions, so you can see changes and revert if needed.
• Automation: Once connected properly, you can schedule your Tableau dashboards to refresh automatically, eliminating the tedious weekly routine of downloading a new file, re-linking the data, and republishing your work.

Downloading a copy of the file every time you need to update a report is not a scalable solution. It introduces manual work and the risk of using outdated data. The goal is to build a reliable pipeline from your SharePoint file straight into your visualizations.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The Best Method: Sync SharePoint to Your Desktop Using OneDrive

While it may sound counter-intuitive, the most effective and widely-used method is to sync your SharePoint document library to your local machine using OneDrive. This creates a local copy of the file that stays in sync with the cloud version. Tableau can then connect to this local file, and since OneDrive keeps it updated, your dashboard can be refreshed with the latest data.

This approach works for both creating dashboards on Tableau Desktop and publishing them to Tableau Server or Tableau Cloud for scheduled and automated refreshes.

Step 1: Get Your Prerequisites in Order

Make sure you have the following ready to go:

• A SharePoint Online Account: You'll need access to the SharePoint site and document library where the Excel file is stored. You must also have at least "Read" permissions for that file and library.
• The OneDrive Sync Client: This is typically installed by default on modern Windows machines. If not, you can download it from Microsoft.
• Tableau Desktop: This is where you will build your connection and visualizations.

Step 2: Sync Your SharePoint Document Library

First, you need to tell your computer to create a mirrored, synced copy of the SharePoint folder that contains your Excel file.

1. Navigate to your SharePoint site in a web browser.
2. Go to the "Documents" library or the specific folder where your Excel file is located.
3. Look for the Sync button in the toolbar at the top of the page. It's usually found alongside "Upload," "New," and "Share."
4. Click Sync. A prompt will appear asking for permission to open OneDrive. Click "Open" or "Allow."
5. The OneDrive client will take over and begin syncing the entire library or folder to your local machine.

Once the sync is complete, you will see a new location in your Windows File Explorer. It's often marked with a blue building icon and named after your organization (e.g., "Contoso Inc."). Inside that location, you will find the exact folder structure from SharePoint and, most importantly, your Excel file!

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Connect Tableau to the Synced Excel File

Now that the file has a local path, connecting Tableau is straightforward, just like connecting to any other Excel file on your computer.

1. On the Tableau start screen, under "Connect," click on Microsoft Excel.
2. A File Explorer window will open. Navigate to the synced SharePoint folder you created in the previous step. You'll typically find it under C:\Users\[YourUsername]\[YourOrganizationName]\...
3. Select your Excel file and click Open.

Tableau will now connect to the file, and you can see your sheets and any data prep steps you need to take, like using Data Interpreter or creating relationships between tables. You can now build your visualizations as you normally would.

Publishing for Automated Refreshes: The UNC Path

Creating a local connection works perfectly if you are the only person using the workbook, and you don't mind manually refreshing in Tableau Desktop. However, true power comes from publishing your workbook to Tableau Server or Tableau Cloud and scheduling automatic refreshes.

This is where things can get tricky. When your report on Tableau Server tries to refresh, it doesn't have access to the file at C:\Users\[YourUsername]\... because that path only exists on your computer.

To solve this, you need to provide a Universal Naming Convention (UNC) path. A UNC path is a network path that any authorized user or service on the same network can access. It has a specific format: \\computer-name\shared-folder-name\path-to-file\your-file.xlsx

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Find the UNC Path

1. With your workbook open in Tableau Desktop, go to the Data Source tab at the bottom left.
2. Right-click on your Excel file connection in the top left corner of the data source pane and select Edit Connection.
3. In the pop-up window, you'll see the current local file path. You need to replace this with the UNC path. The UNC path will be very similar, but it starts with your computer's name instead of a drive letter. In many corporate environments, your synced OneDrive folder is essentially a network drive, and you can construct the path like this: \\[YourComputerName]\Users\[YourUsername]\[YourOrganizationName]\path-to-file\your-file.xlsx
4. Enter the full UNC path into the dialog box and click OK.

Setting Up the Scheduled Refresh

After updating the connection to use the UNC path, you can publish the workbook to Tableau Server.

1. Go to Menu > Server > Publish workbook...
2. During the publishing process, make sure you look for authentication settings. In the "Data Source" section, choose Embedded password to set embedded credentials. This means Tableau Server will use the credentials it has to access the UNC path. These credentials belong to the "Run As" user account that your Tableau Server is configured to use. Your Tableau admin will know what this is.
3. Schedule your extract refreshes as you normally would.

Now, when the scheduled refresh runs, Tableau Server will use the UNC path to find your OneDrive-synced file and update the extract.

Final Thoughts

Connecting Tableau to a SharePoint Excel file is essentially about building a bridge between the cloud and your desktop. Using the OneDrive sync method allows you to create a live, refreshable data source while still enjoying the collaboration benefits of SharePoint Online. It requires a few extra steps to set up, but it's the only reliable way to automate your data refresh process.

While these methods work well for Excel, when you want to connect to all your data sources, like Salesforce, Google Analytics, and Shopify, in a single place, leveraging UNC paths and names can become cumbersome. This is where Graphed can step in with a natural language guide. Join Graphed to simplify connecting all your platforms into a centralized analytics dashboard without the headache of managing everything manually.