Tableau – How to create a Data Source from the clipboard (Excel)

Share Button

Instead of connecting to Excel, for a quick test, just copy and paste

Share Button
Share Button

  1. Suppose you have a table in Excel and want to show it in a visualization in Tableau
Small table in Excel

Go ahead and copy the data (select the data with left-click mouse hold or with the keyboard) and copy

copy the data from excel (CTRL-C)

3. In a Tableau desktop session, select the Sheet and do CTRL-V (paste). Depending on the pasted data size, it will show a “Processing Request” pop-up window for a while

Paste in Tableau Sheet 1

4. Now the data is showing in Tableau (voilá!)

Same table in Tableau

5. If you click on the Data Source (lower left corner), you see the Clipboard_<> Data Source

Tableau Data Source from c

In this link in the Tableau online help, you have more details about it

Create a Data Source or Add a New Connection with Clipboard Data

Share Button

Leave a Reply

Your email address will not be published. Required fields are marked *