πŸ“‘ How to Generate a List of Passwords in Google Sheets

Bookmarked How to Generate a List of Passwords in Google Sheets (InfoInspired)

You can use my formula to easily generate a list of passwords in Google Sheets. The passwords will be a mix of alphanumerics and special characters.

Prashanth Kv breaks down the process for creating a strong password in Google Sheets. This breaks down all the various steps, such as random letters, upper and low case, as well as special characters,Β  in the creation of a formula.

=ArrayFormula(vlookup(mid(A2,2,1),Sheet2!$A$2:$B$27,2,0)&JOIN("",char(if(ISEVEN(code(split(REGEXREPLACE(LOWER(A2),"(.{1})", "$1,"),","))),code(split(REGEXREPLACE(LOWER(A2),"(.{1})", "$1,"),","))-32,code(split(REGEXREPLACE(LOWER(A2),"(.{1})", "$1,"),",")))))&vlookup(right(A2,1),Sheet2!$A$2:$B$27,2,0)&right(text(B2,"mmm"),1)&mid(text(B2,"yyy"),2,3)&day(B2))

Alternatively, Zak Kolar created an add-on for Google Sheets that generates passwords in a similar style to DinoPass.

This could be useful when generating/managing bulk account/password creation.

Leave a Reply

Your email address will not be published. Required fields are marked *