Are you dreaming of having all your Gmail data as records in a spreadsheet? This may be beneficial in many ways, for example to analyze your email subscriptions, to track communication history with customers in your self-made Google Sheets CRM, or simply as a back-up archive. However, there is no button that will extract Gmail to Google Sheets with one or a couple of clicks. Yet, you have a few options and workarounds to get this job done. Read on and apply the one you like the most.
Watching: Ways to export gmail emails to csv
How can you extract email from Gmail to Google Sheets?
Let’s start with a mediocre solution that consists of three high-level steps:
Exporting Gmail data as an MBOX file (email messages) or a JSON file (user settings)Converting the exported file to CSVUploading the CSV file into Google Sheets
Feel free to jump to the next section, Export Gmail to Google Sheets using the API, if you don’t want to deal with this.
Step 1: Export Gmail data using Google Takeout
Select data
Go to https://takeout.google.com/ and click Deselect all.
Now you can scroll down and select Mail.
Readmore: Online Dating Tips: Match Vs, Match Vs Tinder Vs Bumble: Datingoverthirty
If you don’t want to export all data from your Gmail, then click the All Mail data included button, deselect Include all messages in Mail, and select the specific label for your export. Click OK in the top-right corner.
After that, you can click the Next step button at the bottom.
Select file type, frequency, and destination
Select the Delivery method:
Send download link via emailAdd to GDriveAdd to DropboxAdd to OneDriveAdd to Box
Select the Frequency:
Export onceExport every two months for 1 year
Select the File type (.zip or .tgz) and its size (1, 2, 4, 10, or 50 GB).
Readmore: Fondation 2Ie — Wikipédia
Create the export
Click the Create export button, and Google will start creating a copy of files from your Gmail. This process can take a long time to complete, depending on the amount of data to be exported. You’ll receive an email when your export is done. And here is how it looks once completed.
Now you need to download the MBOX file to your device. If you selected the option of exporting to cloud storage, you’ll be able to open the file from it. For example, here is how it looks with GDrive:
Step 2: Convert the exported file into CSV
Unfortunately, you can’t import MBOX files into Google Sheets (we’ve already tried).
Categories: Mail