01 · .xlsx
Excel contact import template
Use the first worksheet for your contacts. It starts in column A, with headers in row 1 and a fictional example in row 2. Replace or delete the example before importing. The second worksheet contains instructions and the A–P column mapping.
Name is required. You can leave Code blank and My Contacts Cloud will generate it. All other fields are optional.
The 16 fields in the template
| Column | Field |
|---|
| A | Code |
| B | Name |
| C | Address |
| D | Postal code |
| E | City |
| F | State / province |
| G | Country |
| H | Phone 1 |
| Column | Field |
|---|
| I | Phone 2 |
| J | Email |
| K | Website |
| L | Company |
| M | Tax ID |
| N | Job title |
| O | Department |
| P | Notes |
Import your completed file
- Save your file as .xlsx. If you start with a CSV, open it in your spreadsheet app and save it as .xlsx first.
- Keep the contact worksheet first. Store phone numbers, postal codes, codes and tax IDs as text to preserve leading zeros and international prefixes.
- In My Contacts Cloud, open Import and choose From Excel file. Select your file and enable First row contains headers.
- Assign columns A–P to the corresponding fields. Leave fields you do not need unassigned. Import a small batch first, then check names, accents, phone numbers and email addresses.
- Review the import summary and the contact list. The file must be no larger than 10 MB, and imports are subject to your plan’s remaining contact capacity.
Groups, tags, custom fields, interactions and reminders are configured in the app after import; they are not columns in this template.