How to Connect SharePoint List to Tableau

Getting your data out of a SharePoint List and into Tableau is the key to creating powerful, interactive dashboards for your team. While it might seem complicated, the process is straightforward once you know which connector to use and how to format your site’s URL. This guide will walk you through the primary method for creating a live connection and a simple alternative for one-off analyses.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Connect a SharePoint List to Tableau?

SharePoint is fantastic for collaborative data entry and storage. Teams use it to track everything from project deliverables and sales leads to IT tickets and inventory. However, SharePoint’s built-in reporting features are quite limited. They’re functional for basic views but lack the dynamic filtering, visual power, and analytical depth of a true business intelligence tool.

Tableau, on the other hand, is built for data visualization and exploration. By connecting the two, you can:

• Build interactive dashboards from your list data that anyone can use.
• Combine your SharePoint data with other sources (like a CRM or financial software) for a complete picture of performance.
• Perform deeper analysis, spot trends, and share insights that would be hidden in a simple SharePoint view.

In short, you’re taking your team's raw data and turning it into a professional, actionable report.

Before You Begin: What You’ll Need

Before jumping in, make sure you have a few things ready. A little preparation now will save you from headaches later.

• Tableau Desktop: You must have Tableau Desktop installed on your machine. This process cannot be done through the Tableau web editor.
• SharePoint Site URL: You need the URL to the SharePoint site that hosts your list. For example, https://yourcompany.sharepoint.com/sites/Marketing.
• List Name: Know the exact name of the list you want to connect to.
• Permissions: You need at least "Read" permissions for the SharePoint list you want to access. If you can't view the list in your browser, you won’t be able to connect it to Tableau.
• Authentication Credentials: Have your Office 365 or company network login (username and password) handy.

Method 1: Using the OData Connector (The Recommended Way)

The best way to establish a live connection to a SharePoint List is by using Tableau’s built-in OData connector. OData (Open Data Protocol) is a standard way for applications to talk to each other over the web, and SharePoint makes its list data available through this protocol. This method creates a connection that you can refresh to pull in the latest data from your list.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 1: Open Tableau and Find the OData Connector

Launch Tableau Desktop. On the "Connect" pane on the left, under the "To a Server" section, click on More... A longer list of server types will appear. Find and select OData.

Step 2: Construct and Enter the OData URL

This is the most important step. Tableau needs a very specific URL to find your SharePoint list data. You can't just paste your normal site URL here. You need to combine your main site URL with a special OData path.

The format is: Your_SharePoint_Site_URL + /_vti_bin/listdata.svc

Let’s break it down:

• Find your site URL: Navigate to your SharePoint site in your web browser. Copy the URL up to the site name. For example, if your list is on a site called "SalesTeam," the URL might be https://yourcompany.sharepoint.com/sites/SalesTeam.
• Add the OData suffix: Append /_vti_bin/listdata.svc to the end of that URL.

Using our example, the final OData URL would be:

https://yourcompany.sharepoint.com/sites/SalesTeam/_vti_bin/listdata.svc

Enter this complete URL into the text box in the Tableau OData connection window.

Step 3: Authenticate Your Connection

Next, you’ll need to prove you have permission to access the data. In the "Authentication" section dropdown, select Username and Password. Enter the same email address and password you use to log in to SharePoint (your Office 365 credentials). Click Sign In.

(Note: If your company uses on-premise SharePoint with Windows Active Directory, you might select "Integrated Authentication" instead.)

Step 4: Select Your List

If the URL and your credentials were correct, Tableau will connect successfully. The left pane will now show a list of all the tables (which are your SharePoint Lists) available from that site. Scroll through the list and find the SharePoint list you want to analyze.

Double-click the list or drag it onto the "Drag tables here" canvas. Tableau will load a preview of its columns and data so you can confirm you've selected the right one.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 5: Navigate to Your Worksheet and Start Building

That's it! Now just click on the "Sheet 1" tab at the bottom, and you can start dragging fields onto your rows and columns to build visualizations, just like you would with any other data source.

Method 2: Exporting to Excel/CSV (The Quick Alternative)

Sometimes, the OData connection can be slow, or perhaps you're having authentication issues. Maybe you just need a quick, one-time snapshot of the data for a report. In these cases, a simple export from SharePoint is your best bet.

The major downside of this method is that the data is static. If the SharePoint List gets updated, you must repeat this process and export a new file to see the changes in Tableau. This is not ideal for ongoing reporting.

Step-by-Step Guide:

1. Navigate to your SharePoint List in your web browser.
2. In the command bar above the list, click the Export button.
3. From the dropdown, select Export to CSV file. (You can also use "Export to Excel," but CSV is often simpler and more reliable).
4. Your browser will download a .csv file containing all the data from your current list view.
5. Open Tableau Desktop. On the "Connect" pane, select Text file.
6. Navigate to the CSV file you just downloaded and open it.
7. Tableau will load the data, and you can proceed to create your visualizations.

This method is foolproof and fast, making it great for when you just need the data now and aren't concerned about it refreshing automatically.

Troubleshooting Common Issues

Connecting software can sometimes be bumpy. Here are a few common snags you might hit and how to fix them.

Authentication Failed / Permission Denied

This is the most common issue. First, double-check that you typed your username and password correctly. If your company uses Multi-Factor Authentication (MFA), the standard OData connector in some older Tableau versions can struggle. You may need to work with your IT department to see if they can help, or you might need to rely on the export-to-CSV method as a workaround.

OData Communication Error

If you get a generic error about communicating with the OData source, the culprit is almost always the URL itself. Make absolutely sure you've included the /_vti_bin/listdata.svc suffix and that your base SharePoint URL is correct. One wrong character can break the whole thing.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Slow Performance with Large Lists

If your SharePoint list has thousands of rows and many columns, a live connection can feel sluggish. The best way to speed this up is to create a Tableau Extract. After setting up your connection on the Data Source tab, switch from "Live" to "Extract" in the top right corner. An extract is a highly compressed snapshot of your data stored locally, which makes dashboard performance much faster. You can schedule refreshes of this extract so it stays up to date with your SharePoint list.

Strange Column Names like "Address Line 1"

SharePoint doesn't allow spaces in its internal column names. When it sends data via OData, it replaces spaces with the code . Don't worry about this! It's perfectly normal. Once in Tableau, you can simply right-click any field name in the Data pane and select "Rename" to give it a friendlier, more readable name for your reports.

Final Thoughts

Connecting your SharePoint data to Tableau opens up a new world of reporting possibilities, allowing you to move beyond simple lists and create professional, interactive analytical tools for your team. Whether you use the direct OData connector for a live feed or a quick CSV export for a static report, you now have the tools to visualize the valuable data your organization already collects.

While these methods are powerful, they can sometimes involve getting stuck on technical hurdles like complicated URLs or data refresh schedules. We built Graphed to remove exactly this kind of friction from the reporting process. Instead of managing connectors and figuring out dashboard layouts, you can simply connect your data sources in seconds and use simple, conversational language to ask for the dashboards and reports you need — making data analysis as easy as having a conversation.