← Previous lessonFree lesson 2 of 3 · lesson 2 of 48Next lesson →

Unlock all 48 lessons of Data Analysis and Visualization with TableauFull course ₹40,000 · paid

Price & syllabus
Free lesson · 30 min · no payment

Connect Tableau to Excel: Live vs Extract Connections

A free lesson from Skill-Lync's Data Analysis and Visualization with Tableau course, on Grow by Skill-Lync · Last updated 16 Nov 2026 · Session: “Week 1 Session 2”

What will you learn in this free Data Analysis and Visualization with Tableau lesson?

Demonstrates Tableau Desktop's start page and connecting an Excel practice file. Explains the data source page, logical and physical canvas layers, live versus extract connections with a hospital example, extract options, and saving workbooks on Tableau Public.

  • Start page and connecting to an Excel file
  • Data source page, canvas and relationships
  • Live versus extract connections and when to use each
  • Extract filters and saving your workbook

What comes after lesson 2?

The next free lesson is lesson 3, “Tableau Data Pane and Quick Charts: Bar, Lollipop, Scatter” (29 min). Later in Skill-Lync's Data Analysis and Visualization with Tableau course (paid): lesson 4, Week 2 Session 2 Part 1; lesson 5, Week 2 Session 2 Part 2; lesson 6, Week 2 Session 3. The full course has 48 lessons (23 h 51 min of video); see the course overview or its price and syllabus.

Lesson transcript

Machine transcript of the lesson audio (lightly cleaned). Technical terms may contain errors; the video is the reference.

Moving on to the main important topic, software demo. When you open your Tableau desktop application, the first page is the start page. And it will look like this. It has all the available options to connect to data. If you want to connect to already developed workbooks, you can click on the below dashboards to look at the view and field. On the left side of the pane, you will see the connections available. You can connect to a file or to a server. Let's connect the practice file into Tableau.

Open the tool, click on the Microsoft Excel, and open your practice file. Tableau loads the data with sheet names on the left. You can also connect to multiple data sources at a time, join or blend from multiple tables. Here is how a Tableau data source page looks like when you connect your data. Drag the full data onto the view or simply double-click on the table name. Tableau will show the loaded data on the below part. You can check the data here on how Tableau's backend data will be.

We can see the columns and rows available in the data set. This is called the left pane of the data source page. It displays the connected data source and other details about your data. You can also use the left pane to add more connections to the data sources to create cross database joints. And this part is called canvas. We have canvas logical layer and canvas physical layer. The default option for Tableau now is canvas logical layer where you can create relationships between tables. Here's how a relationship line look like and it will pop up with an edit option.

If the data doesn't have a matching field, it throws on red error saying that there is no matching field between these two tables. To manually relate the fields in the data, you can actually select them and close this button. So Tableau will connect these two tables and show you the relationship. For now, I'm removing this table. If you want to join it with a physical layer, you have to double-click on this table. And it will go to the physical layer of the canvas. You can add joins and unions between tables in here.

And the down part is called data grid. Data grid shows the first thousand rows of the data contained in the Tableau data source. It will display the number over here. You can also use the data grid to make general modifications to the Tableau data source like sorting or hiding fields, renaming them, or resetting field names. You can either create calculations, change the column or row sort, or adding aliases. If you are on the logical layer, you see the data for this selected table. But if you are on the physical layer, you see the merged data between the joins and unions over here.

And we also have the metadata grid. This is the metadata grid. It displays the fields in your data source as rows. You can see the column name over here. And you can see the remote field name over here. This is the original name which is coming from the Excel sheet. If you are going to rename the column names over here, the renamed name will be displayed here. If you want to rename the data source name, you can actually rename it over here. You can give the name whatever you want to your file.

If you hover on the table names, you will see a grid line over here. If you click on it, Tableau will open the data behind the table. You can see all the rows and columns in a separate pop-up box. If you are unsure about the table and data behind it, you can actually check here. This is the data source page and we can go to the sheet or the dashboard or the story over here. We have the main menus like file, data, server, window, and help.

