PWM Import

Fixing Common Problems When Importing: Unescaped Commas in CSV Files

Last updated:

April 24, 2023

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.

Name,Email,Password,Notes
Online Account,[email protected],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:

  1. Open your CSV file in Excel or Google Sheets.
  2. Locate the cells containing problematic commas.
  3. Edit the cells to include double quotes (") around the entire text, including the commas.
  4. For example, change the cell value from This is a note, with commas to "This is a note, with commas".
  5. Once you've fixed all the problematic commas, save the file as a new CSV:
  6. For Excel: Click on "File" > "Save As" > Choose "CSV" as the file format.
  7. 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.

Related Questions and Issues

  1. How do I import a CSV file into Cloaked?
  2. What fields should be included in the CSV file for a successful import? {{link to article about required CSV fields for import here}}
  3. How can I fix common problems when importing, such as incorrect file types?