Others

How to Automatically Import Outlook Email Data into Excel with Power Automate

Huma Ashraf Ch Oct 16, 2026 868 views

Question details

The user wants to establish a workflow to automatically extract information from incoming Outlook emails and consolidate the data into an Excel spreadsheet.

Automatically Import Outlook Email Data into Excel with Power Automate

Product: Microsoft Excel, Outlook, Power Automate
Device & OS: not provided
Scenario: Building an automated cloud flow to capture email data from personal or shared Outlook folders and pass it into systems like Excel, SQL Server, or Power Apps.
Observed behavior: The user needs to configure the correct triggers and connectors between Outlook and Excel to ensure seamless data transfer without manual entry.

Before you start

Ensure you have an active Microsoft 365 account with access to Power Automate, and that your destination Excel workbook is saved in OneDrive for Business or SharePoint with a designated Table.

Solution 1Recommended

Set up a Power Automate Flow to Connect Outlook and Excel

Use the standard Microsoft Office 365 connectors in Power Automate to trigger a data extraction action whenever a new email arrives.

By leveraging Power Automate templates, you can map specific email attributes (such as Sender, Subject, and Received Time) directly to pre-defined columns in your Excel spreadsheet.

Format your Excel destination

Open your Excel workbook in OneDrive or SharePoint. Highlight your column headers (e.g., Sender, Subject, Date), go to the Insert tab, and click 'Table' (Ctrl+T) so Power Automate can recognize it as a data destination.

Create a new automated flow

Log into Power Automate, click 'Create' on the left sidebar, and select 'Automated cloud flow'. Give your new flow a descriptive name.

Configure the Outlook trigger

Search for 'Outlook' in the trigger search bar and select 'When a new email arrives (V3)'. Select your target folder (usually Inbox) and apply any necessary filters, such as specific sender addresses or subject keywords.

Add the Excel action

Click 'New step', search for 'Excel Online (Business)', and select the action 'Add a row into a table'. Select the Location, Document Library, File, and the specific Table you created.

Map the dynamic content

Click into the fields generated from your Excel columns. Use the dynamic content menu that appears to map Outlook fields (like 'From', 'Subject', and 'Received Time') to the corresponding Excel columns, then click 'Save'.

Set up a Power Automate Flow to Connect Outlook and Excel

Advanced Custom Integrations: If you are integrating this data further into SQL Server or Power Apps, this requires custom expressions and careful integration design. For advanced logic errors, it is highly recommended to post your workflow design in the Microsoft Power Automate Community for specialized assistance.

Free Microsoft Office alternative

Edit Your Extracted Excel Data with WPS Office

While Power Automate operates exclusively within the Microsoft ecosystem for cloud automation, you can easily open, edit, and analyze the resulting Excel files using WPS Office. It serves as a highly compatible, fast, and free alternative to Microsoft Office.

1. Download and Install WPS Office: Visit the official WPS website to download the free installation package and install the suite on your computer.
2. Open your automation spreadsheet: Launch WPS Spreadsheet and open the .xlsx file that Power Automate has populated with your Outlook email data.
3. Analyze and format: Use WPS Spreadsheet's built-in formulas, conditional formatting, and PivotTable features to analyze your automatically generated email logs.

Fully compatible with Microsoft Excel (.xlsx) formats generated by Power Automate workflows.Lightweight, free office suite encompassing alternatives for Word, Excel, and PowerPoint.Familiar user interface ensuring you can analyze your extracted email data with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate fail to find my Excel table?

Power Automate can only insert rows into a formatted Table, not a raw range of cells. You must open your Excel file, highlight your data range, and press Ctrl+T to format it as a Table before configuring the flow.

Can I extract specific text snippets from the email body into Excel?

Yes, but extracting specific strings from an unstructured email body requires using advanced 'Text' functions, expressions (like split or substring), or AI Builder models within Power Automate to parse the body text before mapping it to Excel.

Can I automatically save email attachments to OneDrive instead of Excel?

Yes. Instead of the Excel connector, you can use the 'Create file' action under the OneDrive for Business connector in Power Automate to automatically save incoming Outlook attachments directly to a specified folder.

Office Quick Solutions