Tableau Tip: Quickest way to get a table into Tableau from Excel

In this post I will be explaining how we can quickly copy a table from Excel into Tableau to perform ad-hoc analysis.

1) To begin, we need a table in Excel.

tablefromexcel

2) Copy the table then navigate to Tableau and simply press Ctrl+V to paste the table into your view. We now have the same table in Tableau to start some ad-hoc analysis.

tablefromexcel1

3) Create a new worksheet. Double click on Country, drag and drop Sales onto Color and change the color palette to Red-Blue Diverging, Reversed. MAGIC! Why view your sales by country in a table when you can see it on a map!

tablefromexcel2

 

Author:
Hashu Shenkar
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab