--- title: How to import offline donations with CSV file? description: When inputting a large number offline donations, you can create a CSV document with all the donations and upload them into your event at once. --- [Skip to content](https://knowledgebase.akaraisin.com/en/support/revenue-management/offline-pledges/how-to-import-offline-donations-via-csv-file#main-content) [Submit a request ↗](https://knowledgebase.akaraisin.com/en/support/kb-tickets/new?hsLang=en) [![raisin Logo](https://knowledgebase.akaraisin.com/hs-fs/hubfs/logo_raisin.png?height=40&name=logo_raisin.png)](https://raisinsoftware.org/) - [Help Centre](https://knowledgebase.akaraisin.com/en/support) Open main navigation Close main navigation - [Help Centre](https://knowledgebase.akaraisin.com/en/support) - [Submit a request ↗](https://knowledgebase.akaraisin.com/en/support/kb-tickets/new) How can we help out? - There are no suggestions because the search field is empty. 1. [Help Centre](https://knowledgebase.akaraisin.com/en/support?hsLang=en) 2. [Revenue Management](https://knowledgebase.akaraisin.com/en/support/revenue-management?hsLang=en) 3. [Offline Pledges](https://knowledgebase.akaraisin.com/en/support/revenue-management?hsLang=en#offline-pledges) # How to import offline donations with CSV file? ## When inputting a large number offline donations, you can create a CSV document with all the donations and upload them into your event at once. There may be times when you will have received a large sum of offline donations for a campaign and adding them in raisin [one-by-one](https://knowledgebase.akaraisin.com/en/support/revenue-management/offline-pledges/how-to-create-an-offline-pledge?hsLang=en) can be time consuming. raisin has an import tool to ease the strain of entering offline donations individually. ### Preparing your file of Pledges To import gifts into your event, we've prepared a reference file, with column headers mapped to the system. You can find a sample file template [here](https://admin.akaraisin.com/pdf/import/PledgeParticipantsSample.csv) (***Note***: for Multi-Pledge events, use [this sample file](https://admin.akaraisin.com/pdf/import/MultiPledgeOfflineDonationsSample.csv)). Each row in the file represents a donor and their pledged funds. Enter donor and gift information following the specifications in the reference and specifications file. A single import can contain up to 500 records at once. Once complete, save the file as a .CSV (comma delimited). In order to successfully import your offline donations, it is important to follow the guidelines in the reference files exactly. If there is any field that is incorrect, the entire record will not be imported. For file specifications, click [here.](https://admin.akaraisin.com/pdf/import/MultiPledgeOfflineDonationsSpecification.xls) ### **Importing Offline Pledges** You're now ready to import the gifts into the event. Here's how: - From the back-end of your raisin account, select which event the offline donations belong to. - On the left-hand side under "Offline Pledges", click on **Confirm Offline Pledges –** a new page will open. - Under "Import Offline Donations", click on the "here" option. The field where you will upload your file will populate. **Select** file from your computer drive and click **upload**. - A pop-up message will appear: *“Are you sure you want to upload a new CSV file with offline donations data?”* Click **OK**. ![1A\_001](https://knowledgebase.akaraisin.com/hs-fs/hubfs/1A_001.png?width=531&name=1A_001.png) Before uploading, it’s suggested to provide your email address in the "Notify by E-Mail" field. That way, you will receive an email notifications once the file has completed importing. ![1B](https://knowledgebase.akaraisin.com/hs-fs/hubfs/1B.png?width=470&name=1B.png) Upon uploading the file, the page status will be *Pending*. It’s suggested not to refresh the web-page while import is pending - This could result in the file importing twice. ![1C](https://knowledgebase.akaraisin.com/hs-fs/hubfs/1C.png?width=532&name=1C.png) Once the file has completed importing, you will receive a notification via email.  ![import\_success-1](https://knowledgebase.akaraisin.com/hs-fs/hubfs/import_success-1.png?width=607&name=import_success-1.png) The notification will inform you if the file import was successful or not. If file was not successful or some rows did not import, the message of the notification will consequently state why: ![import\_failed-1](https://knowledgebase.akaraisin.com/hs-fs/hubfs/import_failed-1.png?width=607&name=import_failed-1.png) Generally, if some rows of your file did not import, it means that there were errors in your file that need adjusting. The errors in the file will prevent the system from being able to read the file and will not import data. Here's a few things to check for in your import: - Extraneous empty rows  - Invalid Email Address form (e.g. an email address is missing .com, .org) - Invalid or improperly formatted ZIP/Postal Code ### **Confirming Offline Donations** Once the offline donations have successfully imported, you’ll want to ultimately confirm them. To do so, *select* the offline donations you want to confirm, make sure you choose desired *posting date* for confirmed pledges, and then click **Confirm Selected Pledges**. ![1F](https://knowledgebase.akaraisin.com/hs-fs/hubfs/1F.png?width=596&name=1F.png) You will then be presented with a confirmation window stating: *“Selected donations will be posted, are you sure?”* – click **OK.** Once that final step is done, donations have been confirmed and can be found in your raisin account. **Tips: ** 1. Do not add columns outside of what is presented in the template file. The import works on a mapping system and will not recognize foreign information. 2. Do not alter, move or remove the template headers as it will cause errors and will fail to upload 3. Make sure the *DonorEmail* column is filled if *IssueTaxReceipt* is set to *TRUE*.     - [Account & General Setup](https://knowledgebase.akaraisin.com/en/support/account-general-setup?hsLang=en#main-content) - [Organization](https://knowledgebase.akaraisin.com/en/support/account-general-setup?hsLang=en#organization) - [Modules](https://knowledgebase.akaraisin.com/en/support/account-general-setup?hsLang=en#modules) - [Payment](https://knowledgebase.akaraisin.com/en/support/account-general-setup?hsLang=en#payment) - [Shared Content](https://knowledgebase.akaraisin.com/en/support/account-general-setup?hsLang=en#shared-content) - [Security Management](https://knowledgebase.akaraisin.com/en/support/account-general-setup?hsLang=en#security-management) - [Invoice](https://knowledgebase.akaraisin.com/en/support/account-general-setup?hsLang=en#invoice) - [Email](https://knowledgebase.akaraisin.com/en/support/account-general-setup?hsLang=en#email) - [Event Setup](https://knowledgebase.akaraisin.com/en/support/event-setup?hsLang=en#main-content) - [Event Details](https://knowledgebase.akaraisin.com/en/support/event-setup?hsLang=en#event-details) - [Go Live](https://knowledgebase.akaraisin.com/en/support/event-setup?hsLang=en#go-live) - [Registration Information](https://knowledgebase.akaraisin.com/en/support/event-setup?hsLang=en#registration-information) - [Sponsorship Items](https://knowledgebase.akaraisin.com/en/support/event-setup?hsLang=en#sponsorship-items) - [Content Management](https://knowledgebase.akaraisin.com/en/support/content-management?hsLang=en#main-content) - [Pages](https://knowledgebase.akaraisin.com/en/support/content-management?hsLang=en#pages) - [Sections and blocks](https://knowledgebase.akaraisin.com/en/support/content-management?hsLang=en#sections-and-blocks) - [Design](https://knowledgebase.akaraisin.com/en/support/content-management?hsLang=en#design) - [User Profile Fields](https://knowledgebase.akaraisin.com/en/support/content-management?hsLang=en#user-profile-fields) - [Edit Content (Legacy)](https://knowledgebase.akaraisin.com/en/support/content-management?hsLang=en#edit-content-legacy) - [Message Templates](https://knowledgebase.akaraisin.com/en/support/message-templates?hsLang=en) - [User Management](https://knowledgebase.akaraisin.com/en/support/user-management?hsLang=en#main-content) - [Surveys](https://knowledgebase.akaraisin.com/en/support/user-management?hsLang=en#surveys) - [Donors](https://knowledgebase.akaraisin.com/en/support/user-management?hsLang=en#donors) - [Participants & Teams](https://knowledgebase.akaraisin.com/en/support/user-management?hsLang=en#participants-teams) - [Tickets & Tables](https://knowledgebase.akaraisin.com/en/support/user-management?hsLang=en#tickets-tables) - [Revenue Management](https://knowledgebase.akaraisin.com/en/support/revenue-management?hsLang=en#main-content) - [Assign Package Codes (Solicitation Codes)](https://knowledgebase.akaraisin.com/en/support/revenue-management?hsLang=en#assign-package-codes-solicitation-codes) - [Offline Pledges](https://knowledgebase.akaraisin.com/en/support/revenue-management?hsLang=en#offline-pledges) - [Payment and fundraising information](https://knowledgebase.akaraisin.com/en/support/revenue-management?hsLang=en#payment-and-fundraising-information) - [Promo Codes](https://knowledgebase.akaraisin.com/en/support/revenue-management?hsLang=en#promo-codes) - [Transactions](https://knowledgebase.akaraisin.com/en/support/revenue-management?hsLang=en#transactions) - [Tax Receipts](https://knowledgebase.akaraisin.com/en/support/tax-receipts?hsLang=en#main-content) - [Manage](https://knowledgebase.akaraisin.com/en/support/tax-receipts?hsLang=en#manage) - [Setup](https://knowledgebase.akaraisin.com/en/support/tax-receipts?hsLang=en#setup) - [Analytics](https://knowledgebase.akaraisin.com/en/support/analytics?hsLang=en) - [Reports](https://knowledgebase.akaraisin.com/en/support/reports?hsLang=en#main-content) - [General Questions](https://knowledgebase.akaraisin.com/en/support/reports?hsLang=en#general-questions) - [General Donation](https://knowledgebase.akaraisin.com/en/support/reports?hsLang=en#general-donation) - [Downloads](https://knowledgebase.akaraisin.com/en/support/reports?hsLang=en#downloads) - [Common Reports](https://knowledgebase.akaraisin.com/en/support/reports?hsLang=en#common-reports) - [Pledge / Multi-Pledge](https://knowledgebase.akaraisin.com/en/support/reports?hsLang=en#pledge-multi-pledge) - [Export Data](https://knowledgebase.akaraisin.com/en/support/export-data?hsLang=en#main-content) - [Flat File](https://knowledgebase.akaraisin.com/en/support/export-data?hsLang=en#flat-file) - [Integrations](https://knowledgebase.akaraisin.com/en/support/integrations?hsLang=en#main-content) - [Google Analytics](https://knowledgebase.akaraisin.com/en/support/integrations?hsLang=en#google-analytics) - [Strava](https://knowledgebase.akaraisin.com/en/support/integrations?hsLang=en#strava) - [360MatchPro by Double the Donation](https://knowledgebase.akaraisin.com/en/support/integrations?hsLang=en#360matchpro-by-double-the-donation) - [Address Complete](https://knowledgebase.akaraisin.com/en/support/integrations?hsLang=en#address-complete) - [MailChimp](https://knowledgebase.akaraisin.com/en/support/integrations?hsLang=en#mailchimp) - [Live streaming](https://knowledgebase.akaraisin.com/en/support/integrations?hsLang=en#live-streaming) - [DonorPerfect](https://knowledgebase.akaraisin.com/en/support/integrations?hsLang=en#donorperfect) - [Customer Support](https://knowledgebase.akaraisin.com/en/support/customer-support?hsLang=en) [![Chill listening crop-3](https://knowledgebase.akaraisin.com/hs-fs/hubfs/logo_raisin.png?width=63&height=24&name=logo_raisin.png "Chill listening crop-3")](http://www.akaraisin.com) The digital fundraising partner to growing non-profits. Copyright © 2026 raisin Software | [Privacy Policy](https://raisinsoftware.org/privacy-policy/)