Microsoft Excel + Zoho Books

Create new Zoho Books customers from new rows in Microsoft Excel

Keep your customer records consistent and updated across platforms with this workflow. Once set up, each time you add a new row in your Microsoft Excel, a new customer is created in your Zoho Books. Save time and reduce errors by eliminating the need for manual data entry, ensuring your customer records in Zoho Books always match the latest data in your Excel spreadsheet.

When this happens...
New Row
Triggers when a new row is added to a worksheet in a spreadsheet.
TriggerPolling
automatically do this!
Create Customer
Creates a new customer.
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
- Worksheet IDRequired
- RangeRequired
Action
Search

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
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

- 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 IDRequired
- Row IDRequired
- No Match Copy
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

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

Create new Zoho Books customers from new rows in Microsoft Excel

New Row

New Worksheet

Add Row

Add Row to Table

Create Worksheet

Find Row

Get Cells in Range

Get Worksheet by ID

Find or Create Worksheet

New Estimate

New Sales Invoice

Create Customer

Create Sales Invoice

API Request (Beta)

New Row in Table

Updated Row

Add Row(s)

Create Workbook

Update Row

Find Worksheet(s)

Get Row by ID

Find or Create Row

New Customer

New Expense

New Item

Create Estimate

Create Item

Find Invoice

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

About Zoho Books

Related categories

Related Zap Templates

Related Zap Templates