Pipedrive organisations export β schema (migration reference)
What this is: the column schema of the Pipedrive organisations export Empire shared, the source for accounts in the Pipedrive migration (F4-a reads it, F4-d writes it). Two exports arrived on 2026-09-28:
organizations-15084451-95.xlsxin the morning, andorganizations-15084451-99.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 company names and addresses 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,
organization listβ 4,235 organisations, 35 columns (the same columns in both exports), each with a uniqueOrganization - ID(an integer). - Names are not unique: 4,029 distinct names, and 221 rows share a name with another row once case and spacing are ignored. People and leads refer to an organisation by name only β Pipedriveβs list-view export offers no linked organisation ID (see the people and leads schemas) β so a shared name cannot be linked on its own.
- 267 organisations have no people.
- Few addresses: 290 organisations have any address, 282 a country.
- 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 (organizations-15084451-99.xlsx).
| Export column | Filled | Migration note |
|---|---|---|
Organization - ID |
4,235 | The migration identity: source = 'pipedrive', source_ref = the ID (F1-a FR-S8) |
Organization - Name |
4,235 | β account.name |
Organization - Owner |
4,235 (18 distinct) | Not matched to a user β the account is owned by the import owner, and the name is kept (F4-a spec) |
Organization - Country of Address |
282 (63 spellings) | β account.country, normalised to ISO 3166-1 alpha-2 |
Organization - Address and its parts (street, city, state, region, postcode, full address) |
4 to 290 | account has no address columns |
Organization - Labels |
17 (3 distinct) | Candidate account tags |
Organization - People |
4,235 | Pipedrive-computed count β not stored |
Organization - Organization created, Organization - Update time |
4,235 | Creation and last-change time in Pipedrive |
Organization - Visible to |
4,235 (1 value) | Not migrated (sharing memo D-5) |
Organization - Open deals, β¦ Closed deals, β¦ Won deals, β¦ Lost deals, β¦ Total activities, β¦ Done activities, β¦ Activities to do, β¦ Email messages count |
4,235 | Pipedrive-computed counts β not stored |
Organization - Next activity date, β¦ Last activity date |
1,088 / 119 | Not stored (activities are not migrated β PRD Rev 44) |
Organization - Website, β¦ LinkedIn profile, β¦ Industry, β¦ Annual revenue, β¦ Number of employees, β¦ Profile picture |
0 | Empty in every row |