Reports extracted from Salesforce are in HTML format, even though they have an .XLS extension.
How can I open these in Tableau without having to first open them in Excel and save as .xlsx ?
While I haven't used Salesforce as a datasource, I do know that other users have has success in creating extracts using html data sources by using the Tableau Data Extract API.
It might take a bit of building but it could end up being a nice automated solution. Here is more info:
Tableau Data Extract API
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...