Inport Excel password protected files

[carl_bradbrook]

We've had several requests from clients for the ability to import password protected Excel spreadsheets into Alteryx.  Within Alteryx, it would be good to specify the password and inport the file without the need to create an unprotected copy for use in Alteryx.

Thanks

[mikeh_cbre]

Any update on this one?

[r4upadhye]

Under Review -> Coming Soon -> Completed

i guess it may take a few more months

[Joe_Allyn]

This is a great idea!

[ARich]

Hi All,

We are actively investigating adding this and will have more details in the next couple of months. We're hoping to have this by the end of this year/early next year.

Best,

Alex

[Jim7]

Great to hear, thanks Alex!

[RyanNewsome]

+1 

@ARich what is the status of getitng this functionaltiy?

cheers,

Ryan

[ARich]

Hi @RyanNewsome,

The staus of this is still pending. During the work to add support for the .xlsb format, we'll be exploring the effort around importing password-protected files. If all goes well, we're hoping to have password-protected files support by H1 2018.

Best,

Alex

[Jim7]

Great to hear, thanks for the update!

[tracie326]

Question if this enhancement to open password protected files would also apply to using the Directory tool along with the Dynamic Input tool as opposed to the standard Input tool. 

[Dcurwenreed]

Additionally, if this is to be developed, it would be incredibly useful if as well as the main workbook's password protection being dealt with, the ability to enter passwords for individual sheets (with a different password to the main file) would be beneficial too.