Using VLookup to clean up your spreadsheet

Emily Howard_204
Emily Howard_204 Posts: 1 VERIFIED MEMBER
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: https://pipedrive.hubs.vidyard.com/watch/9jLYBPiLfJbzx6vx5tFYfQ?

This discussion has been closed.