Home

Excel Get Data function

%3CLINGO-SUB%20id%3D%22lingo-sub-879533%22%20slang%3D%22en-US%22%3EExcel%20Get%20Data%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879533%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20use%20Excel's%20Get%20Data%20function%20to%20connect%20to%20a%20Tableau%20server%20workbook%20to%20pull%20data%20into%20an%20Excel%20workbook%3F%20I%20do%20not%20want%20to%20manually%20export%20from%20Tableau%20into%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-879533%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGet%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETableau%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879560%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Get%20Data%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879560%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416448%22%20target%3D%22_blank%22%3E%40Etronson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20no%20practical%20experience%2C%20but%20check%20this%20post%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fpulse%2Ftableau-server-data-source-details-using-power-bi-excel-rob-reilly%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fpulse%2Ftableau-server-data-source-details-using-power-bi-excel-rob-reilly%2F%3C%2FA%3E%20if%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879561%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Get%20Data%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879561%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20good%20article%20but%20does%20not%20fully%20automate%20the%20data%20pull.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879576%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Get%20Data%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416448%22%20target%3D%22_blank%22%3E%40Etronson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPower%20Query%20has%20no%20built-in%20connector%20to%20Tableau%2C%20thus%20only%20third%20party%20solutions%20like%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879680%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Get%20Data%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879680%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416448%22%20target%3D%22_blank%22%3E%40Etronson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EIf%20you%20created%20any%20visualization%20in%20Tableau%2C%20then%3C%2FP%3E%3CP%3ERight%20click%20that%20visualization%3C%2FP%3E%3CP%3ESelect%20Copy%20Data%3C%2FP%3E%3CP%3EPaste%20it%20into%20Excel%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879697%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Get%20Data%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879697%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416448%22%20target%3D%22_blank%22%3E%40Etronson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20again%2C%3C%2FP%3E%3CP%3EIf%20you%20did%20not%20create%20any%20visualization%20you%20can%20click%20on%20the%20%22Data%22%20Menu%20at%20the%20Top%3C%2FP%3E%3CP%3EFrom%20the%20drop%20menu%20select%20the%20Last%20option%20(Changes%20according%20to%20the%20Tableau%20File%20active)%20%26gt%3B%26gt%3B%3C%2FP%3E%3CP%3EFrom%20the%20Submenu%20%26gt%3B%26gt%3B%3C%2FP%3E%3CP%3ESelect%20Vie%20Data%20%26gt%3B%26gt%3B%3C%2FP%3E%3CP%3EA%20window%20will%20open%20showing%20all%20the%20Source%20Data%20%26gt%3B%26gt%3B%3C%2FP%3E%3CP%3EIn%20the%20Upper%20Right%20corner%20of%20this%20window%20%26gt%3B%26gt%3B%26nbsp%3B%3C%2FP%3E%3CP%3EClick%20%22Export%20ALL%22%20%26gt%3B%26gt%3B%3C%2FP%3E%3CP%3EThis%20will%20give%20you%20the%20option%20to%20Export%20to%20a%20.CSV%20file%20which%20can%20be%20opened%20in%20Excel%3C%2FP%3E%3CP%3EHope%20That%20Helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879784%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Get%20Data%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879784%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3BI%20am%20trying%20to%20automate%20this%20process.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Etronson
New Contributor

Is there a way to use Excel's Get Data function to connect to a Tableau server workbook to pull data into an Excel workbook? I do not want to manually export from Tableau into Excel.

6 Replies
Highlighted

This is a good article but does not fully automate the data pull.@Sergei Baklan 

Highlighted

@Etronson 

Power Query has no built-in connector to Tableau, thus only third party solutions like this.

Highlighted

@Etronson 

Hi

If you created any visualization in Tableau, then

Right click that visualization

Select Copy Data

Paste it into Excel

Hope that helps

Nabil Mourad

Highlighted

@Etronson 

Hi again,

If you did not create any visualization you can click on the "Data" Menu at the Top

From the drop menu select the Last option (Changes according to the Tableau File active) >>

From the Submenu >>

Select Vie Data >>

A window will open showing all the Source Data >>

In the Upper Right corner of this window >> 

Click "Export ALL" >>

This will give you the option to Export to a .CSV file which can be opened in Excel

Hope That Helps

Nabil Mourad

Highlighted

@nabilmourad I am trying to automate this process.

Related Conversations
Please Help debug my matrix formula
Katharina_Stemmer1989 in Excel on
0 Replies
Linking external source (eg Share Price) to a cell
Aitch1964 in Excel on
0 Replies
Insert an image in Excel header
mat74 in Excel on
1 Replies
DAX Powerpivot - How to solve this problem in PowerPivot
kayyeah11 in Excel on
0 Replies
IF statements and conditional formatting
clare1981 in Excel on
1 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies