Using VLookup to clean up your spreadsheet

Emily Howard_204
Emily Howard_204 Posts: 1 PIPEDRIVE TEAM
Pipedrive Team
edited August 2023 in Business Talk #1

Hey Pipedrivers, 

When you're importing data into Pipedrive, having a clean and organized spreadsheet is key. There are many tools in Excel that you can use to clean up your data or remove duplicates. A VLookup can be helpful in a few different scenarios, including updating data in bulk via spreadsheet using the Pipedrive ID system. Here's a quick example of how to run a VLookup: 

Check out this video: