Skip to content

Remove duplicate child profiles in Excel before importing

Before importing child profiles, check your import file against the children already in Evergiving so you only upload new records. This guide covers exporting your existing child profiles, using Excel's duplicate highlighting to find children that already exist, and saving a clean file ready to import.

Export your existing child profiles

  1. Go to Children in the main menu to open the Children Management screen.
  2. Click Add a Filter, set the filter to Campaign is, select the campaign you're importing children for, then click Apply.

    The Children Management screen with a Campaign filter set to World Vision Australia and the Apply button next to it

  3. Click Export as CSV in the top right. The file downloads to your computer as a CSV, for example children.csv.

    The filtered Children Management screen with the Export as CSV button in the top right

  4. Open the downloaded file in Excel. It lists every child in the campaign, with their Code in column A.

    The exported children file open in Excel, with child codes in column A

Add the existing codes to your import file

  1. Open your import file in Excel, keeping the export file open as well.

    The import file open in Excel, with child codes in column A

  2. Right-click the column A heading and select Insert. A blank column appears at the start and your data moves one column to the right.

    The right-click menu on the column A heading in Excel with Insert highlighted

  3. Switch to the export file. Click the column A heading to select the whole Code column, then press Ctrl + C (Cmd + C on a Mac) to copy it.

    The exported children file in Excel with column A selected

  4. Switch back to your import file. Click the column A heading, then press Ctrl + V (Cmd + V on a Mac) to paste.

    Column A now lists the codes already in Evergiving, and column B lists the codes in your import file.

    The import file in Excel with the exported codes pasted into column A and the import file's own codes in column B

Highlight the duplicates

  1. Click the column A heading, then hold Shift and click the column B heading to select both columns.

    The import file in Excel with columns A and B selected

  2. On the Home tab, click Conditional Formatting > Highlight Cells Rules > Duplicate Values.

    The Conditional Formatting menu in Excel open at Highlight Cells Rules, with Duplicate Values at the bottom of the submenu

  3. In the window that opens, leave the settings as Duplicate values with Light Red Fill with Dark Red Text, then click OK.

    The Duplicate Values window in Excel set to highlight duplicate values with light red fill and dark red text

  4. Look for red codes in column B. Each one is a child in your import file who already exists in Evergiving.

    The import file in Excel with codes T0015 and T0014 highlighted in red in rows 6 and 7 of column B

Warning

Only use the red codes in column B to decide which rows to remove. The codes in column A won't line up with your import rows. In the example, T0015 is red in row 2 of column A, but row 2 is a new child that needs to stay.

Tip

The Code heading in row 1 is also highlighted because both columns share the same heading. You can ignore it.

Remove the duplicates and save

  1. Click the row number of each row where the code in column B is red. To select more than one row, hold Ctrl (Cmd on a Mac) as you click.

    The import file in Excel with rows 6 and 7 selected, both showing red codes in column B

  2. Right-click one of the selected row numbers and select Delete.

  3. Right-click the column A heading and select Delete. This removes the codes you copied from the export and returns your import file to its original columns.

    The right-click menu on the column A heading in Excel with Delete highlighted

  4. Go to File > Save As. Enter a new file name, then click Save.

Your import file now contains only new child profiles.

You've exported your existing child profiles, found the children already in Evergiving and removed them from your import file. Your file is ready to import.