Microsoft Excel + Magento 2.X

Microsoft Excel + Magento 2.X integrations

Add new Magento 2.X orders to Microsoft Excel as rows

Turn your new Magento 2.X orders into a well-organized spreadsheet with this automation setup. Each time you receive a new order, the details are instantly added into a specified row in your Microsoft Excel sheet. Never miss any crucial data and keep your sales records up-to-date with this simple, yet effective, automatic workflow.

When this happens...
New OrderTriggers when a new order is created (with line item support).
TriggerPolling
automatically do this!
Add RowAdds a new row to the end of a worksheet.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Magento 2.X and Microsoft Excel

Discover other triggers and actions you can use with Magento 2.X and Microsoft Excel

New Product
Triggers when a new product is created.
Trigger
Polling
Try It
New Order
Triggers when a new order is created (with line item support).
Trigger
Polling
Try It
New Sales Order Invoice
Triggers when a new sales order invoice is created (with line item support).
Trigger
Polling
Try It
- Email
  Required
- First Name
  Required
- Last Name
  Required
- Middle Name
- Password
  Required
- Prefix
- Suffix
- Gender
- Date Of Birth
- Default Billing Address
- Default Shipping Address
- Tax or VAT number
- Group ID
- Store ID
- Website ID
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Polling
Try It

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Column Index
  Required
- Apply To
- Header Preservation
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Title
  Required
- Column Headers
- Zap_step_id
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Search or write

New Customer
Triggers when a new customer is created.
Trigger
Polling
Try It
New Sales Order Credit Memo
Triggers when a new sales order creditmemo is created.
Trigger
Polling
Try It
- Shipment_delay_notice
- Delay to capture tracking data
Trigger
Polling
Try It
- Order ID
  Required
- Order Comment
- Should Customer be Notified?
- Should Comment be Visible on front?
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- New Name
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- No_match_copy
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search or write

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn moreLearn moreHelpHelp

Related categories

Microsoft

Spreadsheets

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

About Magento 2.X

Magento 2.X is the premier open source e-commerce app used by millions of customers each and every day.

HelpHelp

Related categories

eCommerce

Premium

Related Zap Templates

Create rows in Microsoft Excel when new sales order invoices occur in Magento 2.X

Create spreadsheets in Microsoft Excel for new orders in Magento 2.X