In the help, if you want to look at what version you are working on, you just go to help and click on abort Tableau. It will throw a pop-up box about the version names and details. In the file menu, we will have these common options with new, open, close, save, etc. You can save the dashboard on your desktop or you can either open an already saved dashboard from here. Inside the data, you will have options like to go to a new data source, to refresh already connected data source, and to duplicate the data source.

And you have options to export the data into the CSV. Sometimes you want to pull in the data from an outside source for some quick analysis. Rather than creating the whole data source and then connecting it into Tableau, you can simply copy and paste the data directly into your workbook. Tableau automatically creates a data source that you can begin analyzing. For example, I am just copying some random data into my data source now. Control-C. And I am pasting it here. I am going to select Paste Data as Connection or Paste Data as Data Source.

If you click on Paste Data as Connection, Tableau will bring up all this data as a connection for the already existing table. It will see any matching fields between the already existing table and whatever data we pasted. So, I pasted a completely unrelatable data when compared to our practice file. So, pasting as a connection is not a suitable option over here. I am removing the connections whichever I pasted. And I am clicking on Data again. I am pasting the data as a data source. Create a new data source connection over here with the name Clipboard because the data is copied.

And create a table over here. You can see the copied data under here. This is how you will paste the data from the source and you can do your analyzations quickly. When you paste the data as a data source, the data source is saved as a text file on your computer repository file. If you want to save your workbook, you can find this file in your Tableau repository under the documents page. You can copy and paste from a variety of Office applications including Microsoft Excel and Microsoft Word.

You can also copy and paste HTML tables from webpages. Tables that are copied as comma separated values or tab delimited can be pasted into Tableau. Now, I am going back to the practice file we have pasted. If you want to click on an undo option, you can click on this arrow. And if you want to redo it again, you can click on this arrow. If you want to save the connected data source, you can click on the save option. You do have a refresh button over here.

If your data is live and whenever the data is updated at the backend, you can click on the refresh button whenever the Tableau did not pick up the data from here. We do have a server option over here to sign into Tableau Public. You can publish your dashboards into signing into Tableau Public. For that, you need to create an account in Tableau Public and then you can publish the dashboards over there. If you want to look at the sample workbooks or sample gallery, you can go through these options.

Now, we will move on to the options available to keep the data live or an extract. You can see a live connection and extract connection over here. Extracts tend to be much faster than live connections, especially when you have a complex visualization with large data sets, filters, calculations, etc. When you create an extract file, such as like CSV or an Excel workbook from a local file or an on-premises database, you'll be speeding up the workbook through optimization. In this case, Tableau does... We don't need the database to build the visualization. Instead, Tableau's in-memory data engine queries the data directly.

We have several benefits whenever we are using extracts. It speeds up the workbook through optimization. The extract is embedded within the workbook, and the extracts are often much faster than the live connections. Whenever your data source is like big, and you have different kinds of visualizations and calculations running over. Therefore, extracts are great for the flow of visual analytics. You can work offline if you have an extract in your file. As the extract is already embedded, your data sources can be utilized whenever you are offline or your network connection is poor.

You will have your privacy by hiding certain fields within your data source, and then creating an extract. You can hide the fields that aren't used. If you click on the edit option over here, you will get a pop-up box for all the options available while creating an extract. You can hide your fields. Whenever the fields are not used in your visualization, you can hide all the unused fields and you can create the extract. This will ensure the data can only be viewed by the people intended.

However, because an extract is a snapshot of the data, the extract will need to be refreshed to receive the updates from the original data source. Whether it is a local file or an on-premises database, whenever the data is updated in your Excel sheet at the backend, you need to come down here. Making it to live will actually refresh the data. If it is not refreshed by then, you just have to click over this refresh button and it will pick up the new data. And you have to create the extract again with the new updates in your workbook.

