Can I get reports sent in XLSX format?

Forum|Forum|11 years ago
December 19, 2014
4 replies
1802 views

Tableau (via Mac) is starting to phase out XLS as a data source, meaning I have to open the files and save them as XLSX. This is a huuuuuge headache when updating 100 reports once a week.

Any solution to this that's not a crappy work-around?

Thanks,

-Brendon

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by

So I had one of my engineers write a bash script to automatically convert the files for me when they come in. Problem solved!

A

Anonymous

Hey Brendon - How are you getting data into Tableau? Only Export/Import?

A

Anonymous

I believe that's the only way I know how to do it. Now getting them sent to me once a week via the subscriptions tab, then copying into my Tableau Workbooks folder, but it still sends them as XLS, which is a headache when you're dealing with 56 reports.

Thanks for the response,

-Brendon

A

Anonymous

You can theoretically use SOAP/REST to extract the data directly. There are services out there who claim to do it, but my internal people say it is really easy to do yourself.

A

Anonymous

Thanks - I'll dig through the Marketo API docs to see if there's a way to directly connect. Is it safe to say there's no way to get the reports in XLSX? Anyone know why such an advanced software still exports in XLS?

A

Anonymous

Accepted solution

So I had one of my engineers write a bash script to automatically convert the files for me when they come in. Problem solved!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded