Email Extraction for Libraries: Organise Patron, Donor and Community Contacts
On this page
The Problem
Libraries collect contact information from many activities: library card registrations, programme sign-ups, interlibrary loan requests, donation records, volunteer applications, room reservation forms, summer reading registrations and community partnership agreements. This information lives in the integrated library system (ILS), event management platforms, donation tracking software, volunteer databases, email inboxes and paper forms.
When a library wants to announce a new programme, promote a fundraising campaign, recruit volunteers for a book sale, notify patrons about holiday hours, or invite community partners to a planning meeting, building a complete contact list from all these scattered sources is a significant effort.
Where Library Email Addresses Live
- Integrated library system (ILS) exports. Patron records in the ILS include email addresses collected during library card registration. Exports are typically CSV or XLSX files.
- Programme and event registration forms. Sign-up forms for story times, book clubs, author visits, computer classes, summer reading programmes and workshops. These may be in spreadsheets, exported from event platforms, or collected through online forms.
- Donor and Friends of the Library records. Donation tracking software or spreadsheets containing email addresses of monetary donors, book donors and members of Friends groups.
- Volunteer records. Applications and contact lists for library volunteers, including teen volunteers, book sale helpers and programme assistants.
- Room reservation requests. Forms submitted by community members or organisations reserving meeting rooms, study rooms or event spaces.
- Interlibrary loan correspondence. Communications with other libraries regarding loan requests, typically saved as email exports (EML, MSG) or logged in ILL management systems.
- Community partner contacts. Contact information for schools, community organisations, social service agencies and government offices the library collaborates with, maintained in spreadsheets or documents.
- Newsletter subscriber lists. Separate from the ILS, some libraries maintain newsletter mailing lists through email marketing platforms. Exports are CSV files.
- Grant and reporting records. Grant applications and reports containing contact details for foundation officers, partner organisations and project collaborators, usually PDF or DOCX files.
How to Extract
- Gather files from your ILS exports, event registration records, donor databases, volunteer lists and correspondence archives.
- Go to bulkemailextractor.com.
- Select "Text and files."
- Upload the files. Mix file types freely. Up to 25 MB per file, 100 MB per batch.
- Click "Extract emails."
- Review the results. Duplicates are removed automatically.
- Download as CSV with sources to see which file each address came from.
What to Do with the Results
Build a programme announcement list
A consolidated email list lets the library notify the community about new programmes, schedule changes, special events and resource additions. This is particularly useful for reaching patrons who attend programmes but may not check the library's website or social media.
Before using the list, review it carefully. Extraction captures every email address in the files, including staff addresses, vendor contacts, system-generated addresses and addresses from interlibrary loan correspondence with other libraries. Separate patron and community contacts from internal and professional contacts.
Promote fundraising campaigns
Extract from donor records, Friends group membership lists and event attendee lists to build a contact list for fundraising appeals. Annual fund drives, capital campaigns, endowment gifts and planned giving outreach all benefit from a complete list of supporters and potential supporters.
Recruit and coordinate volunteers
Extract from past volunteer applications and event sign-up forms to compile a list of people who have volunteered or expressed interest. This is useful for recruiting helpers for book sales, summer reading programmes, literacy tutoring and other volunteer-driven activities.
Announce new services and resources
When the library adds new databases, digital lending platforms, maker spaces, social worker services, passport acceptance services, or hotspot lending programmes, a single email to the patron list ensures broad awareness.
Reach community partners
Libraries collaborate with schools, after-school programmes, senior centres, job centres, social services and other community organisations. Extracting from partnership correspondence and contact records produces a consolidated list for coordinating joint programmes, sharing resources, or distributing information for partner organisations to pass along to their own networks.
Prepare for a system migration
Libraries migrating to a new ILS can use extraction to gather all patron email addresses from the old system's exports. This supplements the data migration performed by the ILS vendor and helps identify contacts that may not transfer cleanly, especially from supplementary systems (event platforms, donor databases) that are not part of the ILS migration.
Important Considerations
Patron privacy
Libraries have strong traditions of protecting patron privacy. Many states have laws specifically protecting library records, including circulation history and registration information.
Email Extractor processes files entirely in the browser on the user's device. No file contents are sent to a server during extraction. Patron data in your ILS exports stays on your computer.
Handle the extracted email list according to your library's privacy policies. Store it securely, limit access to authorised staff, and use it only for purposes consistent with your privacy policy and applicable state laws. Many library privacy policies restrict the use of patron information to library-related purposes.
Consent for email communication
Having a patron's email address for overdue notices does not necessarily mean you may use it for marketing or fundraising. Review your library's registration form and privacy policy to determine what uses patrons have agreed to. Some libraries include a checkbox for programme announcements or newsletter sign-up during registration; some do not.
For fundraising communications, consider whether the contact provided their email in a donor context (Friends membership, donation receipt) or a library service context (library card registration). See Email consent types explained.
Email addresses only
Email Extractor outputs email addresses. It does not preserve patron names, card numbers, circulation history or any other patron data. For complete patron records, use your ILS export tools.
Children's records
Patron records for minors require particular care. Libraries subject to the Children's Online Privacy Protection Act (COPPA) or state equivalents should review whether extracting and using email addresses from youth patron records is consistent with those requirements. Consult your library's legal counsel.
