Do you wish you could have a spreadsheet with all of your Gmail data? This may be used for a number of things, like analysing your email subscribers, recording customer interaction history in your own Google Sheets CRM, or just as a backup archive. However, there is no button that allows you to copy Gmail emails in Excel Sheet in only a few clicks. However, you do have a few options and workarounds for completing this activity. Continue reading and select the one that best appeals to you.
What is the best way to import Gmail emails into Excel Sheets?
Let’s start with a solution that has three high-level steps:
- Data from Gmail may be saved as an MBOX file (email messages)
- Using the exported file to create a CSV file
- Importing the CSV file into Google Sheets
If you don’t want to deal with this, move on to the next section: Using MBOX Converter to save Gmail emails into Excel sheet.
Step 1: Export Gmail data with Google Takeout.
- Select Deselect all from the drop-down option at https://takeout.google.com/.
- From the drop-down option, select Mail.
- Click the All Mail data included box, uncheck Include all messages in Mail, and give your export a specific name if you don’t want your Gmail data to be exported in its entirety. Click OK in the top-right corner. After that, scroll down to the bottom of the page and click Next step.
- Select a file type, frequency, and storage location for your documents.
Select a mode of delivery:
- For a year, export once every two months.
- Choose the file format (.zip or.tgz) and size (1, 2, 4, 10, or 50 GB).
- Make an export.
- When you click the Create export button, Google will begin copying files from your Gmail account. Depending on the quantity of data to be exported, this procedure might take a long time to complete. When your export is complete, you will receive an email notification. Here’s how it’ll look after it’s finished.
- The MBOX file must now be downloaded to your device. You’ll be able to open the file you exported to cloud storage if you choose that option. Here’s how it appears with GDrive, for example:
Step 2: Save the CSV file as the Output file.
MBOX files, however, cannot be imported into Google Sheets (we tried).
As a result, you must convert MBOX to CSV with a specialised tool. In our instance, we went with the latter option. Despite the fact that it required installation, it functioned well and converted the MBOX file exported from Gmail to CSV.
Alternative Manual Way to Copy Gmail Contacts in Excel Sheet
There is another manual way to save
- Firstly, select the “Address Book” that you want to export
- Select Tools >> Export
- While selecting the Export option, please make sure that Address Book is still selected or not
- Now save that file on any location as LDIF file with any file name as per your need
- Move this LDIF file on the system to which you need to import this
- If someone wants to transfer the address book to any other system then they have to move the address book to the new PC and then retrieve this LDIF file
- The first step needs to be repeated for getting back to the “Address book”
- Now again perform the same process
- Now, choose Text file (LDFI, .csv, .tab, .txt)
- If it is CSV → click Next.
- Now, choose LDFI location
- Click “Finish” and you are done!
In this blog, we skipped over the App Script option in this blog article since we promised to show you how to Copy Gmail Emails in Excel Sheet without scripting. However, if this solution is of interest to you, we may include it here later. If this seems intriguing to you, please let us know, and good luck with your data!