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

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