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 man 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.
Comparison among different versions:
|1.0||Export emails from Gmail to Excel or CSV||$ 8.99||Get the app|
|2.0||Export emails from Gmail to Excel or CSV with labels||$ 9.99||Visit|
|3.0||Export emails from Gmail to Excel or CSV with labels & attachments||$ 10.99||Visit|
|4.0||Export all emails from Gmail to Excel or CSV
(With advanced features, recommended for business users)
If you still need to ask something urgently, then call us at +919778188086
How to do it
- First purchase the product from above.
- Open the Email Exporter Spreadsheet
- 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 firstname.lastname@example.org and has attachments, you can write query like: from: email@example.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.