Microsoft Excel + Magento 2.X

Microsoft Excel + Magento 2.X integrations

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

Automate your sales management with this simple workflow. Whenever a new order is placed in your Magento 2.X, it directly creates a spreadsheet in your Microsoft Excel. This not only saves time but ensures you have a well-documented record of all sales orders, ensuring accurate data and efficient business operations.

When this happens...
New OrderTriggers when a new order is created (with line item support).
TriggerPolling
automatically do this!
Create WorkbookCreates a new workbook
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
New Sales Order Shipment
Triggers when a new sales order is created (with line item support).
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

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