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

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