Required fields and formats for contact records
A field-by-field standard for contact records: what's required, what format it takes and a check you can run on any list.
Use this as a standard for every contact list that enters your CRM or sending tool. Agree on it once, and imports stop breaking.
It also happens to be the shape bulk enrichment needs, so any file that follows it is ready to be completed.
The standard
| Field | Required? | Format | Example |
|---|---|---|---|
| First name | Yes | Text, no title or nickname | Maya |
| Last name | Yes | Text, no suffix | Ortiz |
| Job title | Recommended | Plain text | Head of Operations |
| Work email | Yes, to send | Lowercase, one address | maya@fernway.example |
| Phone | Optional | International format with country code | +44 20 7946 0000 |
| LinkedIn URL | Recommended | Profile address, no tracking tags | linkedin.com/in/mayaortiz |
| Company | Yes | Legal or trading name | Fernway |
| Company website | Yes | Domain only | fernway.example |
| Country | Recommended | Full name or ISO code. Pick one | United Kingdom |
| Source | Yes | Where this record came from | Event, 2026-09 |
| Date added | Yes | YYYY-MM-DD | 2026-10-06 |
Tip: Source and date added cost nothing to record and answer most later questions about a list: where did this come from, and how old is it?
A check you can run on any list
Rows with first and last name: ___ / ___ Rows with a company website: ___ / ___ Rows with a LinkedIn URL: ___ / ___ Rows with a work email: ___ / ___ Rows with a source and date: ___ / ___ Duplicate rows found: ___ Phone numbers without a country code: ___
Fixing gaps
- Missing emails or phones. Run the file through bulk enrichment. Only newly found contacts use credits.
- Missing website. Add it before uploading. It is needed for matching by name.
- Duplicates. Remove them first.
What to do next
Sending the list? Use the send-ready column layout for the version your sending tool needs.
Keep reading
How to prepare a messy export for enrichment
Fix the handful of problems that stop rows from matching: missing names, merged cells, odd URLs and oversized files.
How to remove duplicates before you enrich a list
Find repeat contacts in a spreadsheet, choose which row to keep, and know what ContactYard does with duplicates it finds.
The columns a send-ready list needs
A column-by-column checklist for the sheet you import into your email tool, with a header row you can copy.