1. Help Center
  2. Integrations & Uploading Files

What format should my Constituent File be?

Constituent files should be uploaded in .csv format

Constituent Files should be uploaded in .csv format with the first row being your header row. When you upload you will be given the ability to map your columns with the data points that GivingDNA needs to power the charts. GivingDNA requires mapping for the following fields:

  • Donor ID
  • First Name
  • Last Name
  • Address Line 1
  • City
  • State
  • Zip

You can optionally provide the following fields, as well:

  • Email Address
  • Address Line 2

You can have any number of other columns in your Constituent File, as long as the required ones are included.

Screenshot 2018-05-04 13.46.50

Click here to download a sample constituent file

Need help requesting this file from your database admin?

Send them this email:

Hi There!

I'm in the process of setting up an analytics tool called GivingDNA that analyzes our fundraising data and I need your help pulling a quick constituent report. Can you setup a query of all gifts from our donor database and send that to me in .CSV format?

I need these fields:

  • Donor ID
  • First Name
  • Last Name
  • Address Line 1
  • Address Line 2
  • City
  • State
  • Zip
  • Email Address

If you have any questions, please email support@givingdna.com and they’d be happy to answer any questions that you have.