Aug
22
Embedding Excel in Tableau
After writing Embedding Powerpoint in a Dashboard, I figure that we can embed Excel in Tableau too.
The technique presented here gives the widely used Excel a new twist within Tableau framework. So, you can imagine that your Tableau charts and Excel charts cohabit side by side.
The key is to use Google Docs/Sheets as a proxy. Namely,
- upload your Excel file to Google Docs
- extract the file widget URL (for publishing or for collaboration)
- add the URL to a web object in dashboard
Note that, depending on your purpose, the URL is different for publishing or for collaboration. Publishing is for the whole world to see. In collaboration mode, you can set up permissions to allow only a few of your trusted parties to view or even edit.
The technique presented here gives the widely used Excel a new twist within Tableau framework. So, you can imagine that your Tableau charts and Excel charts cohabit side by side.
The key is to use Google Docs/Sheets as a proxy. Namely,
- upload your Excel file to Google Docs
- extract the file widget URL (for publishing or for collaboration)
- add the URL to a web object in dashboard
Note that, depending on your purpose, the URL is different for publishing or for collaboration. Publishing is for the whole world to see. In collaboration mode, you can set up permissions to allow only a few of your trusted parties to view or even edit.