📑 How to Generate a List of Passwords in Google Sheets

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.