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

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