How to Pull Data from a Website into Tableau

Pulling data from a website usually means a tedious cycle of copying and pasting or downloading yet another CSV file. But if you have Tableau, you can often connect directly to a webpage and pull structured data right into your workbook. This guide will walk you through how to use Tableau's Web Data Connector, handle common issues like messy data, and keep your dashboards updated automatically.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Connect Tableau Directly to a Website?

You might be wondering if it's worth the effort compared to a quick copy-paste. Connecting Tableau directly to a web data source offers a few major advantages that save you time and improve your analysis:

• It Automates Data Entry: Say goodbye to manually highlighting tables, copying them, and pasting them into Excel or Google Sheets first. This eliminates a repetitive, error-prone step.
• You Get Fresher Data: When the data on the website updates, you don't have to go back and repeat the download-and-import process. You can simply refresh your data source in Tableau to pull in the latest information.
• It Allows for Scheduled Refreshes: If you publish your dashboard to Tableau Server or Tableau Cloud, you can schedule the connection to refresh automatically. Your stakeholders will always see the most current version of the data without you lifting a finger.

This method works best for data that's publicly available in a structured format on a website, like tables of statistics, financial data, or public records.

The Easiest Method: Using Tableau’s Web Data Connector

The simplest way to get website data into Tableau is by using the built-in Web Data Connector (WDC). This tool is designed to read the structure of a webpage, identify tables, and import them for you. It primarily looks for data organized within standard HTML <table> tags.

Finding the Right Kind of Data

Before you jump into Tableau, you need a webpage with data organized in a clean, simple table. Look for pages with clear columns and rows. A great source for practice is Wikipedia, which is full of structured tables.

For example, let's say you want to visualize the list of countries by population. A quick search leads to a Wikipedia page with a perfectly formatted table for this purpose. Copy the URL of that page - this is what you’ll need for Tableau.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Guide to Connecting

Once you have a URL with a table, the process inside Tableau Desktop is straightforward.

1. Locate the Web Data Connector Open a new workbook in Tableau Desktop. In the "Connect" pane on the left side, look under the "To a Server" section and click on More.... A list of additional data sources will appear. Select Web Data Connector.

2. Enter Your URL A new window will pop up prompting you for the URL of the WDC. For connecting to a standard HTML table, you just need to paste the URL of the webpage containing your data. Paste the Wikipedia URL (or your chosen URL) into the address bar and press Enter.

3. Select the Table to Import Tableau will load and analyze the webpage. It will then display a list of all the HTML tables it found on the page. In our example, Wikipedia might have several tables (like the main content table, navigation tables, etc.). You should see one clearly labeled with the data you want.

Click on the table you want to import. A preview of the data will often appear below, letting you confirm it’s the correct one.

4. Load the Data Once you've selected your table, click the button that says something like "Get The Data" or "Import." Tableau will then pull the data and load it into the Data Source tab, just like any other data source. You’ll see the columns and rows displayed, and you can begin cleaning it up - renaming fields, changing data types, or splitting columns - before heading to a worksheet to build your visualizations.

Handling Common Scenarios and Challenges

Connecting to a perfect HTML table works like a charm, but real-world web data can be messy. Here’s how to handle a few common obstacles.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What if the Data Isn't in a Clean HTML Table?

Sometimes, the data you want is displayed on a website but isn't built with proper <table> tags. It might be structured using <div>s or listed within <p> tags. In this case, Tableau's default WDC won't be able to "see" it.

You have a fantastic workaround: use Google Sheets as a middleman.

Google Sheets has a brilliant function called IMPORTHTML that can scrape tables (and lists) from webpages. Here's how to use it:

1. Open a new Google Sheet.
2. In cell A1, type the following formula:

=IMPORTHTML("URL", "table", 1)

• Replace "URL" with the link to the webpage.
• "table" tells the function you’re looking for a table. (You can also use "list" for bulleted or numbered lists).
• The number 1 at the end is the index of the table on the page. If the first table isn't the one you want, try 2, then 3, and so on, until the correct data appears.

Once the data loads into your Google Sheet, save the sheet. Then, back in Tableau, connect to a Google Sheets data source instead of using the Web Data Connector. This indirect method is incredibly reliable for stubborn websites.

Connecting to Pages That Require a Login

If the data you need is behind a username and password, the standard WDC likely won't work because it can't perform the login action for you. For these situations, you typically have two options:

1. Manually Export Data: The simplest route is often to log in, manually export the data as a CSV or Excel file, and connect Tableau to that static file. This is less automated but gets the job done.
2. Leverage an API (If Available): Many services offer an API (Application Programming Interface), which is a formal way to request data. Connecting to an API often requires a custom-built Web Data Connector specific to that service. While powerful, this is a more advanced approach that generally requires some web development skills.

What About Connecting to APIs?

Some websites or services don't present data in HTML tables at all. Instead, they provide an API that returns data in a structured format like JSON or XML. While you can't just paste an API endpoint URL into the standard WDC, you can use a purpose-built WDC to connect to it.

These connectors are small web applications themselves, with code that tells them how to communicate with a specific API and format the response for Tableau. You can find pre-built WDCs for popular services (like Strava or Spotify) with a bit of searching, or if you have the technical know-how, you can build your own using Tableau's WDC SDK.

Best Practices for Web Data

Working with data from the web requires a slightly different mindset. Here are a final few tips to keep your analysis running smoothly.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Cleaning Data with Tableau Prep

Web data is notoriously messy. You'll often find strange characters, extra header rows, merged cells, or columns that need splitting. While you can do a lot of cleaning on the Data Source tab in Tableau Desktop, Tableau Prep Builder is specifically designed for this. You can connect Tableau Prep to your web data source (or the intermediate Google Sheet), create a series of cleaning steps, and then output a perfectly formatted final data source to use for your analysis.

Automating Refreshes

Remember, the biggest benefit of a live web connection is automation. If you have access to Tableau Cloud (formerly Tableau Online) or Tableau Server, you can publish your dashboard and schedule the connection to refresh. This means if the numbers on the Wikipedia page update next week, your published dashboard will automatically reflect those changes on your set schedule (e.g., every morning at 8 AM), keeping your reports current with zero manual effort.

Final Thoughts

Connecting Tableau directly to a website via its Web Data Connector opens up a world of automated reporting and analysis. For simple HTML tables, it’s a quick, point-and-click process. For trickier data structures, using a go-between like Google Sheets' IMPORTHTML function is a powerful workaround that can save you hours of manual data entry.

At Graphed, our mission is to eliminate this kind of data wrangling entirely. While Tableau is an amazing tool for visualization, just getting all your data into it from scattered sources like Google Analytics, Facebook Ads, Salesforce, and your e-commerce platform can be a full-time job. We solve that by connecting all your marketing and sales sources in one place with a few clicks. From there, you just ask questions in plain English, like "show me my ad spend vs. revenue by campaign," and we build the dashboard for you instantly.