Mautic Community Forums

Import contacts with Excel files (next to CSV files)

My idea is:

Currently, it’s only possible to batch import contacts using CSV files. Would be great if we could make it happen to also let people import using Excel files. Since Mautic already has PhpSpreadsheet as a dependency (which supports both CSV and Excel files), it should be feasible to also support Excel files for imports.

I think these groups of people would benefit from this idea:

Non tech-savvy people using Mautic (currently we have to export Excel files as CSV files to do imports)

Why I think they would benefit from this idea:

It lowers the barrier to do mass imports

Any code or resources to support this idea:

PhpSpreadsheet: https://phpspreadsheet.readthedocs.io/en/latest/
No code yet, I’m just putting this here so that I can work on it when I have some time

Are you willing to work on this idea?:

Yes

What skills and resources do you need to explore this further?

Just need to know whether the current import process uses PHP’s native CSV functions to read the CSV files for imports, or whether it uses PhpSpreadsheet already. This will determine the path for moving forward on this issue.