App Tutorial

Easy Steps to Import Data into Pipedrive CRM

Jason Gong
App automation expert
Apps used
April 15, 2024

Importing data into Pipedrive involves preparing a properly formatted spreadsheet, ensuring mandatory fields are included, creating custom fields if necessary, and following the import process in your Pipedrive account. This method allows for the import of leads, deals, contacts, and more, enhancing your CRM's effectiveness.

Automate your CRM updates with Bardeen to streamline data management and improve sales productivity.

How to Import Data into Pipedrive

Importing data into Pipedrive is a straightforward process that allows users to add various types of data such as leads, deals, contacts, and more from spreadsheets into their Pipedrive account. This guide will walk you through the steps to successfully import your data into Pipedrive.

Looking to supercharge your Pipedrive experience? Explore helpful automations to close more deals with Pipedrive.

Preparing Your Spreadsheet for Import

Before importing your data, ensure your spreadsheet is properly formatted. Remove any formulas, use only one tab per spreadsheet, avoid special symbols in numeric or monetary fields, and adhere to the maximum file size of 50MB or 50,000 rows per spreadsheet. Download Pipedrive's sample spreadsheet for a practice import and consider the type of data you're importing to format your spreadsheet accordingly.

Mandatory Fields for Import

Each type of data you import into Pipedrive requires specific mandatory fields. For example, importing leads requires a lead title and either a person name or organization name. Deals, people, organizations, products, notes, and activities each have their own set of mandatory fields. Ensure these fields are included in separate columns in your spreadsheet and mapped correctly during the import process.

Custom Fields

If your spreadsheet contains data that doesn't match Pipedrive's default fields, you'll need to create custom fields in Pipedrive before importing. This ensures your data has a place to be mapped. You can also create custom fields during the mapping stage of your import.

Initiating the Import

To start importing your data, go to '...' (More) > Import data > From a spreadsheet in your Pipedrive account. Pipedrive supports Excel (.xls and .xlsx) and .csv files. Follow the steps to upload your file, map your spreadsheet columns to the corresponding fields in Pipedrive, and preview your data before starting the import.

Automate your data imports and more with Bardeen. Begin by downloading the Bardeen app.

After Your Import

Once the import is complete, you'll see a confirmation page with an overview of the imported data. If any items were imported incorrectly, they'll be compiled into a 'Skip File', which you can download, correct, and re-import to ensure all your data is accurately added to Pipedrive.

Reverting an Import

If necessary, you can revert a spreadsheet import within 48 hours of its initial import. This option is available only to global admin users or users with the import items permission enabled. If the revert button is unavailable, contact Pipedrive support for assistance.

Maximize your CRM's potential with Bardeen's Pipedrive playbooks, such as Copy LinkedIn company data to Pipedrive and more.

Boost Pipedrive Efficiency with Bardeen Automations

While importing data into Pipedrive can significantly improve your CRM's effectiveness, automating this process can take your productivity to the next level. Bardeen offers several playbooks that seamlessly integrate with Pipedrive, enhancing your data management processes and ensuring your sales team has the most up-to-date information at their fingertips.

  1. Copy LinkedIn company data to Pipedrive: This playbook automates the process of creating new Pipedrive organizations with data extracted directly from LinkedIn, streamlining the process of populating your CRM with valuable company information.
  2. Copy LinkedIn profile data to Pipedrive contacts: Enhance your contact management by automatically creating new Pipedrive contacts using LinkedIn profile data, making lead generation and networking efforts more efficient.
  3. Copy all Pipedrive deals to a Google Sheet: For teams that manage sales data across multiple platforms, this playbook ensures that all Pipedrive deals are automatically copied to a Google Sheet for easy access and analysis.

Explore these automations to maximize your Pipedrive CRM's potential and make your sales process more efficient. Begin by downloading the Bardeen app at

Other answers for Pipedrive

Efficiently Adding Business Cards and Contacts to Pipedrive

Learn how to import business cards into Pipedrive using the Business Card Reader app and spreadsheet files for efficient CRM data management.

Read more
Adjusting Pipedrive Settings and Customizations

Learn how to customize Pipedrive settings, dashboard, and web forms for a personalized CRM experience. Streamline your sales strategy effectively.

Read more
How to Delete in Pipedrive

Learn how to delete accounts, deals, contacts, and duplicates in Pipedrive with our step-by-step guide. Maintain a clean CRM database efficiently.

Read more
Guide to Customizing Your Pipedrive CRM

Learn how to customize Pipedrive with custom fields, dashboards, and settings. Tailor your CRM to fit your sales process and automate for efficiency.

Read more
Identifying the Creator of a Deal in Pipedrive

Learn how to find who created a deal in Pipedrive using detailed logs, custom fields, and data export for improved sales tracking and accountability.

Read more
Pipedrive Integration

Learn how to integrate Pipedrive with Gmail, Slack, and via API to enhance CRM capabilities, streamline workflows, and improve sales efficiency.

Read more
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
Reading time
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.