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.

3 Tips for Exporting Data to Spreadsheets

Why Export Data to Other Programs??

You know, from my point of view, "why" is a question I don't always feel inclined (or capable) to answer.  Sometimes the best answer to "why" is simply "because".  Why export?  Because I want to export.  It's a valid reason, and so it behooves us at FundRaiser to make it as easy as possible to perform the task, even though it's a relatively little-used task when compared to most features of the program.  We don't need to know "why" you want to export, but YOU need to know HOW to export, and here are some tips to get the job accomplished in the best possible way for your purposes.

1.  Export or Print to File??  Choosing the right method.

Under the File menu, the "Export" option enables you to send data to various file formats that can be easily read by other programs.  The ASCII/dBase option gives you several choices, but the most common for spreadsheets is the CSV (Comma-Separated-Values) file format.  Exporting, however, has some limitations, in that you can only export fields that are available in the "Field Selection" list.  You may have noticed that only "statistical" gift data can be exported, rather than individual gift information.  So, when you need to export that type of information, the best bet is to use the "Print to Excel" option found in almost all reports (like the donation/deposit reports).  While this option will not be as "clean" as exporting to a CSV and then opening the resulting file in a spreadsheet, it WILL allow you to bring those multiple gifts into play.  So, the first step to exporting is to decide the level of detail you need, and either choose to Export (less detail) or Print to Excel, using a report (more detail, but more cleanup needed in the resulting Excel/spreadsheet file).

2.  To Group or Not to Group??  Depends on the export method

It is rare that a particular process will include your entire database, with the possible exception of Duplicate Checking, so you need to be aware of the name selection capabilities of the two export processes.  With the "File / Export" method, there is no "Advanced" section nor even a "Who" page, with which to limit the scope of your exported name records.  Instead, you can either choose the "Entire Master File", or a Grouping that you have in place.  With that in mind, you'll nearly always need to create a Grouping when doing a File/Export operation to exclude, for instance, Deceased, Anonymous, or Inactive name records, or to limit the export to a particular segment of your database.  With Reports being printed to an Excel file format, you'll have the normal "Who" page to select those Exclusions, as well as the "Advanced" section for any further limitations.  Keep in mind, however, that you may want to create a Grouping first anyway, since the Grouping can be used with either a report or a file/export process.  This will allow you to compare results, knowing that you have the same name records selected in either case.

3.  What is the desired result??  Can FundRaiser provide it?

Even though I opened this blog by saying we, at FundRaiser, don't need to know "why" you want to export, it might be a good idea for YOU to have a firm idea of why you believe you need to export.  It may be that the end result is something you can get entirely through FundRaiser, but just aren't certain how to get it.  Or maybe it's something your organization has been doing in a set manner forever, and no one has explored how to do it within FundRaiser.  Remember that we are here to help you learn the program to your benefit, and sometimes a phone call or email describing what you are trying to accomplish can give you answers that you hadn't thought possible.  Many of you may be in "one-user" situations, where no one else at your organization uses FundRaiser, and you just need another person to bounce ideas around, to see what might work.  That's when you want to call, or write, to either Tech Support or to Training, and we'll try our best to put you on a path to accomplish what you need.  Remember, too, that there are many good tips and tidbits in the Customer Portal section of the website, including the training videos, of coures, but also documentation on various aspects of the program.

3 Dead-On Grouping Tricks to Treat you right
2 Situations When You Might Want to Consider Using...

Related Posts

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

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