Knowledge Base

How to convert a Norton Passwords CSV file to a Webroot Password CSV file

How to convert a Norton Passwords CSV file to a Webroot Password CSV file
Userlevel 7
  • Retired Webrooter
  • 2146 replies

Question

How do I transfer my saved password from Norton to the Webroot Password Manager?

Answer

Remember 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:
url,username,password,name,grouping,extra,delete
"https://www.url.com/,noone@yahoo.com,password,name,grouping,extra,"
"https://www.url.com/,noone@yahoo.com,password,name,grouping,extra,"
"https://www.url.com/,noone@yahoo.com,password,name,grouping,extra,"

WEBROOT CSV Data Format Example:
url,username,password,extra,name,grouping,fav
https://www.url.com/,noone@yahoo.com,password,extra,name,grouping,0
https://www.url.com/,noone@yahoo.com,password,extra,name,grouping,0
https://www.url.com/,noone@yahoo.com,password,extra,name,grouping,0

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.
 
Click IMPORT.
 


 
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.

3 replies

Userlevel 7
Badge +33
What ProTruckDriver touched on is correct, and we will update these relevant articles once the new product is completed and ready to go.
Userlevel 7
Hello @Ausgrah, Welcome to the Webroot Community Forum. :D
To me this looks like an outdated KB Article and if it isn't Webroot is in the process right now of updating their Password Manager and should be completed next month. Hopefully there will be a tool of some sort to Export Norton's passwords to Webroot and you won't have to go through the above steps. I'll ping some of the Webroot employees to confirm this. @freydrew @LLiddell
Hi
I just read all the crap you have to do to import from norton csv file
your product
You must be joking if you want me and others to use Webroot 
You need to develop a fix this so it can pick up the back up of norton password manager 
on install then delete Norton
or get your product to recognise the Norton CSV file without the need for all the cumbersome stuff up topasap

Reply

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept or continue browsing you agree to our cookie policy. Learn more about our cookies.

    Accept cookies Cookie settings