Question : How to import my contacts from an OpenOffice spreadsheet?

Managing contacts in OpenOffice Calc or LibreOffice? Importing them into Mailpro is simple and fast — if the file is prepared correctly.

Step 1: prepare the sheet

• First row: column headers (Email, First name, Last name, …)
• One address per row, no whitespace, no merged cells
• Delete unused columns before exporting

Step 2: export as CSV UTF-8 or ODS

1. Menu File → Save As
2. Pick the Text CSV (.csv) format
3. Tick Edit filter settings
4. Choose UTF-8 encoding
5. Separator: comma (,) or semicolon (;)
6. Text delimiter: double quote (")

Step 3: import into Mailpro

1. Log in to Mailpro
2. Open Contacts → Import
3. Drag and drop your .csv file
4. Pick the destination list or create a new one
5. Map the columns (auto-detected)
6. Validate the import

Step 4: review the report

Mailpro shows a summary and the detail of rejected rows in the import report.

Common errors

• Garbled characters → encoding is not UTF-8 → re-export
• Mixed columns → wrong separator → set it correctly in the mapping step
• Empty rows → clean the sheet before exporting

Prefer video? Watch our contact import tutorial.