Copy data from a website to create a data connection in Tableau

Sometimes for quick data analysis,

Data can be copied from a website and pasted  in Tableau desktop.

When data is pasted in Tableau desktop, Tableau will create a new Clipboard datasource. Once the workbook is saved, this data source will be saved as a text file in My Tableau Repository.

  • Data can also be pasted from other applications such as MS-Excel or MS-word.

Creating Data Source connection from Clipboard

To explain this concept, I will use the data table mentioned on Candystore.com 

The data gives, for each State, the Top Candy and Pounds sold, 2nd Place Candy and Pounds sold and 3rd Place candy and Pounds sold.

Most Popular Halloween Candy State-by-State

1. Navigate to  Candystore.com and copy the data in the table provided for popular halloween candy by states.

2.  Navigate to Tableau workbook, for this exercise, I will use the workbook in created in the previous article What Halloween Candies to buy 

3. In Tableau workbook, navigate to menu – Data and select Paste

 4. Tableau will create a new datasource with the pasted data. Field names F1,F2,F3 etc. are generic and can be renamed appropriately.

Tableau will also create a new Sheet automatically displaying the data.

5. I will rename the columns appropriately. Snapshot of my data in the view will appear as

Now I can do some analysis on this data, to find the consumption of these three categories of candy by State.

 

Once this workbook is saved, a dialogue box will popup showing the location where this datasource is saved.

 

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.