I needed a way of exporting the email messages from Gmail to Excel CSV format recently, and there’s a lot of random (and confusing) solutions listed online, so thought I’d blog about the one that actually worked for me.
It’s all pretty straight forward – here’s how.
Step 1: Download & Install Thunderbird
Hop over to the Mozilla website and download the email client Thunderbird. Once you’ve installed it, open up the program and head to step two.
Step 2: Add Gmail Account to Thunderbird
Once you have Thunderbird open, select the option to add a new account and enter your Gmail credentials. Thunderbird should automatically detect the default Gmail settings, giving you the option to select either IMAP or POP3. For the purposes of this, I selected POP3 (to store emails on my computer), then clicked the ‘Done’ option to finalise.
Step 3: Import Gmail Messages
Next up, click the ‘Get Mail’ option in Thunderbird to import the email messages from Gmail.
Step 4: Install Import/Export Addon for Thunderbird
As Thunderbird doesn’t offer the export to CSV functionality as standard, you’ll need to grab this import/export addon which will do the trick. Download and install the addon.
Step 5: Download Gmail Mails as Excel CSV
You can now select multiple emails within Thunderbird (hold CTRL and click in Windows for multiple selections). Once you have selected the messages you want to export to Excel CSV, simply right click and select the ‘Save selected messages’ option, then ‘Spreadsheet (CSV)’.
This should do the trick, with your selected Gmail messages appearing as seperate rows within an Excel CSV file (downloaded to the destination you chose).