Microsoft Excel + Xero + SMS by Zapier Integrations

How to connect Microsoft Excel + Xero + SMS by Zapier

Zapier lets you send info between Microsoft Excel and Xero and SMS by Zapier automatically—no code required. With 5,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Connect Apps

Connect My Apps

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

Do even more with Microsoft Excel + Xero + SMS by Zapier

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Microsoft Excel, Xero, and SMS by Zapier. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- Folder
  NOTE that this defaults to the root of the drive.
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- Folder
  NOTE that this defaults to the root of the drive.
- TitleRequired
- Column Headers
Action
Write
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
  Let us know which column you want to search by with the value below. We will grab the first matching row and give you all of its values.
- Lookup ValueRequired
Action
Search

New Bank Transaction
Triggers when a new bank transaction is created.
Trigger
Scheduled
Try It
New Contact
Triggers when you add a new contact.
Trigger
Scheduled
Try It

- Quote Status
  If left empty, Zapier will trigger on all new quotes, regardless of status.
Trigger
Scheduled
Try It
- Status
Trigger
Scheduled
Try It
- Transaction TypeRequired
- ContactRequired
- Bank AccountRequired
- Date
Action
Write
- Contact NameRequired
- Account Number
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
  Also known as the ABN (Australia), GST Number (New Zealand), VAT Number (UK) or Tax ID Number (US and global) depending on which regionalized version of Xero you use.
- Bank Account Number
- Groups
  Add contact to selected group(s). Does not replace contact's existing groups.
Action
Write
- TypeRequired
- ContactRequired
- Date
  Defaults to today's date if not specified.
Action
Write
- Contact NameRequired
- Email Address
- Status
  Defaults to Draft if not specified.
- Date
  Defaults to creation date if not specified.
- Due Date
  A due date is required for approved invoices.
- Currency
  Default currency for organization will be used if not specified.
- Url
  URL link to a source document.
- Attachment
- Branding Theme
  The branding theme to use for this invoice.
- Reference
  Non-unique alpha numeric code identifying the bill.
- Url
  URL link to a source document.
- Line Items Type
  Line amounts are exclusive of tax by default if you don't specify this element.
- Item Code
  You must provide either an Item Code or both a Description and a Unit Price.
- Description
  If no Item Code is provided, this field is required.
- QuantityRequired
- Unit Price
  If no Item Code is provided, this field is required.
- Account
- Tax Rate
  Only specify if you want to override the default tax type for the account above.
- Tracking
  For example: Region - West Coast - see Setting > General Settings > Tracking in Xero for your tracking categories and options.
Action
Write
- Document Type
  What you'll you provide the ID or number for via the next field.
- Document ID or NumberRequired
  The ID or Number for the selected Document Type.
- Paid ToRequired
  The bank account or clearing account the payment is being made to.
- Date
- Currency Rate
  Exchange rate when payment is received. Only used for non base currency invoices.
- AmountRequired
- Reference
  An optional description for the payment.
Action
Write
- Owner
  Determines which App Extensions will appear in the dropdown below.
- App ExtensionRequired
Action
Write
- Search ByRequired
Action
Search
- Search ByRequired
- Contact NameRequired
- Account Number
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
  Also known as the ABN (Australia), GST Number (New Zealand), VAT Number (UK) or Tax ID Number (US and global) depending on which regionalized version of Xero you use.
- Bank Account Number
- Groups
  Add contact to selected group(s). Does not replace contact's existing groups.
Action
Search or write

- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
  Trigger on changes to cells in this column only.
Trigger
Scheduled
Try It
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  We will only update columns you provide, leaving all others untouched.
Action
Write
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
  Let us know which column you want to search by with the value below. We will grab the first matching row and give you all of its values.
- Lookup ValueRequired
Action
Search or write
- Status
Trigger
Scheduled
Try It
- Payment Type
Trigger
Scheduled
Try It
New Expense Claim Receipt
Triggers when you add a new draft expense claim receipt.
Trigger
Scheduled
Try It
- InvoiceRequired
- Item Code
  You must provide either an Item Code or both a Description and a Unit Price.
- Description
  If no Item Code is provided, this field is required.
- QuantityRequired
- Unit Price
  If no Item Code is provided, this field is required.
- Discount %
- Account
- Tax Rate
  Only specify if you want to override the default tax type for the account above.
Action
Write
- From AccountRequired
  The bank account the payment is being made from.
- To AccountRequired
  The bank account the payment is being made to.
- AmountRequired
- Date
Action
Write
- ContactRequired
- Date
  Defaults to current date if not specified.
- Expiry
- Quote Number
  If you want Xero to auto-generate a Quote Number for you, leave this field blank.
