Microsoft Excel + Square

Update rows in Microsoft Excel when new orders are placed in Square

Keep your Microsoft Excel spreadsheets updated with the latest Square order information using this efficient workflow. Whenever a new order is added in Square, this automation will find a matching row and update it in your Microsoft Excel spreadsheet. Stay organized and save time by ensuring all your order data is consistently up-to-date in one place.

When this happens...
New Order
Triggers when a new order is processed.
TriggerPolling
automatically do this!
Update Row
Updates a row in a specific worksheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

New Appointment
Triggers when a new appointment is created.
Trigger
Polling
Try It
New Customer
Triggers when a new customer is created.
Trigger
Polling
Try It
- LocationRequired
- Order Status
Trigger
Polling
Try It
- Customer IDRequired
- GroupRequired
Action
Write
- Inventory Change TypeRequired
- LocationRequired
- Catalog ObjectRequired
- QuantityRequired
- Ignore unchanged counts
Action
Write

- LocationRequired
- Order IDRequired
- Customer IDRequired
- Accepted Payment MethodsRequired
- Payment due dateRequired
- Tipping enabled
- Invoice title
- Invoice number
- Description
- Delivery methodRequired
- Scheduled at
- Date of sale
Action
Write
- PaymentRequired
- Refund amount
- Reason
- Team member
Action
Write

- Help Text
- LocationRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Field Help
- Email Address
- Phone Number
- Reference ID
Action
Search
- Field Help
- Text Filter
- Location
Action
Search
- Field Help
- Email Address
- Phone Number
- Reference ID
- First Name
- Last Name
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
Action
Search or write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

- Item Type
Trigger
Polling
Try It
- LocationRequired
Trigger
Polling
Try It
- Location
Trigger
Polling
Try It
- LocationRequired
- Team Member IDRequired
- Customer IDRequired
- Date and Time of AppointmentRequired
- Appointment Service IDRequired
- Note
Action
Write
- First Name
- Last Name
- Email Address
- Phone Number
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
- Reference Id
Action
Write
- LocationRequired
- Customer ID
- External Identifier
- Buyer Email Address
- Payment TypeRequired
- Payment Note
- QuantityRequired
- AmountRequired
- CurrencyRequired
- Line Item Name
- Catalog Item Variation ID
- Pickup
- Display Name
- Carrier
- Expected Ship Date/Time
- Shipping Note
- Fulfillment Email Address
- Phone number of the fulfillment recipient
- Address Line 1
- Address Line 2
- State
- County
- Country
- City
- Postal Code
- Discount Type
- Name
- Percentage
- Amount Discounted
- Discount Currency
- Name
- Percentage
- Type
Action
Write
- Customer IDRequired
- GroupRequired
Action
Write
- Customer IDRequired
- First Name
- Last Name
- Email Address
- Phone Number
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
- Reference ID
- Birthday
Action
Write
Find Order by ID
This action retrieves the details of a specific order from Square using the order ID.
Action
Write
- Customer Id
Action
Search
- LocationRequired
- Field Help
- Customer
- Fulfillment State
- Status
Action
Search
- LocationRequired
- Field Help
- Customer
- Fulfillment State
- Status
- Customer ID
- External Identifier
- Source
- Ticket Name
- Quantity
- Amount
- Currency
- Catalog Item Variation ID
- Note
- Unique Identifier
- Amount Discounted
- Amount Discounted Currency
- Name
- Percentage
- Type
- Unique Identifier
- Name
- Percentage
- Type
- Unique Identifier
Action
Search or write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
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 more

Related categories

Similar apps

About Square

Square creates tools that help sellers of all sizes start, run and grow their businesses. Square’s point-of-sale service offers tools for every part of running a business, from accepting credit cards and tracking inventory to real-time analytics and invoicing.

Learn more

Related categories

Similar apps

Related Zap Templates

Add new rows in Microsoft Excel for every new appointment in Square

Add new Square customers with VAT numbers validated by VATFix into Excel rows

Microsoft Excel + Square

Update rows in Microsoft Excel when new orders are placed in Square

New Appointment

New Customer

New Order

Add Customer to Group

Change Inventory

Create Invoice

Refund Payment

Send Invoice

API Request (Beta)

Find Customer

Find Service

Find Customer

New Row

New Worksheet

Add Row

Add Row to Table

Create Worksheet

Find Row

Find or Create Row

New Catalog Item

New Invoice

New Payment

Create Appointment

Create Customer

Create Paid Order

Remove Customer From Group

Update Customer

Find Order by ID

Find Customer by ID

Find Order

Find Order

New Row in Table

Updated Row

Add Row(s)

Create Workbook

Update Row

Find Worksheet

Find or Create Worksheet

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

About Square

Related categories

Similar apps

PayPal

Shopify

Epos Now

Related Zap Templates

Related Zap Templates