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.

When your spreadsheets aren't enough: import options in FundRaiser donor management software


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.  If you're having trouble convincing others of this, you may want to use one or the other of these linked articles as good examples.

Why NOT convert?

One of the big stumbling blocks to converting to a better system seems to be the old argument of "we would have to re-enter all that information, and no one has time to do that!".  Well, in FundRaiser there is a file menu option that allows you to import from other file formats.  Here are some quick tips and tricks on how to do that efficiently and successfully:

Setting up your spreadsheet for optimal import

1.  Name spreadsheet columns.  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-numberic labels, without punctuation or special characters, that give you an idea of what type of data is in the column.

2. Separate information if needed.  For example, a column labeled "interests" might, for a single name record, have "Hiking, Skiing, Boating" as an entry in a single column.  If, instead, there were three columns, with one interest per column, it would be easier to import.  An alternative to changing the spreadsheet, which might be time-consuming, would be to create a spare field in FundRaiser (called, say, "interests") and import the contents of the column into it.  Later you will be able to group records based on any single interest and mass-assign category codes accordingly.

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 on how those gifts have been stored in your spreadsheet.  One way is to have each gift on a separate row, along with name, address and phone numbers, for identification.  Another is to have a total "all time" giving amount, if you're not concerned with individual gift amounts and dates.  If you have multiple rows for multiple gifts, then be aware that 

IMPORTING ALWAYS ADDS NAMES

to the database.  This means that FundRaiser will be creating a separate name record for each gift, which can then be merged with other records of the same name, either manually using the Merge icon in the toolbar, or through the Duplicate Checking Routine found in the Utilities menu.  Of course, if you are importing multiple spreadsheets, there's always a chance a name could be on more than one of those lists, also requiring merging of records.  The same solutions apply no matter the reason for the duplications.  

The way to quick and easy data transfer

These steps may take a bit of preparation, but they will help you get the data transferred as quickly and easily as possible.  In the end, you'll be able to bring most, if not all, your information from the old spreadsheets to FundRaiser, with as little stress as possible.  As always, if you need help with this or other aspects of the program, check the Customer Portal on our website, as well as the FundRaiser FAQs, or contact us for further help.

Welcome to Nick Haring, the new support technician...
5 steps to creating tax summary letters for your d...

Related Posts

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

Connect With Us

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

Customer Portal Login Form

   

The customer portal is unavailable. If you need support please reach out to support@fundraisersoftware.com Thank you.

 

  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