Congregation Connect Blog Preparing Data for Import: Separating Couples' Names

Whether you're migrating from another database, or finally moving away from multiple spreadsheets to manage your data, there are a few principles you want to keep in mind, and some tools you can use in Excel or another spreadsheet program to achieve them. If your data has a separate Last Name column, and you have a single column in which couples' names are together, you'll want to separate them. Here is how.