- Suppose you have a table in Excel and want to show it in a visualization in Tableau

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

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

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

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

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