Microsoft Excel + Zoho Books

Update Zoho Books items when rows are updated in Microsoft Excel

Manage your financial documents efficiently with this automated workflow. Whenever you update a row in your Microsoft Excel file, it instantly creates a new item in your Zoho Books account. This enables a streamlined process, reducing manual input and ensuring accurate bookkeeping.

When this happens...
Updated Row
Triggers when a row is added or updated in a worksheet.
TriggerPolling
automatically do this!
Create Item
Creates a new item.
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

- 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

- OrganizationRequired
Trigger
Instant
Try It
- OrganizationRequired
Trigger
Instant
Try It
- OrganizationRequired
Trigger
Instant
Try It
- Organization NameRequired
- Customer NameRequired
- Estimate Number
- Date
- Expiry Date
- NameRequired
- RateRequired
- QuantityRequired
- Discount
- Description
- Exchange Rate
- Estimate Notes
- Send
- Estimate Terms
- Shipping Charge
Action
Write
- OrganizationRequired
- Item NameRequired
- Description
- Rate
- Tax Percentage
- Inventory Tracking Enabled in Organization
Action
Write
- OrganizationRequired
- Invoice NumberRequired
Action
Search

- 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
- OrganizationRequired
Trigger
Instant
Try It
- Status
- OrganizationRequired
Trigger
Instant
Try It
- OrganizationRequired
- PAN Number
- GSTIN or UIN
- GST Treatment
- Place of Contact
- Contact NameRequired
- Company Name
- First Name
- Last Name
- Email
- Website
- Phone
- Mobile
- Billing Address Address
- Billing Address City
- Billing Address Zip
- Billing Address State
- Billing Address Country
- Billing Address Fax
- Shipping Address Address
- Shipping Address City
- Shipping Address State
- Shipping Address Country
- Shipping Address Fax
- Shipping Address Zip
- Payment Terms
- Notes
- Vat Treatment
- Tax Treatment
- TRN Number
- Place of Supply
Action
Write
- OrganizationRequired
- Customer NameRequired
- Invoice Number
- Invoice Date
- Due Date
- Payment Terms
- Discount
- Exchange Rate
- Item NameRequired
- Description
- QuantityRequired
- RateRequired
- Discount ($)
- Payment Options
- Shipping Charge
- Adjustment
- Allow Partial Payment
- Notes
- Send
- VAT Treatment
- Tax Treatment
- Reference Number
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
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 Zoho Books

Zoho Books is cloud-based accounting software in which you can record, audit and analyze all financial transactions easily. With secure data storage, easy navigation and customizable features, Zoho Books provide a head start in accounting for small businesses.

Microsoft Excel + Zoho Books

Update Zoho Books items when rows are updated in Microsoft Excel

Supported triggers and actions

New Row

New Worksheet

Add Row

Add Row to Table

Create Worksheet

Find Row

Find or Create Row

New Customer

New Expense

New Item

Create Estimate

Create Item

Find Invoice

New Row in Table

Updated Row

Add Row(s)

Create Workbook

Update Row

Find Worksheet

Find or Create Worksheet

New Estimate

New Sales Invoice

Create Customer

Create Sales Invoice

API Request (Beta)

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

About Zoho Books

Related categories

Related Zap Templates

Related Zap Templates