CiviCRM 5.20.2/WP:

My system is using german locale. The contact import does not offer german date format "dd.mm.yyyy", even it is set for birth class in the date settings (dd.mm.yy).

How can I get german date format dd.mm.yyyy supported in the contact importer?

The contact import page only offers these date formats:

  • yyyy-mm-dd OR yyyymmdd
  • mm/dd/yy OR mm-dd-yy
  • mm/dd/yyyy OR mm-dd-yyyy
  • Month dd, yyyy
  • dd/mm/yy
  • dd/mm/yyyy

1 Answer 1


Maybe, the easiest way is, to open the csv in Excel (or LibreCalc) and do some magic with formulas?

Something like


Or even much easier: Open the file in Excel (or LibreCalc) and do some search and replace in the column?

That's the way I would do it, if the file isn't to big for Excel and it isn't a work I had to do every day.

  • I think there is a simpler workaround of just changing the format of the dates to dd/mm/yyyy then saving as csv
    – Mick Kahn
    Dec 31, 2019 at 10:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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