# Pipedrive Import Checker and CSV Template | Dedupely

> Check a people or organizations CSV before you import it into Pipedrive. See skipped rows, merged duplicates and values that become 0, and get the template.

- URL: https://dedupe.ly/tools/pipedrive-import-checker
- Section: tools
- Site index: https://dedupe.ly/llms.txt
- Any page: append `.md` to its URL for this plain-text form

---

## Pipedrive import checker

Find the rows Pipedrive skips or merges before you import.
[Use in Claude](https://claude.ai/customize/connectors?modal=add-custom-connector&connectorName=Dedupely%20free%20tools&connectorUrl=https%3A%2F%2Fdedupe.ly%2Ftools%2Fmcp)
CSV file
Or paste rows here
First row is a header
Check the file
Free for 10 runs a day.

### Know which people Pipedrive merges

Pipedrive merges two people with the same name and email. It does the same for a shared phone or organization. Two records you meant to keep become one.
**This checker shows each merge before the import runs.**

### Start from the columns Pipedrive maps

A row without a person name never imports. A deal value with a currency sign arrives as 0. Pipedrive takes 50,000 rows a file at most.
**The Pipedrive templates use the column names from its own sample file.**

### The Pipedrive import template

#### Pipedrive people template

7 columns, in the order the template downloads.
| Column | What goes in it | Required |
| --- | --- | --- |
| Person - Name | Text | One of these |
| Person - First name | Text | One of these |
| Person - Last name | Text | One of these |
| Person - Email (Work) | An email address | |
| Person - Phone | Plus sign, country code and number | |
| Organization - Name | Text | |
| Organization - Address | Text | |

#### Pipedrive organizations template

2 columns, in the order the template downloads.
| Column | What goes in it | Required |
| --- | --- | --- |
| Organization - Name | Text | Yes |
| Organization - Address | Text | |

### Use it from a script or an AI agent

[Use in Claude](https://claude.ai/customize/connectors?modal=add-custom-connector&connectorName=Dedupely%20free%20tools&connectorUrl=https%3A%2F%2Fdedupe.ly%2Ftools%2Fmcp)
MCP https://dedupe.ly/tools/mcp every free tool in one connector (this one: check_crm_import)
POST https://dedupe.ly/tools/api/import-checker
{ "crm": "pipedrive", "csv": "..." }
Docs https://dedupe.ly/tools/api/openapi.json
[OpenAPI document](https://dedupe.ly/tools/api/openapi.json) ·
[API index](https://dedupe.ly/tools/api) ·
[llms.txt](https://dedupe.ly/llms.txt)

### Questions about Pipedrive imports

How many rows can Pipedrive import?
Up to 50,000 rows and 50 MB a file, in XLS, XLSX or CSV.
What does Pipedrive need in every row?
A person name for people and an organization name for organizations. Without it the row goes to the skip file.
How does Pipedrive find duplicates on import?
People with the same name and the same email, phone or organization are merged. Organizations with the same name and address are merged. Deals are never merged.
Why do my deal values show as 0?
Pipedrive reads a value with a currency sign as 0. Write 1000, not $1,000, and put the currency code in its own column.
Can I undo a Pipedrive import?
An admin can revert it from the import history within 48 hours.

### More free tools

[CSV dedupe](https://dedupe.ly/tools/csv-dedupe)
[Name splitter](https://dedupe.ly/tools/name-splitter)
[Email normalizer](https://dedupe.ly/tools/email-normalizer)
[List merger](https://dedupe.ly/tools/list-merger)
[Domain extractor](https://dedupe.ly/tools/domain-extractor)
[Company normalizer](https://dedupe.ly/tools/company-normalizer)
[Test data generator](https://dedupe.ly/tools/test-data-generator)
[CRM import checker](https://dedupe.ly/tools/import-checker)
[Phone number formatter](https://dedupe.ly/tools/phone-number-formatter)
[Job title normalizer](https://dedupe.ly/tools/job-title-normalizer)
[Fake contact generator](https://dedupe.ly/tools/fake-contact-generator)
[Duplicate cost calculator](https://dedupe.ly/tools/duplicate-cost-calculator)
[CSV to Excel](https://dedupe.ly/tools/csv-to-excel)
[Excel to CSV](https://dedupe.ly/tools/excel-to-csv)
[CSV validator](https://dedupe.ly/tools/csv-validator)
[VCF to CSV](https://dedupe.ly/tools/vcf-to-csv)
[CSV to VCF](https://dedupe.ly/tools/csv-to-vcf)
[CSV to chart](https://dedupe.ly/tools/csv-to-chart)

### Get started for free

20 free trial merges and as much free support as you need to get your duplicates under control.
[Talk to sales](https://meetings.dedupe.ly/meetings/hampus-isaksson/dedupely-zoom-schedule)[Try for free](https://v2.app.dedupe.ly/signup)
[Or sign up with Google](https://v2.app.dedupe.ly/signup/google)
Running CRM cleanup for clients? [See the Partner Program](https://dedupe.ly/become-a-partner)
Skip to content