Forum Discussion
Suggestions on how to remove duplicate user id/passwords/notes from different sources?
I have 1Password (the free version) and Roboform. It's just too time-consuming to go through 900+ passwords. That;'s why I am looking to automate the process. I hope to hear back from you.
I'm going to refer you to two different web sites to learn UNIQUE. I do see that 1Password (full version; I can't speak to the free, whether this applies or not) DOES allow you to import CSV files. You could export from Excel, once cleaned up, as a CSV.
Here's a good reference for all things Excel: https://exceljet.net/excel-functions/excel-unique-function
Here's a good video introduction to UNIQUE and a few others. This may be beyond your skill level, but try to stick with it. The truth is that UNIQUE in particular is quite easy. https://www.youtube.com/watch?reload=9&v=9I9DtFOVPIg
When I talked of combining, I was simply pictuing copying from one (the smaller) into the other, larger. Make sure the columns are aligned in the same way.
(If we were sitting down face-to-face, I'd be happy to give more detailed instructions based on where you are in your own understanding, but that's next to impossible over once-a-day message board exchanges. So if you need more, see if you can find a friend who knows a bit more about Excel. This is not rocket science. The best thing for your own learning is to work through it. Make back-up copies first so you don't break something and not have a recovery plan.)
mathetes Hi. Thanks for replying. I took a look at those sites with the UNIQUE Function. It's good for extracting data.
From what my little brain can determine. I would need to copy the userid and pws from Chrome into the appropriate fields of Bitwarden's (BW) template. Chrome has the most current info. Unfortunately, Chrome does not have most of the fields BW has.
I would then need to sort everything in Excel by website and then somehow have Excel remove the older passwords plus the duplicate cells while preserving the notes field. Once that is done, save the CSV file and import into BW.
I choose not to use 1Password because the free version is limited, but it's good to store a backup once things are current.
Sadly, I lack the skill level to accomplish what I need to do, I also don't have the aptitude beyond basic sorting within Excel. I wish I could dissect or structure what I need to be done like a programmer could. Unfortunately, my mind just doesn't work that way.
The workaround I will do is create another folder within BW and import my Chrome userid and pws into that. When I come to a website that needs my credentials, I will be prompted with multiple userid and pw options until such time BW or another password manager has duplicate removal features added. I will continue to update my Chrome pws and then delete the special folder in BW and import my Chrome pws there, rinse and repeat. So much for merging.
As such, I think I have no choice but to give up trying to clean things up.
Thank you for your insight. Take care and stay safe.