If there were items in your spreadsheet that were not imported correctly, Pipedrive will put together a skip file, which includes the row where the complication occurred and the reason why. You can download the skip file at any time to review the information on your import.
This article goes through errors when importing and skip files only. You can find more general information on how to import data to Pipedrive in this article.
To access your skip file, go to Tools and apps > Import data, click the Details option next to one of your completed imports, and click the Download skip file button. You will see a breakdown of the imported and skipped items under the details.
When you open your skip file, you will find the reason why the item in your spreadsheet was skipped under the Skip reason column. In the additional rows, you will see the data you attempted to import into Pipedrive in their original format.
The most common reasons are provided below, so that you may know how to adjust your spreadsheet in order to successfully import all of your data into Pipedrive on your next attempt.
- Deal title must be given
There are cases when the deal title could not be autogenerated. The person or organization is not mapped and the deal title is missing.
- Name must be given
When adding a person, you must always add a name column to your spreadsheet.
- Organization name must be given
An organization name field must always be added when importing an organization.
- Deal not found
This happens when you map the Pipedrive System ID, but this ID does not exist for a deal in Pipedrive.
- Person not found
This happens when you map the Pipedrive System ID, but this ID does not exist for a person in Pipedrive.
- Organization not found
This happens when you map the Pipedrive System ID, but this ID does not exist for an organization in Pipedrive.
- Please provide valid currency
Currencies are often used when importing the value of a deal and must be denoted without using their special character symbol. For example, USD and EUR would be correct but $ and € would not be.
- Unauthorized access
The URL for the Import Data page was provided to a user who is not authorized to import data into the account. Since only Admin Users or regular users with permission are authorized to import data within Pipedrive, the import is rejected.
- ID must be an integer
When importing an ID field in Pipedrive, the content of that mapped field can only be an integer. If any text is in that field, for example, 'EX1234', then that import will fail.
When mapping your import, Pipedrive will show errors if you are leaving out required fields, and you will not be able to proceed with the import.
Sometimes there may be some internal error within the import function in Pipedrive. In this case, we recommend you double-check your spreadsheet and mapping, and retry the import. If this issue persists, we suggest reaching out to our Support team for assistance.