You can export Gmail email to CSV manually or professionally. For the manual approach, turning on IMAP in Gmail, setting up an email client such as Outlook or Thunderbird, and exporting emails to a local file. Manually create a CSV using Excel by copying email information such as subject, sender, and date.

But this process is cumbersome, not automated, and captures very limited email metadata only. It doesn't facilitate exporting attachments or the whole message body suitably.

The CloudMigration Gmail Email Backup Tool can simply back up entire mailboxes into CSV files hassle-free. It allows users to back up Gmail emails in numerous file formats like MBOX, PST, MSG, and others. Besides, this tool comprises some amazing features which are as follows:

• You can also back up Gmail email to Office 365 and other email clients directly.
• Use a Date range filter to select email of a specific period.

Moreover, let's have a look at the steps to back up Gmail emails in CSV file format, utilizing this utility:
1. Download and install the Gmail Backup tool in your computer.
2. Login to your Gmail account and click Next.
3. Choose the folder from the tree-like menu to export as CSV. Click Next.
4. Next, select CSV as the save file type from the dropdown.
5. Enter the necessary filter and click on the Convert option to begin conversion.

Know More: https://www.cloudemailmigration.com/blog/export-gmail-emails-to-csv/