When compared to the extract connections, live connections offer the convenience of the real-time updates. With any changes in the data source reflected in Tableau, you don't have to do the extract process again and again if the data is updated at the backend. If you keep your connection live, this database will relay on all the connections at the backend. Unlike extracts, databases are not always optimized for fast performance. With live connections, your data queries are only as fast as the database itself. We will talk about the pros of this live connection.

It gives us a real-time update. As your base is directly connected to the underlying data, this ensures data freshness. This will give you day-to-day analysis. Databases are not always optimized for fast performance. As data queries go through the database, they can only be fast as the database. Working with your live connection can be slow. There are some other factors related to the live connections. If you have a poor network speed or a network traffic, your data dashboard will be slowed down. The performance of the dashboard will be degraded.

Live connections, especially with the complex workbooks, can stress some traditional databases. So if you are going with a live connection, make sure that the database is not large or you do not have any complex queries running at the backend. One more difference between live and extract connection is live data will only save the connection information. Like if you connect to an Excel sheet, it will remember that connection name over here and the table name. It will not contain any data to your file. If you create an extract of it, all the data will be extracted into your file.

This is called a DDWX file and it is easy to share with others. If you share a live connection file with other people via a local sharing facility, it will ask for the Excel workbook wherever it is stored. The new person who is accessing this live file will have to locate the file again to the Excel sheet you are using it to. We will talk about an example between live and extract connections. Let's take the scenario in the hospitals. Hospitals that monitor incoming patient data need to make it real-time decisions.

These situations necessitate a live database connection. But in the same hospital, there may be also visualizations present to monitor daily or weekly trends. For these analytics, using an extract of the data source helps build a faster workbook. Depending on the type of data you are connected to, you can refresh your data when that data has changed using a number of options. For example, if you are connected to a data extract, you can refresh the selected data extract using the refresh button here. If you are on live data source, you can click on live and refresh over here.

Now, let's see how to create an extract. If you click on extract, it will give an option to edit the extract. To click on an extract, edit button, you will see logical table and also the physical table. The default one is logical table because the default canvas page is a logical table over here. If you are on a physical table, you can check the option of the physical tables and add the filter options. This filter over here is like you can add any column over here and check whatever data you require to extract.

If it is for category, if you want only the technology-related data and also the furniture-related data, you can check on these two options and click on OK. This filter will keep only the furniture and technology to extract. You can add multiple dimensions over here. And if you want to see only consumer-related data, you can click on consumer and click on OK. So, Tableau will alternately check for these two options. It will go to the category and check for furniture and technology and later comes to the segment and check for only the consumer-related data.

Now, I am just removing everything and you also have an option to refresh all the rows or just the top of the rows or just the sample of your data. You can give a number over here and Tableau will pick up only those rows to extract. You can check the extract history over here and you can hide all your unused fields by clicking on this icon. Now, I am just not selecting anything. I am just clicking the extract. If you just click on the sheet 1, the Tableau will start the extracting process.

Whenever the Tableau is starting the extracted process, for the first time, it will ask to share the space to store this hyperfile. This hyperfile is the extracted file whenever creating an extract. Just click the appropriate space and click on C. Tableau will start extracting the data from the file. So, the data is already extracted here. And how do you confirm that your data is already extracted? You will see these options over here. Extract data and use extract as a checkmark. It says that you are using the extracted data and this blue checkmark will appear over here.

If you are on live, you will not see this checkmark over here. You can go back to your data source by either clicking on the data source page over here or you can simply go back to the data source name and click on edit data source. It will throw back to your previous page and it says that it is already extracted on this particular date and time. You will get the edit option and also the refresh option over here. It says it means that it is already extracted and if you want to refresh the data, you can click on the refresh over here.

