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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Inport Excel password protected files

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

30 Comments
Alteryx Certified Partner

Hit this today with a new client, would be very helpful.

 

Thanks !

Atom

We are looking to use Alteryx to consolidate some 900+ .xlsx files on a monthly basis, all the files are password protected, as they can contain Personal Identifyable Information (PII) and this is a minium standard we apply for such data.

Can someone at Alteryx please get back to us asap, to let us know if and when the ability to unprotect a xlsx (or xls) within a workflow will be made available?

 

We would also welcome the ability to create .xlsx (and .xls) and password protect these files from with a workflow.

 

We would be happy to be a beta tester for this function.

 

Thanks in anticiation.

Rob

Asteroid

Great to have this function in the coming version upgrade.

 

Best Regards,

Samuel

Atom

Hi Samuel,

Which specific version are you referring to?

 

Thanks

Rob

Alteryx
Alteryx
Status changed to: Not Planned

Hi All,

 

After doing some research on this, we have determined that it's very difficult to implement due to security concerns. At this time, we will not be implementing this.

 

Best,

Alex

If the password is any longer than 4 characters and more than just a dictionary word, good luck, I hope you have a patient attitude, because it can take weeks of brute force dictionary attacking, like iseepassword: https://www.iseepassword.com/recover-ms-excel-password.html

 

Even utilising some dodgy software that can use a high end GPU for raw number crunching. Id suggest if its not ultimately business critical, slap the user and tell them you'll learn next time to NOT forget it. Brutal but necessary, you really don't want to be pulled into this kind of task, its painful.

Atom

 hi Alex,

Is this functionality ready for use? If not, when is it expected to be released?

 

Thanks

Abi

 

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

Asteroid

Unfortunately, they recently announced that it won't be possible to add this functionality to Alteryx:

 

After doing some research on this, we have determined that it's very difficult to implement due to security concerns. At this time, we will not be implementing this.

There are ways to get around it, for example I have called a macro from Access but it's a shame we can't get it done internal to Alteryx.

Alteryx Certified Partner
Alteryx Certified Partner

https://gallery.alteryx.com/#!app/Input-Password-Protected-XLSX/5a9d23a7826fd31b1c2826ea

 

I have developed the above macro to allow users to input password protected xlsx files. The security concerns are valid because in the background a un-password protected file is temporarily created in the background, though it is deleted immediately once alteryx has successfully inputted the data.

 

But if you want a workaround then here you go Smiley Happy

 

It's not been tested strongly yet so feedback appreciated.

Last comment is a little over 3 months old, do we have any updates on this?

In addition to excel, I'm getting questions regarding using encrypted databases.

 

thanks for the sustained effort in getting this,