Commas in passwords in imported csv

Ask the Community Password Manager
,
1

Hi,
I imported my passwords as CSV file to Bitwarden, but some of them contained commas.
They were written in a “Secure,Password” way and still they were imported as folders instead of password data.
How can I solve this issue?
Thanks a lot

EDIT
Here’s an example:
folder,favorite,type,name,notes,fields,reprompt,login_uri,login_username,login_password,login_totp
,login,bitwarden.com/,,,0,https://www.bitwarden.com/,Username1234,“Secure,Password”,

First comma does not show. Before “login,bitwarden…” are 2 commas

EDIT2
I have just a few entries with this issue so this is my solution.

2

If you have just a few, the fast way is to remove the commas and manually fix those entries after the import.

If you lave a lot, make sure you are using normal ascii double quotes, (") and not the 66 99 quotes in your posting. The CSV spec requires normal double quotes (acsii character 34 decimal, 0x22 hex).

3

The strange thing is that I exported this file from an old Bitwarden account to move to a new one. File was edited in Excel, but I checked it sould be okay.
There are just 20 entries with this issue, so I’ll just do it manually.

Thanks a lot

1 Like
4

      

5

@XedanOlin Welcome to the forum!

Sorry I did not have time to get to this in time, but glad that you found a work-around.

If I add back the missing comma, and change the “curly quotes” into straight quotes ("), then the .csv file looks like this:

folder,favorite,type,name,notes,fields,reprompt,login_uri,login_username,login_password,login_totp
,,login,bitwarden.com/,,,0,https://www.bitwarden.com/,Username1234,"Secure,Password",

 

When I import this .csv file using the "“Bitwarden (csv)” format, then the password (and all other information) is correctly imported:

image
image344×179 2.96 KB