Import and export your customers
Helpium keeps a directory of every customer who wrote to you, from any channel. You can download it to a spreadsheet, and you can load customers from one: your existing contacts, or changes you made in Excel.
Export your customers
Open Customers, click Import / export and choose Export to Excel or Export to CSV. The file follows the list as you see it: if you searched or filtered (marketing opt-in, an attribute, a date), only those customers are exported.
It has one column per customer attribute you defined in Customer attributes, and Helpium's ID in the first column, so you can edit it and import it back.
Import customers
- Click Import / export → Download example for a file with the right columns, or use an export.
- Fill in one row per customer:
| Column | What it is |
|---|---|
ID |
Helpium's id. Leave it empty for a new customer |
Name (Nombre) |
The customer's name |
Email |
Their email |
Phone (Teléfono) |
Their phone, with the country code. Spaces, dashes and + are removed |
Marketing opt-in (Acepta marketing) |
Yes or No |
| One column per customer attribute | Named after the attribute's label or key, for example Locality |
Other columns, like the conversation count or the dates of an export, are ignored.
- Click Import / export → Import CSV or Excel and pick the file.
A row with an ID updates that customer. A row without one creates a new customer, who needs at least an email or a phone. An empty cell never erases what Helpium already knows about a customer, and importing never deletes anyone.
When a row cannot be imported, for example a new customer with an email another customer already has, a window lists the row number and the reason. Add that customer's ID to the row to update them instead, and import the file again.
Was this article helpful?