I am attempting to import a csv file that is both regular comma delimited and I have also tried one saved as CSV UTF-8 (Comma delimited). Each time I go through the steps, I get through the match fields correctly. When I get to Step 3 Preview, I am told that my total number rows have errors and won't be imported:

  • 4
    Hi James - it would be v helpful if you downloaded your errors and then pasted an example of the problem that will be reported in the csv
    – petednz - fuzion
    Nov 8, 2018 at 22:26
  • 1
    Also, the Birth Dates look incorrect - just a number and not formatted
    – Andy Clark
    Nov 9, 2018 at 12:57
  • I hope that the screenshot isn't real data about individuals. If it is I would recommend that you delete this screenshot and make sure that you obscure any personal data from future screenshots. Nov 9, 2018 at 16:46

1 Answer 1


Without seeing some of the actual file that is being imported, it is hard to say for sure. But my guess is that birth date field is an actual date field? And if so, it needs to be formatted as a date and on the first import screen you have to tell Civi how it is imported.

The error file that you can click and download will give you more information, as it will tell you what field(s) are the problem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.