I am trying to move from Norton to Bit Warden but after exporting my csv file I get this error message “Data is not formatted correctly. Please check your import file and try again.”
I went to the forum and found this …
If you have both a Title column and a Login column in your .csv export, choose which you want to use as the names of the entries in in your Bitwarden vault, and delete the other column (but if it seems that the other column contains important information that should not be deleted, please request further assistance). Make sure that the column is fully deleted (i.e., not just cleared, leaving behind an empty column).
Modify the column titles of your .csv file, by making the following changes in the first row (copy and paste the new column titles from the list below, so that you don’t introduce any typos):
Change Username to login_username (all-lowercase);
Change Password to login_password (all-lowercase);
Change Login or Title (whichever you didn’t delete in Step 1 above) to name (all-lowercase);
Change URL to login_uri (all-lowercase);
Change Notes to notes (all-lowercase);
Starting in the first empty column (which should be the 6th column after completing Steps 1-2), create six more columns, by entering the following column titles in the first row of your .csv file:
In Row 1 of the 6th Column, enter folder (all-lowercase);
In Row 1 of the 7th Column, enter favorite (all-lowercase).
In Row 1 of the 8th Column, enter login_totp (all-lowercase);
In Row 1 of the 9th Column, enter fields (all-lowercase);
In Row 1 of the 10th Column, enter reprompt (all-lowercase);
In Row 1 of the 11th Column, enter type (all-lowercase).
For each row (starting at Row 2), enter the value login (all-lowercase) in the column named “type” (11th Column).
After you made the changes to the file, did you save it in .CSV format, or did the file get converted to .XLSX or .TXT format? If the latter, re-open the file, and use the “Save As” function to save a copy in .CSV format.
When you import the file, what do you select for the “File Format” option? You must select “Bitwarden (csv)”, as shown in the screenshot below:
If neither of the above suggestions fixes your issue, then it is possible that one or more of the rows in your .CSV file contains some corrupt or incorrectly formatted data. Start by visually scanning through the spreadhsheet, and checking if any rows stand out as looking different. If you find anything suspicious, then delete those rows (make a copy of the file first, in case the deleted rows contain important information) and try the import again; when deleting, make sure that the rows below the deleted row are shifted up, so that you are not left with an empty row in the middle of the spreadsheet.
If the visual inspection is not fruitful, then try dividing your .CSV file into two halves (ensuring that a copy of the column headers is inserted as the top row into the .CSV file that has the second half of the exported data set). Try to import both files. If one file succeeds and the other one doesn’t, then you will know that the problematic data is located in the file that could not be imported. Now, divide that problem file in half again, and repeat the process. Keep going until you have narrowed it down sufficiently to identify which vault entries are causing the problem.
IMPORTANT: If you are going to use these methods (re-importing after deleting or splitting data), you need to keep track of which vault entries were successfully imported already, and ensure that you do not include those entries in any subsequent import. Importing the same data twice will create duplicate entries in your vault, which are difficult to get rid of later. Of course, if your Bitwarden vault is currently empty, you do have the option of completely purging the vault contents after you have concluded your testing, and then re-importing a sanitized version of your .CSV file.
Thank you your response. In the meantime, I managed to find a work around. I successfully imported my passwords from Chrome, which was connected to Norton. I didn’t know about this option before further research. The data base is slightly different to that in Norton so it will require some manual adjustments, but I was getting so frustrated with the Norton transfer, I thought this is the lesser of two evils. Anyway I have successfully got Bit Warden going - it seems to be much better than Norton - though still a bit of a learning curve. Also thank you for your other warning about data - silly error on my part.
If you have both a
Modify the column titles of your .csv file, by making the following changes in the first row (copy and paste the new column titles from the list below, so that you don’t introduce any typos):
Starting in the first empty column (which should be the 6th column after completing Steps 1-2), create six more columns, by entering the following column titles in the first row of your .csv file:
For each row (starting at Row
Save the .csv file.