- Reference
- Theme
- Title
- Summary
- Currency
- Amounts Are
  Defaults to Tax Exclusive if not specified
- Item Code
- DescriptionRequired
- Quantity
- Unit Price
- Discount %
- Account
- Tax Rate
- Terms
Action
Write
- Invoice NumberRequired
  To email an invoice, it must have a status of Awaiting Approval, Awaiting Payment or Paid. The email will be sent to the primary email address of the contact on the invoice and any others marked as "Include in emails." The subject and body of the email will be based on the default email template.
Action
Write
- Contact NameRequired
- Email Address
- Status
  Defaults to Draft if not specified.
- Date
  Defaults to creation date if not specified.
- Due Date
  A due date is required for approved invoices.
- Currency
  Default currency for organization will be used if not specified.
- Url
  URL link to a source document.
- Attachment
- Branding Theme
  The branding theme to use for this invoice.
- Number
  Unique alpha numeric code identifying invoice - leave blank for auto-generated value.
- Reference
  An additional reference number
- Url
  URL link to a source document.
- Sent To Contact
  Mark invoice as "sent" (note: does not actually send an email). This can be set only on invoices that have a status of "approved" You can set this in the Status field above.
- Line Items Type
  Line amounts are exclusive of tax by default if you don't specify this element.
- Item Code
  You must provide either an Item Code or both a Description and a Unit Price.
- Description
  If no Item Code is provided, this field is required.
- QuantityRequired
- Unit Price
  If no Item Code is provided, this field is required.
- Discount %
- Account
- Tax Rate
  Only specify if you want to override the default tax type for the account above.
- Tracking
  For example: Region - West Coast - see Setting > General Settings > Tracking in Xero for your tracking categories and options.
Action
Write
- Contact (supplier)Required
- Date
  When the purchase order was issued. Defaults to today's date if not specified.
- Delivery Date
- Order Number
  If left blank, Xero will auto-generate this from your default invoice numbering.
- Reference
- Theme
- Currency
- Tax Type
- Item Code
  You must provide either an Item Code or both a Description and a Unit Price.
- Description
  If no Item Code is provided, this field is required.
- QuantityRequired
- Unit Price
  If no Item Code is provided, this field is required.
- Discount %
- Account
- Tax Rate
  Only specify if you want to override the default tax type for the account above.
Action
Write
- Api Docs Info
  API docs for Xero are located here https://developer.xero.com/documentation/api/accounting/overview
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
- Search ByRequired
Action
Search
- From Number
  Will attempt to send from this number, falling back to a random number if no longer available or unspecified.
- MessageRequired
  Messages should not contain any reference to alcohol, illegal drugs, cannabis/CBD, firearms, gambling, prescription medication, tobacco, or adult content, and comply with Twilio's Messaging Policy. Messages exceeding 153 characters will truncate.
Action
Write

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

How Microsoft Excel + Xero + SMS by Zapier Integrations Work

Step 1: Authenticate Microsoft Excel, Xero, and SMS by Zapier.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect Microsoft Excel + Xero + SMS by Zapier

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

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

About Xero

Xero is an accounting app that lets you track businesses expenses and accounting with intuitive mobile apps and web interfaces for point-of-sale, ecommerce, time-tracking, and more.

Learn more

Related categories

Accounting

Similar apps

QuickBooks Online

Accounting

FreeAgent

Accounting

Wave

Accounting

About SMS by Zapier

Using our built-in number, you can send a limited number of SMS / text messages. This is great for reminders!

Related categories

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Microsoft Excel + Xero + SMS by Zapier Integrations

How to connect Microsoft Excel + Xero + SMS by Zapier

Do even more with Microsoft Excel + Xero + SMS by Zapier

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

Find Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

New Bank Transaction

New Contact

New Quote

Quote Status

New Sales Invoice

Status

Create Bank Transaction

Transaction TypeRequired

ContactRequired

Bank AccountRequired

Date

Create/Update Contact

Contact NameRequired

Account Number

Primary Person - First Name

Primary Person - Last Name

Primary Person - Email

Phone - Country Code

Phone - Area Code

Phone Number

Fax - Country Code

Fax - Area Code

Fax - Number

Mobile - Country Code

Mobile - Area Code

Mobile - Number

Direct Dial - Country Code

Direct Dial - Area Code

Direct Dial - Number

Address Type Of

Address - Attention

Address - Line 1

Address - Line 2

Address - City/Town

Address - State/Region

Address - Postal/Zip Code

Address - Country

Tax Number

Bank Account Number

Groups

Create Credit Note

TypeRequired

ContactRequired

Date

Create Bill

Contact NameRequired

Email Address

Status

Date

Due Date

Currency

Url