CSV Import Isn’t Working As Expected

< All Topics

1. Stray Commas

The first, most common problem is a CSV file that has a few commas (such as Don Martin, Jr).

Because the import is looking at commas as the delimiter it sees the fields with commas as two fields and doesn’t know what to do with them. You can just remove the commas as I did in the attached version, or you can change the delimiter to another character and manually set that character on import.

2. Mixed Contact Types

Another thing to watch out for is that you import all individuals in one file (and make sure the import Contact Type is set to Individual). Then import all organizations separately, with the appropriate Contact Type.

Import Delimiter and Contact Type