# ChatGPT Donor Gift Export FAQ: Pledges, Duplicates, Board > How do you analyze a donor gift export with ChatGPT? Answers on uploading, the data check, pledges, duplicates, the chart and donor privacy. Source: https://learn.ynteractive.com/content/blog/chatgpt-donor-gifts-faq · Updated 2026-10-21 · Free from Stepthrough (https://learn.ynteractive.com) Quick answer To analyze a donor gift export with ChatGPT, upload the [CSV](https://learn.ynteractive.com/content/glossary/csv) from your donor database, ask ChatGPT to check the file before it adds anything up, decide yourself what to do with duplicates and pledges, and only then ask for totals, a chart and takeaways. The free [ChatGPT donor gift export lesson](https://learn.ynteractive.com/content/chatgpt-analyze-donor-gift-export-nonprofit) does all of it in about 11 minutes, for a board's mid-year development report. Last updated October 21, 2026 [Take the free module →](https://learn.ynteractive.com/courses/ai-for-operations/21)Module 21 of the free [AI for Operations Teams](https://learn.ynteractive.com/courses/ai-for-operations) course, about 11 minutes. No account needed. By [Robert Breen](https://learn.ynteractive.com/content/about) · Published October 21, 2026 · Updated October 21, 2026 · 5 min read ChatGPT · Nonprofits · Fundraising · Data Analysis · FAQ The example is made up. Hillside Literacy Project is a made-up nonprofit that runs after-school reading programs, and its donors, campaigns, foundations and every number are made up. The board will use the report to decide whether to hire a second reading coordinator, so a total that is off by a pledge or two matters. The practice copy of ChatGPT needs no account, and no file leaves your computer. This is our own lesson, not an official [OpenAI](https://learn.ynteractive.com/content/glossary/openai) course. ## How does the analysis work, step by step? The lesson has 26 steps in five short chapters: 1. **Upload the file.** Click the **+** on the left of the message box, choose **Add photos & files**, pick **hillside-gifts-jan-jun-2026.csv** and click **Open**. An Excel file works the same way. 2. **Check the data first.** Click **Paste request** and **Send**. The request asks what each column means, the row count, the date range and any duplicates, blanks or rows that may not be money received, with no insights yet. Then open **Problems found**. 3. **Clean it your way.** Click **Paste fix**: remove the second copy of each synced gift and mark the pledges **Pledge - not received**. Open the cleaned file, then close the panel with the **X**. 4. **Ask your question.** Click **Paste question** for gifts received by month, split by source, and January to March against April to June. 5. **Chart and takeaways.** Ask for a line chart, open it, click **download**, then ask for three takeaways and click **Copy**. The export is a [CSV](https://learn.ynteractive.com/content/glossary/csv) file: one row per gift or pledge. ## What did the check find? The file has 1,212 rows and 7 columns: gift_date, donor_id, donor_type, campaign, gift_type, transaction_id and amount. Names and contact details were removed; each donor has an ID. The dates run January 2 to June 30, 2026, with no blank dates or amounts. Two problems hide in it. Five online gifts appear twice with the same donor, date, transaction ID and amount, because the giving platform synced them twice. Left in, $1,240 would count twice. And 14 rows are pledges, $18,750 in total: promises to give that may not be money received yet. Counted as gifts, the board would see money the nonprofit doesn't have. ## Who decides what counts as a gift? You do, not ChatGPT. The fix tells it the duplicates are sync errors and the pledges are promises. It removes the second copy of each duplicate and changes the pledges' gift_type to "Pledge - not received", so they stay in the file but out of every total. The cleaned data has 1,207 rows, and 1,193 of them are gifts received. ChatGPT gives you the cleaned file to keep for the auditor. Removing [duplicates](https://learn.ynteractive.com/content/glossary/remove-duplicates) is the easy part; deciding how pledges are treated is a policy call. ## Try it free, step by step **Analyze a Donor Gift Export with ChatGPT: Board-Ready Giving Numbers for a Nonprofit**. Upload your donor database’s gift export to ChatGPT, catch gifts that synced twice and pledges that were never received before anything is added up, then get giving by source, a chart and three… You do every step yourself in a practice copy of ChatGPT, it checks your work as you go, and “Do it for me” finishes any step you get stuck on. Free, and nothing touches your real accounts. [Start the free lesson](https://learn.ynteractive.com/modules/nonprofit-donor-gifts-analysis) [Or read the full step-by-step guide](https://learn.ynteractive.com/content/chatgpt-analyze-donor-gift-export-nonprofit) ## What did the numbers show? $157,765 received from January to June. Every source grew in the second quarter. The three takeaways for the board: - **The Spring Appeal worked.** One-time gifts jumped from $8,400 in March to $21,600 in April, the month the appeal went out. - **Monthly donors are the steadiest money.** Monthly giving grew every month, from $3,150 to $3,725, 13.0% of everything received. - **A third of giving came in two checks.** Foundations gave $55,000, 34.9% of the total, in two grant payments, so a late or smaller grant would leave a large gap. ## Key takeaways - Remove names and contact details before you upload. A donor ID is enough. - Ask for a check of the file before any totals or insights. - Decide yourself how to handle duplicates and pledges. - Split giving by source: one big total hides what drives it. - Tie the totals to recorded deposits before the board sees them. ## Frequently asked questions **Can ChatGPT read an Excel file instead of a CSV?** Yes. The lesson says an Excel file works the same way. **How does ChatGPT add up the rows?** For questions like this, ChatGPT usually writes and runs a little Python code, so the totals are worked out from the file itself. **Why mark pledges instead of deleting them?** Marking keeps them in the file, so the report can show the board what is pledged and not received yet, separately from money in the bank. **Why ask for a quarter-to-quarter comparison?** Because March and June look big only because two foundation checks came in. Splitting by source and comparing January to March with April to June shows what one big total hides. **What kind of chart does the lesson make?** A line chart by month, one line each for one-time gifts, monthly donors, foundations and businesses, with a clear title. You open it full size and click the download icon to save it as a picture for the report. **What did ChatGPT say to double-check?** List the 14 pledges separately as "pledged, not received", ask your finance team or bookkeeper whether the June foundation payment is for this year's grant or an early payment of next year's, and check that the totals match the deposits they recorded. **Is it safe to upload donor data?** Remove names, emails, addresses and card details first, use a business ChatGPT plan that doesn't train on your data, and follow your privacy policy and any promises you made to donors. The [PII](https://learn.ynteractive.com/content/glossary/pii) entry explains what counts as personal data. **Where can I read about the common slip-ups?** See [ChatGPT donor gift analysis mistakes](https://learn.ynteractive.com/content/blog/chatgpt-donor-gifts-mistakes) and [is it safe to paste client data into ChatGPT](https://learn.ynteractive.com/content/blog/is-it-safe-to-paste-client-data-into-chatgpt). The base [ChatGPT spreadsheet lesson](https://learn.ynteractive.com/content/chatgpt-analyze-spreadsheet-csv) uses the same steps for other data, and the [nonprofit board meeting recap lesson](https://learn.ynteractive.com/content/nonprofit-board-meeting-recap) helps after the meeting. ## Free lessons in this post - [Analyze a Donor Gift Export with ChatGPT: Board-Ready Giving Numbers for a Nonprofit](https://learn.ynteractive.com/content/chatgpt-analyze-donor-gift-export-nonprofit): Upload your donor database’s gift export to ChatGPT, catch gifts that synced twice and pledges that were never received before anything is added up, then get giving by… ## Watch it in a free lesson: Get Your Business Recommended by ChatGPT ### Get Your Business Recommended by ChatGPT: video walkthrough Full walkthrough · 2:14 · with captions Ask ChatGPT who it recommends in your town, see which pages it trusts, then use it to write an FAQ page and Business Profile copy that answer real customer questions. The whole lesson narrated step by step, recorded in Stepthrough’s simulated practice environment. [Watch it with chapters and the full transcript](https://learn.ynteractive.com/content/get-recommended-by-chatgpt#watch) From the free lesson [Get Your Business Recommended by ChatGPT](https://learn.ynteractive.com/content/get-recommended-by-chatgpt) ## Related terms Plain-English definitions, each with an example from a free lesson. [CSV](https://learn.ynteractive.com/content/glossary/csv) · [OpenAI](https://learn.ynteractive.com/content/glossary/openai) · [Rows](https://learn.ynteractive.com/content/glossary/rows-spreadsheet) · [Natural language query](https://learn.ynteractive.com/content/glossary/natural-language-query) · [Profit and loss statement (P&L)](https://learn.ynteractive.com/content/glossary/profit-and-loss-statement) · [Request for quotation (RFQ)](https://learn.ynteractive.com/content/glossary/request-for-quotation) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Related prompts - [Timesheet summary prompt](https://learn.ynteractive.com/content/prompts/timesheet-summary-prompt): A ChatGPT prompt that turns a timesheet export into a summary: hours by person and project, missing days, unusual entries and… - [Customer complaint log summary prompt](https://learn.ynteractive.com/content/prompts/customer-complaint-log-summary-prompt): A ChatGPT prompt that turns a customer complaint log into a summary: complaints by type with counts, repeat customers, open… - [Monthly operations report prompt](https://learn.ynteractive.com/content/prompts/monthly-operations-report-prompt): A ChatGPT prompt for a monthly operations report: this month against last month and target, what drove the big moves, open… - [Overtime and attendance report prompt](https://learn.ynteractive.com/content/prompts/overtime-and-attendance-report-prompt): A ChatGPT prompt for an overtime and attendance report: overtime by person and week, the trend against last period, and items… [All free prompt templates](https://learn.ynteractive.com/content/prompts) ## Keep reading - [ChatGPT Donor Gift Analysis: 8 Mistakes to Avoid](https://learn.ynteractive.com/content/blog/chatgpt-donor-gifts-mistakes): ChatGPT donor gift analysis mistakes that mislead a board: counting pledges as gifts, synced duplicates, no data check, donor names left in and more. - [ChatGPT Creative Brief FAQ: Interview Prompt for Agencies](https://learn.ynteractive.com/content/blog/chatgpt-creative-brief-faq): How do you get a usable creative brief from ChatGPT? Answers on the interview prompt, the questions it asks, the summary check and the template. - [ChatGPT Projects FAQ: Instructions, Memory and Archive](https://learn.ynteractive.com/content/blog/chatgpt-projects-faq): Plain answers about ChatGPT projects for client work: how to create one, what Instructions do, the Memory setting, and Archive vs Delete. [All blog posts](https://learn.ynteractive.com/content/blog) · [All free tutorials](https://learn.ynteractive.com/content)