How to Extract Emails from a NocoDB Export
On this page
Export and import options vary by plan, permissions and product version. Check the platform’s current help documentation if a menu or format differs. Use only contact data you are authorized to process; an extracted address is not proof of marketing consent.
Why Extract from NocoDB?
NocoDB is an open-source, no-code database platform that turns any database (MySQL, PostgreSQL, SQL Server, SQLite) into a smart spreadsheet interface. It serves as a self-hostable alternative to Airtable. Teams use NocoDB to build contact databases, CRM-like applications, project trackers, inventory systems and other custom tools. NocoDB tables can include email fields, text fields, numbers, dates, attachments, links to other tables and formula fields.
Extracting email addresses from NocoDB data is useful in several scenarios.
Migrating to another tool. When switching from NocoDB to Airtable, Baserow, Google Sheets or a dedicated CRM, extracting email addresses helps verify migration completeness.
Building an email list. If your team tracks contacts, clients, members or prospects in a NocoDB table, extracting gives you a clean email list to import into an email marketing platform or CRM.
Consolidating data across tables. If different projects or departments maintain separate NocoDB tables with contact information, extracting from each and deduplicating reveals your total unique email-address count.
This counts distinct email strings using case-insensitive matching, not distinct people. One person may have multiple addresses, and shared addresses may represent several people.
Backing up contact data. For self-hosted NocoDB instances, exporting and extracting email addresses provides a simple backup in a portable format.
How to Export from NocoDB
NocoDB allows you to export data from tables.
Exporting a table
- Open the NocoDB base containing the table with email addresses.
- Navigate to the table you want to export.
- Click the three-dot menu (or the view's toolbar options).
- Select Download as CSV (or Export).
- NocoDB generates a CSV file containing the table data.
- Save the file.
Export fields
The exported file includes all fields (columns) from the NocoDB table. If your table has an email field, a name field, a company field, custom fields and formula fields, all appear as columns in the CSV.
How to Extract the Email Addresses
- Go to bulkemailextractor.com.
- Select "Text and files."
- Upload the CSV file (or multiple files from different NocoDB tables). Up to 25 MB per file, 100 MB per batch.
- Click "Extract emails."
- Review the results. Duplicates are removed automatically.
- Download as TXT for a plain list, CSV for a single-column spreadsheet, or CSV with sources to see which table export each address came from.
Working with the Results
Import into a CRM
The extracted list can be imported into HubSpot, Salesforce, Pipedrive or any CRM that accepts CSV imports. This is useful when your team has outgrown a NocoDB-based contact tracker.
Import into an email platform
Import the list into Mailchimp, ActiveCampaign, MailerLite or another email marketing platform to send campaigns to contacts stored in NocoDB.
Compare with other databases
If you use NocoDB alongside other tools (Airtable, Google Sheets, a CRM), export from each, extract, and compare. Deduplication creates a combined list of unique email addresses. Download CSV with sources and compare the source names to find addresses shared by the exports. Confirm subscription or membership status in the original records; matching addresses alone do not establish a current active membership.
Combine multiple tables
Upload CSV exports from multiple NocoDB tables or bases together. Deduplication shows your total unique email-address count across all tables.
Things to Know
Column headers are not extracted
CSV column headers from NocoDB are text, not email addresses, so they do not appear in the extracted results.
Contact data is not preserved
Email Extractor outputs email addresses only. Names, companies, phone numbers, dates, linked records, formula results and other fields are not carried over.
Email field type
NocoDB has a dedicated Email field type. If your table uses this field type, the data is validated on input and should contain properly formatted email addresses. If email addresses are stored in a plain text field, the export may include non-email content, but Email Extractor collects strings that match its email pattern; it does not validate their syntax or deliverability.
Views and filters
NocoDB supports multiple views (grid, gallery, form, kanban) with different filters and sorts. The CSV export typically reflects the current view. Switch to an unfiltered grid view before exporting to ensure all rows are included.
Linked tables
If your NocoDB base uses linked tables, the export of one table may show row references from linked tables. Export the table that directly contains the email field for best results.
Self-hosted considerations
NocoDB is often self-hosted, meaning your data stays on your own servers. The CSV export is the standard way to get data out of a self-hosted instance without direct database access. The extraction process is the same regardless of whether you use NocoDB cloud or self-hosted.
Form views
NocoDB form views collect submissions that are stored in the underlying table. These submissions are included in the table export and any email addresses from form submissions are extracted.
Formula fields
NocoDB supports formula fields. If a formula generates or transforms email addresses, the computed values are included in the export and can be extracted.
