FundRaiser Blog

The FundRaiser Software Blog is an excellent resource for nonprofit organizations looking to learn more about fundraising, donor management, membership management, and much more.

Importing from Spreadsheets to FundRaiser

Many non-profits began their data management using spreadsheets.  Yours may still use them, but there are many reasons to move away from them and into donor management software, as you may be aware.  In fact, here are a couple of articles that some folks have referenced in telling us why they no longer want to use spreadsheets:  
 
One of the big stumbling blocks to converting to a better system is the old argument: “We would have to re-enter all the information, and no one has time to do that!”  Well, in FundRaiser (even in FundRaiser Basic) there is a file option that allows you to import from other file formats.  Here are some tips and tricks on how to do set up your spreadsheet for optimal importing:  
 
1.   Name spreadsheet columns
 
First of all, your spreadsheet is comprised of columns of information, and those columns should each have a name, used at the top of the column, called a “column header”. They need to be simple alpha-numeric labels, without punctuation or special characters (no $, %, &, ^, (), <>, etc.), that give you an idea of what type of data resides in the column. 
 
2.   Separate information into a “one column per code” format
 
In some cases you may need to modify the spreadsheet to make things easier, such as a column that has multiple codes in a single field. For example, a column labeled “interests” might, for one person, have “hiking”, “Skiing”, “boating”, etc., all in the same field. If, instead, you create multiple columns (interest1, interest2, interest3, etc.) and put a single interest in each one, it will be easy to import. An alternative would be to have that type of field go directly into a “Spare” field in FundRaiser, allowing you to later Group people together in FundRaiser to mass-assign category codes to those who have a particular “interest code” in that spare field, regardless of the other contents. This might be easier than modifying the spreadsheet. It’s up to you.
 
3.   Solve donation import issues
 
One of the main reasons to bring in all that information is to bring in gifts. Here you may run into a bit of a problem, depending upon how those gifts have been stored in your spreadsheet. The ideal is to have each gift on a separate row (with identifying data such as name, address, phone number), or, if you aren’t concerned so much with individual gifts as total giving, just a single amount of total giving per name will work well.  If you have multiple lines for multiple gifts, then you’ll be able to capture the individual gifts. FundRaiser will create a separate name record for each gift, resulting in duplicate entries for everyone who has multiple gifts.  Once imported, though, you can run the Duplicate Checking routine found in the Utilities section of FundRaiser, to identify all possible duplicates and allow FundRaiser to merge those duplicates together. Also, if you are importing multiple spreadsheets, it may be that a person is on more than one, which will result in duplicate records. 
 
These steps may take a little preparation, but they will help you get your data transferred as quickly and as easily as possible. In the end, you’ll be able to bring most of your useful information from your old system to the new FundRaiser system, and with as little stress as possible. If you absolutely must have all the old information, we provide (at additional cost) a data conversion service that involves a programmer creating a software solution to bring in all the data you need from any database, whether a spreadsheet or other donor management software.  Call for quotes, of course.  As always, if you need help with this or other aspects of the program, check the Customer Portal on our website, as well as Tech Support or Training for further help.
 
Positioning Grant Writers For Success, Part 1
Spice Up Your Thank You Notes

Related Posts

Wait a minute, while we are rendering the calendar
holiday letters giving history Reporting to IRS SYBUNTS Excel upgrading donors donor attrition FundRaiser Hosted accounting software training tip word processor grassroots campaign updates Codes technical support board members donor source disaster relief donor attrition rate vacation how-to videos support donor contact information adding personal notes to letters relationship tracking donor retention rate how to handle auction gifts in honor of donations LYBUNTS motivation code thank you letters Facebook campaign backing up data Company culture New Year texting donors customer service planned giving donor prospects campaign management flash sales user spotlights data conversion understanding giving trends membership benefits Crowdfunding Campaign tech tip phoning donors campaign donation history gift notes field In-Kind gifts grants community broadcasting donor advised funds entering auction gifts case study upgrade donor profile announcements tribute gifts new version volunteering auction Alternative Addresses merge fields FundRaiser Basic password protection custom page major donors gift entry recurring gifts volunteers office End of Year Letters charity golf tournaments operational costs Facebook Volunteer module mailing raffle holiday giving letter corporate sponsors gift acceptance policy passwords prospects online donations premiums change of address updating ROI National Change of Address arts brick campaign solicitors government grants #GivingTuesday tax summary letters new nonprofit pictures foundations salutation email new leadership community arts nonprofits memorial giving GivingTuesday overview donor targeting Donor Portal pledges planning ticketsales GoFundMe project animal rescue reports features event management publicity materials direct mail alumni social media training new donors anonymous donors new features Task List PayPal motivation Resiliency welcome packet Thanksgiving donor engagement donor preferences membersip benefits on site training community supported gardens banquet the Ask NCOA processing building donor relationships spreadsheets Reminders Groupings FundRaiser Spark development director targeted mailings online donations Thank You Congratulations communications Personalizing transparency data entry operating systems annual campaign appeal letters mission driven fundraising donor relations letter templates donor loyalty donor role of nonprofits small donations membership programs advanced tab general segmenting donors security spare fields customer portal mode code repeat donors appeal personalizing letters moves management correspondance Importing Data ticket sales major gift prospects giving levels merge notes Constant Contact look and feel Network for Good happiness donor retention correspondence monthly giving annual maintenance plan legacy giving add ons donor slip capital campaign follow up endowment campaign large donations donor recognition data analysis lapsed donor Tickles product news importing csv budget nonprofit fundraising Cloud increasing giving amounts user interface Snow Birds fundraising letters holiday

Connect With Us

  800-880-3454 ext 3
  Email Us
  Request More Information
  Monday-Friday
      8:30AM-5:30PM CST

Customer Portal Login Form

User Name:
Password:

If you are not sure about your Customer User Name, please call 800-543-4131 and we will be able to help you.

Or you have lost your password, Request Password