QuestionHow do I transfer my saved password from Norton to the Webroot Password Manager?
AnswerRemember to save a backup copy of your CSV file before you begin!
These instructions are for converting a Norton Password CSV file to a Webroot Password CSV file using Microsoft Excel 2010. Users of other Spreadsheet programs may need to alter the directions to suit that program, but hopefully this explanation and the included screen shots will help aid you in getting through it. The same type of conversions should also work when converting files of other products.
You may need to add or remove certain data columns while in spreadsheet mode to match the desired end format.
There may be other solutions that use a format other than CSV - in which case you may need to adjust the directions to use a different character between data entries.
NORTON CSV Data Format Example:
WEBROOT CSV Data Format Example:
Export your Norton file to a CSV and open the file using Notepad. Compare the data to that of the Webroot sample above. You will see how the first line has some of the words in different positions. These, and the corresponding data in the rest of the lines, need to be moved to match the order of the Webroot format.
Norton has an extra comma (,) at the end, as well as quotes (") at the beginning and end of each data line. With the CSV file in Notepad, do the following:
Click Edit, and choose Replace
Replace " (the quotes mark) with a blank value by leaving the bottom blank empty.
Click Replace All
We'll now deal with the extra comma. Add another item to the top line that defines the columns called "delete". Remember to put a comma between "extra" and "delete."
Save the file and close Notepad.
Open Microsoft Excel 2010 and create a new spreadsheet.
It's now time to import the Norton data we just saved. In Excel, click the "Data" tab at the top, and then the "From Text" button. This will open the Import Text File box. Select "File Type: ALL FILES" and then the Norton CSV file we saved in Notepad.
An Import Wizard should open. In Excel 2010, select "Delimited" and then click next.
On the next screen of the wizard, select only Comma. The data preview at the bottom should change to be columned, with the correct data under each column title. Click Next.
The last screen of the Import Wizard for Excel 2010 you can select which data format to be used in each column. Simply leave this as the default "General" and click Finish.
A small pop-up will ask into which data block to insert the data. You want set it for A1. You can do this by simply clicking on the A1 box and then clicking OK.
You now have the Norton data imported into Excel.
For each column that is in the incorrect placement position for the Webroot formatting, you will need to move the columns around via copy and paste. In this example, in order to match the Webroot formatting, the fourth column "name" should be moved. Right-click on the column label (D in the example) and choose copy.
Right-click on an empty column, and hover your mouse over Paste Options, and then choose the text icon.
The data is now contained in what was the empty column.
To clear the data from the original column, right-click the column label (in this example, D) and select Clear Contents.
Continue moving the columns until you have all of the columns in the correct placement for the Webroot format. Add any additional columns needed, such as "fav" in this example. Since the default value is "0" for "fav," fill in the column entries with 0's.
It is now time to export your work to a new Webroot-compatible CSV file. Click File, and choose Save As. In the Save As dialogue box, change "Save as Type" to "CSV (Comma Delimited)" and name your file. Click Save.
It is possible you may receive some errors during saving your Webroot CSV file. Simply click OK or YES to all of them. (It is OK to lose the spreadsheet formatting since we are changing to a CSV file anyway!)
Your file is now ready to be imported into Webroot via either the toolbar or the online console.