<div>
You either need to use some server scripting to access imap or intercept using Zapier perhaps airtable? &nbsp;<a href="https://zapier.com/apps/gmail/integrations/airtable" rel="ugc">https://zapier.com/apps/gmail/integrations/airtable</a>
</div>


You either need to use some server scripting to access imap or intercept using Zapier perhaps airtable?  https://zapier.com/apps/gmail/integrations/airtable [https://zapier.com/apps/gmail/integrations/airtable]

<div>
<div class="content wysiwyg-content">
Hello, I have an email inbox with hundreds of emails that are in a fixed format. &nbsp;All the emails are in gmail which I access through a web browser. &nbsp;I am attaching a snapshot of a sample email format.<br />
<br />
I want to be able to parse the information into an excel spreadsheet where the column names are the names of the fields before the &quot;:&quot; symbol and the values are the whats entered next to them.<br />
<br />
What is the best way for me to do that. &nbsp;Is there a commercially available or open source app that can make this easier? &nbsp;<a href="https://filedb.experts-exchange.com/incoming/2020/01_w03/1440945/Email_Snapshot.PNG" target="_blank" title="Email_Snapshot.PNG (40 KB)"><img alt="Email_Snapshot.PNG" class="file-block lazyload" style="max-width: 668px;" data-src="https://filedb.experts-exchange.com/incoming/2020/01_w03/1440945/Email_Snapshot.PNG" /></a><br />
Thanks.
</div>
</div>


Email_Snapshot.PNG

Hello, I have an email inbox with hundreds of emails that are in a fixed format.  All the emails are in gmail which I access through a web browser.  I am attaching a snapshot of a sample email format.

I want to be able to parse the information into an excel spreadsheet where the column names are the names of the fields before the ":" symbol and the values are the whats entered next to them.

What is the best way for me to do that.  Is there a commercially available or open source app that can make this easier?  

Thanks.

Parsing Data from email to excel

Google’s Gmail is a free email service that allows users to access their email on the web or by using third-party programs that synchronize email content through POP or IMAP protocols.