We want you to feel confident getting your data ready for import! Below are some Google Sheets features that may help you through this process.
Finding duplicates 👯♀️
Duplicates are a common occurrence in large data sets, but they can be managed!
Givebutter will automatically merge duplicates together that have the same first and last names and either the same email address or phone number. If you have donor records that have the same email address and/or phone number but different names, they will be flagged as potential duplicates by the system for you to merge or ignore.
Before importing, you can help remove duplicates by using Google Sheets' built-in data clean up feature, that will detect duplicates for you. If the system is having trouble detecting all duplicates in your column or sheet, you can also try using Conditional Formatting and a formula called, ‘COUNTIF’. This will highlight all of the duplicates within one column for you so you can navigate your sheet more easily while cleaning.
If you are exporting data from multiple sources, this is a great video walkthrough of how to locate duplicates between two sheets.
Splitting up data 🍌
Perhaps your previous platform exported a Full Name column rather than the First and Last Names separately, don’t worry! Google Sheets has a built-in feature that allows you to easily split this data.
Split text to columns is a great way to automatically split up information into two or more cells. You can also choose which character should be used as ‘the separator’, for example, a space or a certain number or letter.
Merging data 🤝
If you have data within your sheet that needs to be merged with another column, you can use the JOIN formula for this. When you add this formula to a new, empty column, it will easily add together information from multiple columns. This will be especially helpful when you are using another formula, detailed in our next section, to match Givebutter Contact IDs to donor names.
Example formula: =JOIN(" ",C2,D2)
Using Givebutter Contact IDs on your transaction import
Once you have imported your contacts, Givebutter will generate a unique Contact ID for each record. Using contact IDs during your transaction import is a great way to ensure each transaction is assigned to the correct donor record.
You can retrieve those Contact IDs from your Contact Export:
VLOOKUP is a formula that can be used to match these unique IDs to their contact record automatically.
Here is a video walkthrough on how to use this formula, which should also work in Excel:
Example formula: =VLOOKUP(A2,ID!$A$2:$B$4,2,false)