Export email to Excel — without copy-paste
Practical guides for moving mailboxes into spreadsheets: Gmail, Outlook, any IMAP server. With code, limits and a ready script.
Most “email to Excel” advice ends with a CSV export button that only works for one folder, breaks on Gmail labels, and loses attachments. This site collects the approaches that actually work — and the trade-offs of each.
Pick your case
- Gmail → Excel — Google Takeout vs IMAP, labels, 2FA app passwords.
- Outlook → Excel — IMAP, VBA macro, Exchange limits.
- Any IMAP mailbox → Excel — Yandex, Mail.ru, corporate servers.
- Extract attachments — bulk download from a mailbox.
- Email → CSV — for CRM import and data pipelines.
- Invoices from email — B2B workflow for accounting.
Which method to choose
| Method | Best for | Limits |
|---|---|---|
| Google Takeout / Outlook export | Full backup, one-off | Not a spreadsheet; huge MBOX/PST files |
| Built-in “Export to CSV” | One folder, simple fields | No attachments, no folders, provider-specific |
| IMAP script (Python) | Repeatable export, any provider | Needs app password and 15 minutes of setup |
| Desktop email client rules | Small mailboxes | Manual, breaks on large volumes |
Rule of thumb: if you need this more than once a month, automate it with IMAP — a script runs the same way for Gmail, Outlook and a corporate server.
Related guides
- IMAP → Excel: the universal methodWorks for Gmail, Outlook, Yandex and any corporate mailbox.
- Extract attachments from emailBulk-save invoices, PDFs and documents to a folder.
- Email export tools comparedBuilt-in exports, macros, scripts and paid tools.