[Solved] Transfer Lastpass data to Bitwarden via CSV

[barryb1717]

I have last pass free, bitwarden free and open office (for spreadsheets). I'm using windows 10 64 bit on a desktop.

I'm trying to export my last pass data and import it into bitwarden password manager.

Every time I export my lastpass data into open office, and try to save the file as a text csv file, I get a warning message in open office that says:

“This document may contain formatting or content that cannot be saved in the text.csv file format. Do you want to save the document in this format anyway? Use the latest ODF file format and be sure all formatting and content is saved correctly.
(my choices are 'keep current format' or 'save in ODF format')”

When I keep the current format and try to import the file into bitwarden using “lastpass (csv)” I get an error message saying the data is not formatted correctly.

I have tried to convert the file from .ods to text csv using a third party app and that did not work either.

I have far too many passwords to manually enter them into bitwarden.
How can I fix this?
Thank you.

[John_Ha]

Save it as fred.csv choosing commas as your separator. Open fred.csv with Notepad and you should see something like below, where text is separated by commas

Code: Select all

Username,Password
Tom,apples
Dick,pears
Harry,MyPassword

Tick Quote text cells..., if you want text quoted.

[DiGro]

Could be that Calc is exporting with delimiter Tab instead of , (comma)

Bitwarden is expecting a comma in this format:

Code: Select all

url,username,password,extra,name,grouping,fav
http://Yahoo,j.smith,,,My Yahoo,,0
http://Google.com,googleuser,1234,,Google,,0

They have also a warning about converted characters:

Warning

Some users have reported a bug which changes special characters in your passwords (&, <, >, etc.) to their HTML-encoded values (for example, &) in the printed export.

If you observe this bug in your exported data, use a text editor to find and replace all altered values before importing into Bitwarden.

Source: https://bitwarden.com/help/article/impo ... -lastpass/

Open the .csv you have in OpenOffice by double clicking it.
It will open in Writer and show you an Import dialog.
Check if the delimiter is set to Comma, otherwise change it.

[Bill]

Export the .csv using the options in Last Pass, then import the same .csv using the options in Bitwarden. OpenOffice shouldn't be involved in this process at all.

[John_Ha]

Upload a few lines of the .csv and .ods files for them to be analysed. Change some non-contentious characters (digits, letters) so as not to reveal your usernames or passwords.

fred.csv was created from fred.ods.

NB - the warning you get is correct - .csv is a very limited file format intended for data interchange and not for saving a proper spreadsheet file.

[Villeroy]

csv is not a file format. It is all about conventions on how to wrap a database row set into a plain text file. There are thousands of different ways to generate valid csv files from the exact same data.

https://bitwarden.com/help/article/cond ... en-import/ describes the requirements for valid csv that can be imported into bitwarden.
UTF-8 encoding is mandatory
Columns are separated by commas.
Strings that may include commas are in double-quotes.