:::: MENU ::::

How to Export Gmail Emails to Excel CSV

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.

Share this post


  • Reply Rob |

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

  • Reply Lisa |

    Will this export to a CSV also capture the metadata in each of the email messages? I have to export approximately 500 gmail messages for importing to a database for a legal review. Thanks in advance for your valuable feedback!

  • Reply Heather Estara |

    I have never been so grateful for a blog post! I am a long time Thunderbird user and recently needed to export one of my inbox sub folders to Excel so that I could data sort the senders’ emails. I was running into so many complex solutions through gmail and when I saw I could download one of my beloved Thunderbird add ons I realized I would not be up all night doing this! Thank you a million times for this information!!!

  • Reply Santiago Colombres |

    Hi, and many thanks! But I would only import my last 30 emails or so. Do you know how do I import a whole label? Thanks again!

  • Reply Khalid Salama |

    Really it is fantastic and great … i had a lot of search and it was headache but now relax after using it …..

    Thanks a lot

  • Reply Matt |

    This is THE page I’ve been looking for for 3 hours – thank you, such a simple solution. Thanks you !