Downloading Excel File from a URL and using the data

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.

Download File.yxmd

Workflow

Best Practices

Download

Accepted answers

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

Download File.yxmd

All comments

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

Download File.yxmd

Awesome. Thank you so much.

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

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

RajkumarVijayan

Hello Fellow Alteryx ians !

Use case,
is there a way to automate download of an excel file from hyperlink in outlook email, which i receive daily from a report provider and save the file into a SharePoint folder?

Any feedback is appreciated!

Thank you!

Best regards,

Raj

Quick Links

Unanswered
Community Events
Groups

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703