But whenever your data is updated at the backend, because this is only the snapshot of the data, Tableau will not recognize the data updated at the backend. You just have to go back to the live and refresh the data source and come back to the extract and click on the extract again. Now we will look at the other options available on the data source page. We have a filter option over here to add the filters to your data available. Adding a filter over here on the live data connection or whenever you are extracting, you will add a filter over here.

That is the same as this. You can add a filter over here or else you can just click on the edit button and add a filter over here. If you are on live, you will not get the edit option over here. Then you will go to the filters over here and click on the add filters. You can add any category or segment or any other column to the filter option. Now your data is live, but the filter is already applied and you will only see the filter related to the category technology.

If you see here, we are only seeing the data related to category and the technology. The data is live, but the data is already filtered to the category as technology. We call them as data source filters. If you put a data source filter and then click on extract, these are the extracted data source filters. But it is a live version, so we call them as data source filters. You can check the data source filter over here and it will throw a number over here on how many data source filters you applied in this edit box.

If you just add one more filter over here. Here, I just want to look at Subcategory, and I only want to look at Accessories, Appliances, Art, and click on OK. So, this will keep only Accessories, Appliance, and Art under Technology. So, your data will be filtered according to that. You can edit the data source filters by just clicking on the Edit option and checking on Remove. For now, I am just removing all the filters, and I am clicking on OK to see the full data at the back end.

You can also see these data source filters over here. It is the same option like this. There is one more option to close the data source. Closing a data source means closing your connection details. Everything you have connected right now, like you have connected to the Microsoft Excel file in your desktop, will be closed. Whenever you extract the data from the Excel sheet, and you click on the icon Hide the unused fields, over here, this will actually hide all the unused fields, which are not in use for your visualization.

This means that you already developed your visualization, came back to the extract version, and extracted the data out. So, what Tableau will do is, it will hide all the fields, which you did not use in the visualization. That means the X tag doesn't save your fields, which are not in use. So, if you want to add one more field to your visualization again, and you just have to come back to the live version, update your data, and you have to show the hidden fields over here.

And this option will show all the hidden fields in your actual file at the back end. And if you just renamed some column to the other name, you can check this show aliases button, and it will show the real name at the back. You also have an option called data source order over here. This is for the sorting of the data, whatever you see in the data grid. You can either sort it to A to Z, Z to A, A to Z ascending per table, Z to A descending per table.

I'm just clicking on A to Z ascending. If you see here, it started with C, because I doesn't have any column named under A or under B. So, it directly went to the C and started with C. If you just scroll to the right, you will see all the columns from A to Z. I'm just reverting back it to the data source order. Whenever you connect the data to your data source, to your Excel file or a text file or a server-related data source, Tableau will show only the first thousand rows over here, and the number is actually displayed here.

But this is editable, and you can see more than thousand rows over here. You can edit this option. Sometimes, if you want to look at a particular column, whether it is existing in your data or not, and if you're like, your data is too large, and you're not able to check this right scroll, and if you're not able to completely check the column names, just let's go to this metadata grid, and click on the sorting process. Now, you're able to check it according to the A to Z policy.

We also have an option for the new union over here. We will discuss more about the union processes in the coming weeks. One tip on this extracting process is, whenever you extract the data, make sure that it is updated on to the recent timing. Sometimes, the extracted process might fail, and the data will not be updated. It is actually mandatory to check whether the data is updated and the date is displayed right whenever you're extracting the data. And also, please make sure you're using the right filters when you're extracting the data.

This might create a confusion if you're looking at some other category, and your data source filter is filtered to some other category. If you're adding a data source from here, make sure that you're adding the data source of same source. If you add an Excel file over here, and if you add some other text file or CSV file over here without the relationship clause, it might create a confusion. So, if you add a data source from here, this will create a primary and secondary data source field from here.

But if you add a data source from here, it will actually create a new data source connection which will not be added into the existing data source connection. Connecting a data source from here, which is not an Excel file, because we are already connected to an Excel file, if you connect to a different data source file again, and if you want to blend those data sources, these are called multi-cross-functional data sources. We will discuss about this more in the coming weeks. Next, I will actually explain what is the cross-functional data sources and how to use a blend and how to use the join whenever you're adding too many tables from different different data sources.

