• All Community
    • All Community
    • Forums
    • Ideas
    • Blogs
Advanced

Not what you are looking for? Ask the experts!

This forum thread needs a solution.
Kudos0

import an excel spreadsheet csv file

I currently have 100+ passwords stored in an Excel spreadsheet file and am trying to import those into the Norton Identity safe.  I have saved that spreadsheet as a .csv file.  I have the spreadsheet set up with the columns in order listed in Identity safe as if I was adding a new Login (Title, Tag, Login URL, UN, PW) and then saving it as a csv.  But Norton is not allowing me to import this spreadsheet - I keep getting an error message.  Any ideas?  I don't want to spend the time cutting and pasting all of those logins individually! 

Replies

Kudos0

Re: import an excel spreadsheet csv file

What error message are you getting?

 You can try creating one or two logins in ID Safe. Then Export the vault to a CSV file. Then you can compare the columns from that file to the file you have in Excel.

Things happen. Export/Backup your Norton Password Manager data.
Kudos0

Re: import an excel spreadsheet csv file

That was a great idea, thanks for the suggestion.  I did as you suggested (exported a sample from ID Safe) then tried to recreate exactly the same thing with my Excel data.  Still getting the same error message though .  Wish Norton gave more specific info as to the exact file format that is needed.  I am saving the Excel files as comma delimited but that does not seem to work.  

"Error Unable to process the file for import.  Please make sure the file is valid and try again."

Guess I am stuck with hours of manually entering my log-ins.

Kudos0

Re: import an excel spreadsheet csv file

new Norton user If the .csv file is larger than 15MB that is the reason you are getting the error. IF you have a backup in the NPM format you can also try that as well. Follow the instructions here and see if you can accomplish your import. This link is for the "stand alone" tool but should also work in your case as well. Cheers!!

https://support.norton.com/sp/en/us/home/current/solutions/v71133087_identity_safe_standalone_1_en_us

"From DOS to Windows10 what a journey it has been" / MS Certified Professional / Windows 10 Home / Professional x 64 version 1903 / build 18362.295 / N360 Deluxe 22.18.0.213 / Norton Core v.282 on Android 2.00
Kudos1 Stats

Re: import an excel spreadsheet csv file

.npm files were replaced with the .DAT format some time ago. Any current Norton product would not be able to read that format.

I am pretty sure that @yank has figured out the .CSV format. Did you leave a blank line between the headings and the first login entry?

Things happen. Export/Backup your Norton Password Manager data.
Kudos0

Re: import an excel spreadsheet csv file

peterweb I posted that link so as to invoke there is a way to recover older .npm files as well. Thanks for the input. Cheers.

"From DOS to Windows10 what a journey it has been" / MS Certified Professional / Windows 10 Home / Professional x 64 version 1903 / build 18362.295 / N360 Deluxe 22.18.0.213 / Norton Core v.282 on Android 2.00
Kudos2 Stats

Re: import an excel spreadsheet csv file

My csv has this on line 1

url,username,password,name,grouping,extra

Grouping = Tag and I have no idea what extra is but my last field is blank.

Everything is in the A column.

You have to be sure to use all 5 commas to mark fields even if blank.

Hope this helps.

Jim 

Kudos0

Re: import an excel spreadsheet csv file

This post intended only for some background info:

As Jim correctly stated above, my notes reflect:

"The Export format for .CSV is as follows:

url,username,password,name,grouping,extra

Please note that not all are used for all logins.  Grouping and Extra are not used in most cases, but there are two commas behind the name for those subjects."

I'll add the format looks like this:  url,username,password,name,,

Also the .npm format was done away with as peterweb stated, and replaced by the .dat format - neither of which were compatible forward or backward.  IIRC, the .dat format has received another change since then which makes none of the three compatible. 

This thread is closed from further comment. Please visit the forum to start a new thread.