Set Up the Excel File
Open Excel or a Google Spreadsheet and create three columns; Login, Email, and Password.
Enter the email addresses in column B, and the passwords in column C, starting with cells B2 and C2. Then, enter this Concatenate formula in cell A2:
=concatenate(b2,":",c2)
The result will look like this:
Next, drag the formula down, or double click the lower righthand corner of cell A2, or copy and paste the formula down the length of column A until all the cells in column A are filled with an email address and password combination:
Copy the email address and password combinations from Column A (do not copy the column header) and paste into the Import Logins box:
Click Import Logins, and you’re done! You will receive an email with the results of the import shortly after submitting it.
Related Articles
Check out these other articles in the Privacy and Password Protection section: