cancel
Showing results for 
Search instead for 
Did you mean: 

Email to Excel

In this guide below, we'll show you how to fully automate the extraction of any information you receive on any email, and add it straight to an Excel document.

 

1. Signup for a free Parserr account

Parserr1.PNG

2. Once you have filled out your details, you should recieve an email which looks a litle like this:

Parserr2.PNG

3. Click on the confirmation link in the email and login with the details you provided previously. Once logged in you should be presented with the setup screen. Click the "Great. Lets get started" button

Parserr3.PNG

4. The next screen will provide you with your incoming email address. This address is where you will forward all your incoming inquiries that you wish to extract to Dynamics Crm. Go ahead and copy the email address provided. Then make sure to forward a valid inquiry or email you wish to extract and make a note of your unique Parserr inbox (eg. BSB8GEBA@mgparserr.com) as shown below

Parserr4.PNG

 

5. Once you have forwarded the email to the assigned email address (ending in mg.parserr.com), Parserr will detect the email and then ask you a few onboarding questions. These need to filled out properly for the easiest user experience. In our case we would like to extract our customer information from the body of the email:

 

 Parserr5.PNG

6. Choose "Microsoft Flow"

Parserr7.PNG

7. Next choose "Microsoft Excel"

 

Parserr7.PNG

8. Depending on your email, Parserr may be able to automatically set your rules up automatically. In the case below, Parserr has detected that there are some parts of the body that may be able to be auto-extracted. If you don't see this screen, not too worry, parsing rules are very simple to setup. Choose the rules you want to setup. If you arent sure if you want the rule, simply create it anyway. You can always delete it later. Click the "Yes, create the rules I have checked above" button.

 

Parserr8.PNG

9. Next, you will have the option to create further rules, or if you have no rules yet, an option to create a rules. Creating rules is really easy once you get the hang of it. The idea is to "chain" a number of steps together to extract the content you need. For instance in my rule for "First Name" above, the following steps happened:

a) Step 1: Get row containing text "First Name": This gets me the row in the body of the email that contains that phrase, First Name

b) Step 2: Search & replace: So simply remove the part, "First Name" so i can end up with the value that I need:

 

Parserr9.PNG

If you're confused about creating rules, watch this quick video here on exactly how to create a rule. Remember its about finding the content you need for each rule:

 

 

or try this one here:

 

 

10. Once you have your rules sorted, go have a look at your parsing results. You do this by clicking on "incoming emails" in the left navigation and click the small arrow icon to open your first email:

 

Parserr10.PNG

 

11. Now its time to jump into Microsoft Flow and connect Parserr to Excel! Choose to create a new Flow and choose the Parserr connector and the trigger "Parserr - When an email is received". 

 

Parserr11.PNG

Parserr12.PNG

 

12. Next you will be prompted to add your username and password for parserr. Please use the same username and password as would when you login to Parserr.

 

Parserr13.PNG

 

13. If you are connected properly to Parserr, you will see your parserr email address appear in the trigger step. If you don't see a value, go back a step and try and reset your connection to Parserr:

 

Parserr14.PNG

 

14. Click "New step" and then click "Add an action" as shown below:

 

Parserr15.PNG

 

15. Choose Excel and "Insert row" as your action.

 

1.png

 

16. Choose the location of your Excel document. For this example, we will connect to an Excel document in OneDrive. Although this document could live anywhere.

 

2.png

 

17. Once you've correctly authenticated to OneDrive (or to the location of your Excel doc), you should see a familiar layout:

 

3.png

 

18. Choose the Excel file you would like to insert your rows into. If you haven't created a file already, make sure you create one and insert a table into the excel file in the location of where you would like the parsed data to go. NB The file needs to be closed (not open in any tab or on your desktop anywhere when the flow runs MS Flow needs sole access to the file when executing)

 

4.png

 

19. An extract of our Excel file before we start the Flow. Make sure it is closed when you are finished inserting the table

 

5.png

 

20. Choose the name of your table within the Excel document. The right panel shows dynamic content which originate from the rules created within Parserr. These rules represent the extracted content for each of your incoming emails. In the example below we have the option of using a number of different fields (eg "first name", "last name" etc) from the incoming email in your Excel doc.

 

6.png

 

7.png

 

21. Save your Flow by clicking the "Save Flow" button.

 

22. Test your Flow by sending an email to Parserr. You should see a run complete in Microsoft Flow on your dashboard: 

 

8.png

 

23 Click on the Icon of your flow to see the completed runs:

 

9.png

 

Parserr has a free account which allows you to test this integration up to 15 times per month. The steps above only need to be setup once, however the amount of time saved on data input alone is definitely worth the effort.

Comments
RRS

This is exactly what I'm looking for, thanks. But, I need this on an enterprise level. Do you know of any other email parsing service that is available? Or, can I somehow leverage Outlook's search function? 

Im unsure what you mean by "on an enterprise level". Parserr supports multiple enteprise environments? Feel free to reach out to me on support at parserr.com

Meet Our Blog Authors
  • Working daily with Microsoft Cloud to deliver the needs of my company, my customers and various Microsoft communities and forums. | Office 365 | Flow | PowerShell | PowerApps | SharePoint |
  • Co-founder of https://plumsail.com, Office 365 and SharePoint expert. Passionate about design and development of easy to use, convenient and flexible products.
  • Microsoft Business Apps MVP. Owner of ThriveFast, an Office 365 consulting company.
  • 7x Microsoft Business Solutions MVP (CRM)
  • I'm keen in MS technologies, SharePoint, Office 365 and development for them
  • Daniel is a Business Productivity Consultant & Microsoft Business Solutions MVP who is very enthusiastic about all things Office 365, Microsoft Flow, PowerApps, Azure & SharePoint (Online). Since the preview, Daniel has been working with Microsoft Flow and later on with Microsoft PowerApps. That led to him being awarded an MVP Award for Business Solutions. He loves to blog, present and evangelize about improving productivity in the modern workspace with these amazing tools!
  • Michelle is an Office 365 solution architect in Twin Cities, MN. She has been delivering business collaboration solutions for years with her focus on SharePoint and Office 365. Michelle is a recent board member of the Minnesota Office 365 User Group and has been a member of the SharePoint community since 2009. She is a frequent speaker at MNSPUG and SharePoint Saturday and co-chaired the Legal SharePoint User Group for 4 years. Her most frequent projects have involved rolling out a large deployment of Office 365, SharePoint Online intranet, build of a "CHAMPS" Office 365 user adoption program and most recently, SharePoint On-Premise to Online Migration. Michelle is very excited about cloud technology as it is shifting her IT Pro focus to collaboration strategy and technical adoption.
  • I'm a Microsoft Office Servers and Services MVP with a special interest in SharePoint, Office 365, Microsoft Flow, Microsoft Teams and PowerApps. I work at Triad Group Plc ( https://triad.co.uk)
  • Passionate #Programmer #SharePoint #SPFx #Office365 #MSFlow | C-sharpCorner MVP | SharePoint StackOverflow, Github, PnP contributor