Pipedrive people export — schema (migration reference)
What this is: the column schema of the Pipedrive people export Empire shared, the source for contacts in the Pipedrive migration (F4-a reads it, F4-d writes it). Two exports arrived on 2026-09-28:
Contacts.xlsxin the morning, andpeople-15084451-98.xlsxin the afternoon, re-exported with every hidden column ticked. The counts below are from the second. Only the structure and counts are recorded here. The file holds real names, email addresses and phone numbers and lives outside the repo (client data) — it is never committed. The counts are one snapshot: re-count against the export actually used for each migration run.
Shape
- One sheet,
person list— 4,977 people, 47 columns (the same columns in both exports), each with a uniquePerson - ID(an integer). - The organisation is named, not identified:
Person - Organizationholds the organisation’s name. Pipedrive’s list-view export offers no linked organisation ID — the re-export with every hidden column ticked has none. 390 of the 4,633 people with an organisation name point at a name that several organisations share, so the name alone cannot link them. - 344 people have no organisation.
- Duplicates: 1,018 rows share a name with another row, and 653 work email addresses appear on more than one person.
- Several values in one cell: 246
Email - Workcells and 551Phone - Workcells hold more than one value, separated by commas. - 37 people have no email and no phone.
- Timestamps are written
YYYY-MM-DD HH:MM:SSwith no time zone.
Columns (export field → migration note)
Fill counts are from the second 2026-09-28 export (people-15084451-98.xlsx).
| Export column | Filled | Migration note |
|---|---|---|
Person - ID |
4,977 | The migration identity: source = 'pipedrive', source_ref = the ID (F1-a FR-S8) |
Person - Name |
4,977 | → contact.name |
Person - First name, Person - Last name |
4,966 / 3,702 | Parts of the name — contact stores the full name only |
Person - Organization |
4,633 | The organisation’s name — links the contact to its account (see Shape) |
Person - Email - Work |
4,745 | The first value → contact.email (the main address); every other value → the contact’s other addresses (F20-l, decided 2026-10-26; design/architecture.md § Mailbox integration, Rev 74) |
Person - Email - Home, … Other |
0 / 7 | Email - Other → the main address when there is no work address, otherwise the contact’s other addresses (F20-l) |
Person - Phone - Work |
3,189 | → contact.phone (one value; see Shape) |
Person - Phone - Mobile, … Home, … Other |
393 / 4 / 1 | |
Person - Job title |
26 | → contact.job_title |
Person - Country |
3,501 (327 spellings) | No country column on contact; a candidate for its account’s country — needs normalising to ISO 3166-1 alpha-2 |
Person - Owner |
4,977 (17 distinct) | Not matched to a user; a contact has no owner in the CRM (it follows its account) |
Person - Trade Fairs |
4,317 | A Pipedrive custom field — fills a lead’s source (F4-a spec); custom fields are not otherwise migrated (PRD Rev 44) |
Person - Labels |
2,322 (6 distinct) | Candidate contact tags |
Person - Notes |
569 | A text field on the person, not a Pipedrive note record; one value repeats in 263 rows |
Person - Person created, Person - Update time |
4,977 | Creation and last-change time in Pipedrive |
Person - Visible to |
4,977 (1 value) | Not migrated (sharing memo D-5) |
Person - Open deals, … Closed deals, … Won deals, … Lost deals, … Total activities, … Done activities, … Activities to do, … Email messages count |
4,977 | Pipedrive-computed counts — not stored |
Person - Next activity date, … Last activity date, … Last email received, … Last email sent |
123 to 3,767 | Not stored |
Person - Postal address and its parts, Person - Birthday, Person - Instant messenger, Person - Profile picture |
0 to 135 | Not stored |