When importing logins from another password manager into Cloaked using the Password Manager Importer, you may encounter an issue with commas in your CSV file causing errors. This problem occurs when a string containing commas is not properly enclosed in quotes. This can cause issues in the import process. This article will guide you on how to resolve this issue.
Identifying Problematic Commas
Problematic commas can cause issues when importing a CSV file because they might be mistaken for field separators. To identify problematic commas, look for any instance where a comma appears within a field but is not surrounded by quotes.
Online Account,firstname.lastname@example.org,password,This is a note, with commas
In the example above, the notes field contains commas that are not surrounded by quotes. This will cause the import process to interpret the notes field as multiple fields, leading to errors.
Fixing Problematic Commas Using Excel or Google Sheets
To fix problematic commas in your CSV file, you can use Excel or Google Sheets. Follow the steps below:
- Open your CSV file in Excel or Google Sheets.
- Locate the cells containing problematic commas.
- Edit the cells to include double quotes (") around the entire text, including the commas.
- For example, change the cell value from This is a note, with commas to "This is a note, with commas".
- Once you've fixed all the problematic commas, save the file as a new CSV:
- For Excel: Click on "File" > "Save As" > Choose "CSV" as the file format.
- For Google Sheets: Click on "File" > "Download" > Choose "CSV" as the file format.
Now that you've fixed the problematic commas in your CSV file, you can proceed with importing it into Cloaked using the Password Manager Importer.