Downloading Excel File from a URL and using the data

[msve]

Hello,

I created below workflow to download data from a website. Can I use the same workflow to read the file and use that data? 

Thank you.

[LordNeilLord · Accepted solution]

Hey @msve 

You absolutely can!! This is one of my favourite tricks in Alteryx.

You can save the file as a temp file and then read it back in using dynamic input.

I've attached the example

[msve]

Awesome. Thank you so much.

[luisangelico]

Hi, If I change the URL to mine, isn't it supposed to work?

I got this error when I do it:

I'm trying to download this file:

https://www.tesourodireto.com.br/data/files/EE/E3/A1/59/6266F610BB8E41E6894D49A8/LFT_2019.xls

[SHoughton]

Hi,

I am having a similar issue, but I guess the issue is due to it being an Xlsx file that I am downloading.

Maybe it only works with CSV files. Did you find a workaround?

[SHoughton]

Hi, Hope this helps anyone wanting to download Excel files from a URL.

The file below allows for XLSX files, XLS files and CSV files to be downloaded (a different technique for each).

CSV method is the one LordNeilLord suggested.

XLS method uses the link luisangelico provided

XLSX method uses a link I was struggling with (Note if seeing the example on this bear in mind it will take 2 minutes to run as a massive file size)

Hope this helps some people wandering to the page and if it does, please give me a like. I have been racking my brain for the last Week and eventually found a solution 🙂

Stephen.

[blacksoda]

this worked!! Awesome job, SHoughton! 

[Raj_007]

Hi, when i tried to run this workflow which saves a file to the local - this is not erroring when i run it in alteryx server

[BobSnyder85]

I appreciate this so much that I reset my password, and fought w/ password requirements for 5 minutes, and still came back to log in and find this and upvote it! Thanks!!

[pmaier1971]

Extremely useful tip. One addition: When used on a server, a "Block Until Done" may come in handy...