Export Emails to Google Sheets will generate spreadsheet with columns. Columns are can derived from rfc822 email message headers. Email headers are present on every email you receive via the Internet.
The header fields contain information about the message, such as the sender, the recipient, and the subject. If a message body is included, it is separated from the header fields by an empty line (\r\n).
The following example illustrates a message in the RFC 822 message format:
Return-Path: <email@example.com> Received: from a30-99.smtp-out.amazonses.com (a30-99.smtp-out.amazonses.com. by mx.google.com with ESMTPS id n18si9198603qtx.401.2021 for <******> (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-SHA bits=128/128); Tue, 23 Mar 2021 13:12:07 -0700 (PDT) Date: Tue, 23 Mar 2021 20:12:06 +0000 From: cloudHQ
References: <firstname.lastname@example.org> Mime-Version: 1.0 Message-ID: <email@example.com> X-SES-Outgoing: 2021.03.23-220.127.116.11 Feedback-ID: 1.us-east-1.xJ6EU3cbbfM7B+rb5qqUKRi95Pu4rw4hOG+l1ndnmms=:AmazonSES This is the plain text body of the message. Note the blank line between the header information and the body of the message.
In the above example, the headers are:
Some explanation about what rfc822 email message headers are can be found here.