If you don't understand it now, it is okay, but we will be discussing in depth about this in the coming weeks. Next, union option over here is used to append the data from the down, like joining and blending is adding the data from the side, but unioning the data is adding the data from the down. If you have an Excel file with some column names and if your data is updated into an other file, you can check the column names, whether they are same names, and you can union the data into here.

You just have to drag an Excel sheet into the union process. Moving next topic, saving your workbook. You can save your workbook by clicking on the save option over here, or else you can go to the sheet one and you can click the day file, and you can click the save option over here. If you want to rename the Tableau workbook, you can click on the save as option. This workbook is actually saved on your desktop or your preferred location. So, right now, we already extracted our data into the file.

So, this file will be saved on your desktop as TBWX file, which also contains data. For the later purpose, if you want to open the file, you just have to go to the file option, open the file from here, or else you can simply double-click the file on whatever preferred location you saved it. This is for the trial version of the Tableau desktop, but whenever you're working on the Tableau public, it will not give you the save option over there. You have to practice it over the Tableau public for the practice versions, but all the practiced work will not be saved in Tableau public.

And if you're working on this trial version, and if you're publishing the work onto the Tableau public server, you just have to create a Tableau public server account, and you can publish it over there and share it with others. So, whatever we learned today completes the connection to a data source, and we've looked about the Live and Extract versions. We discussed about the difference between the Live Connections and Extract Connections, and we discussed when we are using the Live Connections and when we are using the Extract Connections.

We already discussed about the options available whenever you're extracting the data. You can filter the data, or else you can give some options to extract all the rows or the top rows or the sample rows. You can also hide your fields whenever you're extracting the data to actually down your rows, like you can count down your rows and a set of data which is only useful for your visualizations. This will actually improve the performance of the dashboard because it contains a lesser set of data. And this will also give an easy access to access it later.

It also contains a snapshot of your data, so Tableau quickly picks up the data which is already existing in the file. We discussed about saving of your workbook through the save option available on the data source pane, and also the save option available on the data pane. You can simply open your workbook later by clicking on the file option and click on open, or else you can go to your preferred location wherever you've saved it previously. Just double click on the file and it will open it into the Tableau space.

These are the two options available for saving on your workbook. Please remember that if you are working on a Tableau public option, you will not be getting the save option to save your workbook. Moving on to the summary, whatever you covered this week is, we discussed about the installation and introduction to Tableau, and we also discussed about different products in Tableau and their rules. We looked at how Tableau works and how it is compared to the PPD about its functionality. How Tableau gives you dynamic filters and actions to actually prepare your data set to present it visually better.

We discussed about the data sources and different types of them on cloud and the local systems. We looked at the live and extract connections, and we also looked at examples. Live connection is better and the extract connections is better. We discussed about the pros and cons of the live and extract connections and finally we discussed about saving your work on your local system. Thank you for attending this session.

Want the rest of Data Analysis and Visualization with Tableau?

Get the full course syllabus and fees.

The full course is paid (₹40,000). We'll send the syllabus and call you back within one working day.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.

Full course · paid

Unlock the full Data Analysis and Visualization with Tableau course

The remaining 45 lessons, mentor-reviewed projects and a certificate come with the paid course (₹40,000). Leave your details: we'll send the syllabus and fees and call you back.

Get the syllabus and fees

A counsellor calls you back within one working day.

By submitting you agree to our Terms and Privacy Policy.

Grow by Skill-Lync · free lesson

Start watching

Free, no payment. Leave your details once and every free lesson on Grow plays straight away. A Skill-Lync counsellor may call you about the full Data Analysis and Visualization with Tableau course.

By submitting you agree to our Terms and Privacy Policy.

Talk to a career counsellor

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.