Export Your Emails From Gmail into Excel or CSV

Share this:

We receive hundreds of emails in a month in our Gmail. Students receive PDF ebooks, teachers receive meeting requests, job seekers receive offer letters, business men receive orders and proposals, internet guys receive news letters. But all those emails are scattered on their own way. You can not perform any analysis on them. For example, a business men can not calculate how many emails he/she has got from a particular person. You can not even plot any graph/chart on the raw emails. To do so you have to first get those information in an Excel sheet.

To  solve above problem we  have created an app script  which can export your emails to Google spreadsheet. Later you can download that as an Excel. 

Update: If your emails have not been categorized into different labels then you can smoothly use this script, it will work great for you. Otherwise, you can use our updated script which can even export the Gmail-labels into the spreadsheet. You can also export only those emails which are present under a specific label in Gmail.

Watch a demo

Comparison among different versions:


VersionTitlePriceAction
1.0Export emails from Gmail to Excel or CSV$ 8.99 This app will be on sale after 6th May 2014
2.0Export emails from Gmail to Excel or CSV with labels$ 9.99Visit
3.0Export emails from Gmail to Excel or CSV with labels & attachments$ 10.99Visit
4.0Export all emails from Gmail to Excel or CSV
(With advanced features, recommended for business users)
$38(Offer)Visit

If you still need to ask something urgently, then call us at +917838024446+917838024446

How to do it

  • First purchase the product from above. After purchase kindly send your Gmail ID to hdas2012@outlook.com to which we should authorize to view the app. We will give you permission within a few minutes after your purchase.
  • Make a new copy of this spreadsheet (Go to File-->Make a copy..) Give some seconds to load the sheet
  • After it loads you can find a "Export Emails" option in the menubar
  • Click on it and you will get two more options (a) Export last N emails (b) Export selected emails


  • Export last N emails needs no explanation. You can export up to last 200 emails.
  • Export selected emails can export only some particular emails.

How to provide the parameters


(a) Export last N emails
After you click this option, it will ask for the number of emails you want to export. You need to provide a number between 1-200. To export more than 200 emails go for Export selected emails option, where you can use Gmail search queries so that you can export unlimited emails in a batch of 200.

(b) Export selected emails
For this option you need to provide a Gmail search query. You can write queries even in the traditional way. For more about Gmail search quries you can refer this page. For Example: To get only those emails from hdas2012@outlook.com and has attachments, you can write query like: 

from: hdas2012@outlook.com has:attachment


After you provide the parameters it will take some seconds to clear the existing entries in the spreadsheet (if any). Then it will start exporting your emails. It will also show you the progress status like how much percentage has been completed.

A home-task for our readers


After exporting the emails you can observe, the From column contains the email addresses of the senders. But the emails are mixed up with the names of the senders and appear in that column. For example, if the sender is Hari Das and his email is hdas2012@outlook.com, you will find Hari Das <hdas2012@outlook.com> in that column. Now your task is to separate the name of the senders from their emails. Let see who can do this.