Understanding the Sample CSV File

Understanding the Sample CSV File

Sample CSV File

When you log in to your 360MatchPro and navigate to Data Import/Export --> Data Import, you have the ability to view the sample CSV File. We ask you to format your CSV File according to the sample file included within your account. The columns MUST match that of the sample file in order for the file to be imported properly. 

Within your CSV File, you have to include the following columns: 
  1. Campaign name
  2. Identifier 
  3. Amount 
  4. Email
  5. Phone Number
  6. First name
  7. Last Name
  8. Company Name (if you have it)
  9. Timestamp
You must include the column titles just like the sample CSV file. We recommend including a value for each field, but the only required fields are Campaign and Identifier. The other fields can be left blank for a donation record if you do not have the information.

Columns Explained in CSV File 


If you don't have specific campaign names, you can use the same campaign name. 


The donation amount should include numbers with decimals. Make sure not to include special characters in this column. 


Your Identifier column needs to be a unique set of numbers letters for each donation record; they can be a random set of numbers/letters, but they must be unique for each donation record. Often organizations will use the donation's ID number in the identifier column. 

Company Name 

Include company names associated with your donation records if you have them within your system. 360MatchPro will try to map your company names included with our company names included in our matching gift database as companies with a matching gift program. 

Time Stamp

You can Backdate your donation date or put the date as the date you are importing the donation records. Some organizations align the time stamp with the donation date for that specific donation record within their system. The date needs to be in the format of MM/DD/YYYY or YYYY-MM-DD.
Keep in mind that if you choose to backdate the time stamp, the donation record will be in chronical order within your Donations' Tab. 
Even if the donation records are backdated, the donation history will show the record as being imported to 360MatchPro on the date of import. The {{donation_date}} within automated email streams will be the date determined with the Time Stamp. 

Importing the CSV File

When you import the CSV File, you will be notified of how many records were imported properly. 

If not all of your donation records were successfully uploaded, it is likely that not all donation records were formatted correctly. Click "Start Over" if you'd like to import another CSV file. You'll be able to Preview the first 10 donation records within your CSV file. 

Click on the image to enlarge.

Training Videos 

    • Related Articles

    • Getting Started: Data Import Overview

      Data Import You can manually upload donation records into 360MatchPro by using a CSV file. This feature is useful if you have any offline or historical donation records and like to import those donation records into 360MatchPro so automated matching ...
    • Data Import: Triggering Outreach

      Data Import: Triggering Outreach When you log in to your 360MatchPro account and navigate to Data Import/Export --> Data Import, you'll be able to see trigger our automated matching gift emails after you import a CSV file of donation records. If ...
    • Data Import: Updating existing donation records in bulk

      Data Import - Update existing donation records Within 360MatchPro, you have the ability to update donation records in bulk to make it easier for your team to view records in 360MatchPro and ensure they are up-to-date. Because 360MatchPro, doesn't ...
    • Data Import: Mapping Companies

      Mapping Companies Navigate To Data Import/Export --> Data Import --> Choose the CSV File you wish to upload. When you've chosen the CSV file, in Step 2, you'll be able to preview the first 10 mapped donation records. Then, in Step 3: you'll be able ...
    • What Occurs After Import

      After you've imported the CSV file into 360MatchPro and selected which donors you'd like to send emails to based on their eligibility, automated matching gift emails will be sent to donors based on the email streams you've selected. The automated ...