How to Export Gmail Messages to Excel CSV (with Thunderbird)

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.

Add new Gmail account to Thunderbird

Step 3: Import Gmail Messages

Next up, click the ‘Get Mail’ option in Thunderbird to import the email messages from Gmail.

Import Gmail email messages into Thunderbird

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)’.

Click to export Gmail messages to Excel 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).

Have fun.


One Comment

  • Reply Rob |

    Awesome advice! So many people are punting paid plugin or ridiculous python scripting methods. This is perfect!

Comments