Microsoft Excel + Square

Create new Square customers from new rows in Microsoft Excel tables

Boost your data management efficiency with this Microsoft Excel and Square integration workflow. Whenever you add a new row in your Excel, the customer data will be swiftly transferred to create a new customer record in Square. This automated process saves you the hassle of manual data entry, allowing you to focus on your core business tasks. It's a seamless solution for keeping your records well-organized and up-to-date.

When this happens...
New Row in Table
Triggers when a new row is added to a table in a spreadsheet.
TriggerScheduled
automatically do this!
Create Customer
Triggers when a new customer is created.
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

What does this mean?

- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

New Appointment
Triggers when a new appointment is created.
Trigger
Scheduled
Try It
New Customer
Triggers when a new customer is created.
Trigger
Scheduled
Try It

- LocationRequired
- Order Status
Trigger
Scheduled
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
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- 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

- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
- Item Type
Trigger
Scheduled
Try It
- LocationRequired
Trigger
Scheduled
Try It
- Location
Trigger
Scheduled
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

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.

Help

Related categories

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

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 Help

Related categories

Similar apps

PayPal

Payment Processing

Shopify

eCommerce

Epos Now

Payment Processing

PRODUCTS

CAPABILITIES

By team

Microsoft Excel + Square

Create new Square customers from new rows in Microsoft Excel tables

New Row

Storage Source

SpreadsheetRequired

WorksheetRequired

New Worksheet

Storage Source

Folder

SpreadsheetRequired

Add Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

Storage Source

Folder

TitleRequired

Column Headers

Zap Step Id

Find Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

New Appointment

New Customer

New Order

LocationRequired

Order Status

Add Customer to Group

Customer IDRequired

GroupRequired

Change Inventory

Inventory Change TypeRequired

LocationRequired

Catalog ObjectRequired

QuantityRequired

Ignore unchanged counts

Create Invoice

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

Refund Payment

PaymentRequired

Refund amount

Reason

Team member

Send Invoice

Help Text

LocationRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Customer

Field Help

Email Address

Phone Number

Reference ID

Find Service