community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Downloading ".xlsx" file from Dropbox

Highlighted
Atom

Hello,

I have been trying to download ".xlsx" file from the dropbox directly into Alteryx. However, the "downloaded data" does not show the data. When I output it to a file, it shows the file to be corrupted. I use the "text input" tool and then the "download" tool. My workflow works for online csv files. However, it is not working for ".xlsx" files. Please advise. Thank you.

Alteryx
Alteryx

Hi @SPATKAR

 

I think this will be due to an XSLX file being encoded. Excel files are actually XML files contained within a zip file: http://professor-excel.com/xml-zip-excel-file-structure/

 

This will be what is download in the download data rather than it being a more straight forward format like .csv.

 

If you are looking to use Dropbox and have a lot of Excel files I would recommend using the Dropbox desktop client like mentioned in this post here

 

Thanks

Joe

Meteor

Hi @SPATKAR ,

 

Can you explain how you accessed the file via dropbox without having it synced to your desktop? I am not trying to access .xlsx files so your solution may work for me.

 

Thanks,

Paolo

Labels