Microsoft Excel + Xero

Create rows in Microsoft Excel for newly added quotes in Xero

Effortlessly manage your financial records by connecting Xero and Microsoft Excel with this seamless automation. When a new quote is created in Xero, this workflow will instantly add a row in your Excel spreadsheet, ensuring all your essential data is compiled in one easily manageable location. Save time and stay organized as the process happens behind the scenes, allowing you to focus on growing your business.

When this happens...
New Quote
Triggers when a new quote is created.
TriggerScheduled
automatically do this!
Add Row
Adds a new row to the end of a 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

What does this mean?

- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
- Payment Type
Trigger
Scheduled
Try It
- OrganizationRequired
- Quote Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
Trigger
Scheduled
Try It

- OrganizationRequired
- InvoiceRequired
Action
Write
- OrganizationRequired
- From AccountRequired
- To AccountRequired
- AmountRequired
- Date
Action
Write

- OrganizationRequired
- ContactRequired
- Date
- Expiry
- Quote Number
- Reference
- Theme
- Title
- Summary
- Currency
- Amounts Are
- Terms
Action
Write
- OrganizationRequired
- Invoice NumberRequired
Action
Write
- OrganizationRequired
- Contact NameRequired
- Email Address
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Reference
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Account
- Tax Rate
- Tracking
Action
Write
- OrganizationRequired
- Document Type
- Document ID or NumberRequired
- Paid ToRequired
- Date
- Currency Rate
- AmountRequired
- Reference
Action
Write
- OrganizationRequired
- ContactRequired
- StatusRequired
- Currency
- Branding Theme
- Reference
- Mark as approved for sending?
- Email a copy to Sender?
- Include PDF
- Line Amount Types
Action
Write
- OrganizationRequired
- Search ByRequired
Action
Search
- OrganizationRequired
- 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
- Bank Account Number
- Groups
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

- OrganizationRequired
- Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
- Type
Trigger
Scheduled
Try It
- OrganizationRequired
- Purchase Order Status
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Transaction TypeRequired
- ContactRequired
- Bank AccountRequired
- Date
Action
Write
- OrganizationRequired
- 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
Action
Write
- OrganizationRequired
- TypeRequired
- ContactRequired
- Date
Action
Write
- OrganizationRequired
- Mark Item as a Sales Item?
- Mark Item as a Purchase Item?
- Item Name
- Item CodeRequired
Action
Write
- OrganizationRequired
- Contact NameRequired
- Email Address
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Number
- Reference
- Sent To Contact
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Discount %
- Account
- Tax Rate
- Tracking
Action
Write
- OrganizationRequired
- Contact (supplier)Required
- Date
- Delivery Date
- Order Number
- Reference
- Theme
- Currency
- Tax Type
- Delivery Address
- Attention
- Telephone
- Delivery Instructions
- Attachments
- Purchase Order Status
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- OrganizationRequired
- Search ByRequired
Action
Search
- 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

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 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 Help

Related categories

Accounting

Similar apps

QuickBooks Online

Accounting

FreeAgent

Accounting

Wave

Accounting

PRODUCTS

CAPABILITIES

By team

Microsoft Excel + Xero

Create rows in Microsoft Excel for newly added quotes in Xero

New Bank Transaction

New Contact

OrganizationRequired

New Payment

OrganizationRequired

Payment Type

New Quote

OrganizationRequired

Quote Status

New Sales Invoice

OrganizationRequired

Status

Add Items to Existing Sales Invoice

OrganizationRequired

InvoiceRequired

Create Bank Transfer

OrganizationRequired

From AccountRequired

To AccountRequired

AmountRequired

Date

Create New Quote Draft

OrganizationRequired

ContactRequired

Date

Expiry

Quote Number

Reference

Theme

Title

Summary

Currency

Amounts Are

Terms

Send Sales Invoice by Email

OrganizationRequired

Invoice NumberRequired

Create Bill

OrganizationRequired

Contact NameRequired

Email Address

Status

Date

Due Date

Currency

Url

Attachment

Branding Theme

Reference

Line Items Type

Item Code

Description

QuantityRequired

Unit Price

Account

Tax Rate

Tracking

Create Payment

OrganizationRequired

Document Type

Document ID or NumberRequired

Paid ToRequired

Date

Currency Rate

AmountRequired

Reference

Create Repeating Sales Invoice

OrganizationRequired

ContactRequired

StatusRequired

Currency

Branding Theme

Reference

Mark as approved for sending?

Email a copy to Sender?