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

Not what you are looking for? Ask the experts!

Kudos0

Vault Export Report

Hey guys, I created a google sheets script file that formats the password vault csv export file into a readable format.  I don't know if this is appropriate for this forum or not, but I could post the code if anyone is interested and might want to develop the code a little further.  

Replies

Kudos0

Re: Vault Export Report

It is not acceptable to post executable or script files on the forum. The .CSV file is readable in it's native format. You just need to choose the correct delimiter setting in the spreadsheet program you use to open it.

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

Re: Vault Export Report

No problem, I thought it might not be in scope of the forum, that's why I asked first.  For me I wanted to get to a 'finished' report format easily, but yeah I can massage the csv file manually.  Incidentally, I couldn't read the csv file directly into excel or sheets without first replacing all the commas with tabs using notepad++.  This was an issue with the Notes part of the archive which have embedded line breaks in each record.


 

Kudos0

Re: Vault Export Report

When I open the .csv file in Excel, there is a dialog box that asks how the file was formatted. I chose comma delimited and it opened fine. No massaging of the original file needed.

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

Re: Vault Export Report

It's the Notes portion of the archive that's a little fussy.

Kudos0

Re: Vault Export Report

I guess if you have commas in your notes it could mess up the formatting for Excel.

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

Re: Vault Export Report

I created a test note that produces the following csv file,

url,username,password,name,grouping,extraCRLF
http : // sn,,,my_note_title,,"my_text1LF
my_text2LF
my_text3"CRLF

The three text items, my_text1, my_text2, my_text3 should end up under the 'extra' heading (column F in Excel) in one spreadsheet cell, that's what the LF line breaks are calling for.  If you replace all the commas with tabs and double click the file to open it in Excel ( or alternately copy paste into Excel) that is what you get.  

But, if you double click the original csv file (with the commas), text1, text2, text3 end up on separate lines.  And if you parse the data with 'Text to columns', my_text1 ends up under column F while my_text2 and my_text3 end up under column A.

Just sayin'

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