Export in CSV is broken with multiline notes?

[e4rthdog]

Export in CSV seems to have problem in general. Many of my vault items have multiline notes. when i export to CSV the file is messed up.

I want to have a password protected PDF with my vault items and in order to do that i need to get the vault items somehow.

Any ideas?

[stefan0xC]

when i export to CSV the file is messed up.

As far as I've tested it the lines inside the the multiline notes have only line feeds (\n) (and are also escaped in double quotes), while the csv rows end with a proper CRLF (\r\n) (cf. RFC 4180). So it might just be an issue with the way you view the files?

If you run cat --show-ends bitwarden_export.csv it should look like this:

folder,favorite,type,name,notes,fields,reprompt,login_uri,login_username,login_password,login_totp^M$
,,login,test,,,0,,user1,password1,^M$
,,login,test,"line 1$
line 2$
line 3",,0,,user2,password2,^M$
,,note,test note,"line 1$
line 2$
line 3",,0,,,,⏎

[e4rthdog]

Yeah i think it looks like you say:

I am opening this via Excel. It should work , i will look into getting Excel to properly import it.

[stefan0xC]

I've only tested with LibreOffice where you can set the string delimiter when importing CSV. Not sure about Excel.

[e4rthdog]

Just checked it. Excel is workign ok if you go from the Data menu and not the import wizard.