Import sponsors from a spreadsheet

Bring your contacts, or last season's sponsors with what they bought and paid, into Fundraisr from a CSV or Excel file. Preview and match columns first; duplicates are skipped.

Who can do this: Owner, Finance and EditorOpen in Fundraisr

Import the list your organization already keeps. It can be plain contacts, or last season's sponsors with the package they bought, the amount and whether they paid. You preview every row and choose where each column belongs before anything is added. Your file isn't changed, and saved business details are never overwritten.

Steps

  1. Open Sponsors and choose Import spreadsheet.
  2. Upload: choose your file. Use Download CSV template if you'd like a starting layout.
  3. If your workbook has several sheets, pick the Worksheet. If the headings aren't on the first row, change Column headings are on row. Choose Match fields.
  4. Match fields: Fundraisr matches headings it recognizes. Check the example under each field and pick the right column, or Do not import. Only Business name (required) must be matched. More fields are under Address and additional business information.
  5. Under What they bought, match Package, Amount and Paid if your file has them. See below.
  6. In Add them to this season, pick the season the rows belong to, or An earlier season… and give it a name, like "2025 season". Choose Review import.
  7. Review & import: see how many rows are ready, how many are duplicates and how many need correction. Each ready row says what it will add. Choose Import to add the ready ones.

Import last season's sponsors

Match any of Package, Amount or Paid and each row comes in as a committed sponsor of the season you chose, with a payment request and what they've already paid. Fundraisr can then compare seasons, show who hasn't come back yet, and offer renewals.

  • Package: the name of one of your packages. Capitals and punctuation don't matter. A name you don't sell any more is kept as the description, as long as the row has an amount.
  • Amount: what they committed, like $400 or 1,500. Leave it out when the package name matches one of yours and the price was the same.
  • Paid: Yes, Paid or Paid in full count as paid; No, Unpaid or Pending as not paid; an amount, like $200, as part paid. With no Paid column, choose whether to count them as Paid in full or Not paid yet.
  • If a sponsor is already in Fundraisr, the sponsorship is added to the saved business instead of creating a second one. A business that's already a sponsor in that season is skipped.
  • Payments are recorded as "Recorded at import" in the payment ledger, dated at the end of the season when it has dates.

Sponsors in an earlier season, or one that has ended, are treated as history: there's no ad to make, no benefits to deliver and no follow-up. Anything they still owe stays as a balance to collect. Sponsors imported into your newest season get their benefits to deliver, like any sponsor who commits.

What happens next

  • Rows without what they bought are added as a New prospect in the chosen season, assigned to you, with the next step "Review imported contact".
  • No emails are sent, including payment requests.
  • Choose View sponsors to see them in the season you imported into.

Good to know

  • Files can be CSV or Excel .xlsx, up to 4 MB and 500 businesses. Save older .xls files as .xlsx first.
  • Formula cells come in blank. Use plain values for contact details and amounts.
  • A Do not contact column marks those businesses as do not contact. Yes, true, 1 and "unsubscribed" all count. See Do not contact.
  • Short US ZIP codes, like 1234 from a spreadsheet that dropped the leading zero, are padded to five digits.
  • Rows matching an earlier row in the file are skipped. So are rows matching a business you already have, unless the row adds what they bought. To bring an existing business into this season as a prospect, open it and choose Add to the season, or use the All seasons view.
  • Rows that need correction are left out; the rest import. Choose Download skipped-row report to fix skipped rows in your file and import them later.
  • An earlier season made by an import has no dates or goal. To add them, see Edit a season's name, goal or dates.

Your organization may sell sponsorships by the year, event or campaign instead of the season. Fundraisr uses your organization’s word everywhere.

Updated November 7, 2026

More in Sponsors and Up next