Chat with us!

Chat Widget available in the bottom right

Fixing Common Problems When Importing: Unescaped Commas in CSV Files

Lucas
Lucas
  • Updated

 

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,johndoe@example.com,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 to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.