bexio + Microsoft Excel

bexio + Microsoft Excel integrations

Update rows in Microsoft Excel when new orders are placed in bexio

Easily maintain your sales records with this powerful bexio to Microsoft Excel workflow. Whenever a new order is made in bexio, this automation instantly updates a specific row in your Microsoft Excel spreadsheet. This not only saves you time but also ensures accurate record-keeping of your sales data for seamless operations and better decision making.

When this happens...
New OrderTriggers when a Order is created or updated with the chosen status (line items not provided).
TriggerPolling
automatically do this!
Update RowUpdates a row in a specific worksheet.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with bexio and Microsoft Excel

Discover other triggers and actions you can use with bexio and Microsoft Excel

New/Updated Company
Triggers when a company is added or updated.
Trigger
Polling
Try It
- Status of Order
- Trigger each status change
  Required
Trigger
Polling
Try It
New Product
Triggers new Products.
Trigger
Polling
Try It
- Status of Quote
- Trigger each status change
  Required
Trigger
Polling
Try It
- Company Name
  Required
- Department
- Number
- EMail
- Second EMail
- Street Name
- House Number
- Address Addition
- Zip
- City
- Country
- Correspondence Type
- Categories
- Sectors
- Phone
- Phone second
- Mobile
- Fax
- Skype Name
- Language Id
- Remarks
- Number of Staff
- Tax Nr
- Trade Register Number
- Url
- Contact Person
Action
Write

- Identifier For Existing People
  Required
- Person Id
- Last Name
- First Name
- Number
- Birthday (Format yyyy-mm-dd)
- E-Mail
- Second E-Mail
- Street Name
- House Number
- Address Addition
- Zip
- City
- Country
- Correspondence Type
- Group Ids
- Phone
- Second Phone
- Mobile
- Fax
- Skype Name
- Language Id
- Remarks
- Salutation Form
- Salutation Id
- Title Id
- Company Id
- Position
- Url
Action
Write
- Company or Person
  Required
- Company Contact Person
- Invoice Date
- Payment Due Date
- API Reference
- Invoice Title
- Invoice Status
- VAT included in the total
- Currency
- Bank Account
- Project
- Line Item Product Key
- Line Item Name/Id/Code
  Required
- Line Item Quantity
  Required
- Line Item Price
  Required
- Line Item Text
- Line Item Discount in %
Action
Write

- Invoice
  Required
- Recipient Mail
  Required
- Subject
  Required
- Message
  Required
- Mark as pending
Action
Write
- Product Type
  Required
- Name
  Required
- Description
- Code
  Required
- Remarks
- Unit
  Required
- Sales Price
  Required
- Currency
  Required
- Vat
Action
Write
- Name
  Required
- Project Type
  Required
- Project State
  Required
- Company or Person
  Required
- Company Contact Person
- Start Date
- End Date
- Comment
Action
Write
- Billable
  Required
- Business Activity
  Required
- Company or Person
- Company Contact Person
- Project
- Status
- Type
  Required
- Date
- Duration
- Start Time
- End Time
- Text
Action
Write
- Account Number
  Required
Action
Search
- Name
- ISO 3166
Action
Search
- Order Number
- API Reference
- Include Order Positions
  Required
Action
Search
- Name
- Code
Action
Search
- Quote Number
- API Reference
- Include Quote Positions
  Required
Action
Search
- Last Name
  Required
- First Name
  Required
- EMail
- Number
- Phone
- Mobile
- Birthday
- Second EMail
- Street Name
- House Number
- Address Addition
- Zip
- City
- Country
- Correspondence Type
- Categories
- Sectors
- Second Phone
- Fax
- Skype Name
- Language Id
- Remarks
- Salutation Form
- Salutation Id
- Title Id
- Company Id
- Position
- Url
- Contact Person
Action
Search or write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Column Index
  Required
- Apply To
- Header Preservation
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Title
  Required
- Column Headers
- Zap_step_id
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Search or write

- Status of Invoice
- Trigger each status change
  Required
Trigger
Polling
Try It
New/Updated Person
Triggers when a person is added or updated.
Trigger
Polling
Try It
- State of Project
- Trigger each status change
  Required
Trigger
Polling
Try It
- Combined Entry
  Required
- Automatic Reference Number
- Date (line item support)
  Required
- Reference Number (line item support)
- Currency
  Required
- Debit Account Numbers (line item support)
  Required
- Credit Account Numbers (line item support)
  Required
- Vat (line item support)
- VAT Account
- Description (line item support)
- Amount (line item support)
  Required
Action
Write
- Last Name
  Required
- First Name
  Required
- Number
- Birthday
- EMail
- Second EMail
- Street Name
- House Number
- Address Addition
- Zip
- City
- Country
- Correspondence Type
- Categories
- Sectors
- Phone
- Second Phone
- Mobile
- Fax
- Skype Name
- Language Id
- Remarks
- Salutation Form
- Salutation Id
- Title Id
- Company Id
- Position
- Url
- Contact Person
Action
Write
- File to upload
  Required
- Filename
  Required
Action
Write
- Invoice
  Required
Action
Write
- Company or Person
  Required
- Company Contact Person
- Order Date
- API Reference
- Order Title
- VAT included in the total
- Project
- Line Item Name/Id
  Required
- Line Item Quantity
  Required
- Line Item Price
  Required
- Line Item Text
- Line Item Discount in %
Action
Write
- Code
  Required
- Name
- Description
- Remarks
- Sales Price
- Currency
- Vat
Action
Write
- Company or Person
  Required
- Company Contact Person
- Quote Date
- API Reference
- quote Title
- VAT included in the total
- Project
- Line Item Name/Id
  Required
- Line Item Quantity
  Required
- Line Item Price
  Required
- Line Item Text
- Line Item Discount in %
Action
Write
- Identifier For Existing Company
  Required
- Company Id
- Name
- Department
- Number
- EMail
- Second EMail
- Street Name
- House Number
- Address Addition
- Zip
- City
- Country
- Correspondence Type
- Group Ids
- Phone
- Second Phone
- Mobile
- Fax
- Skype Name
- Language Id
- Remarks
- Number of staff
- Tax Nr
- Trade Register Number
- Url
Action
Write
- Name
- E-Mail
- Number
- Phone
- Mobile
Action
Search
- Invoice Number
- API Reference
- Include Invoice Positions
  Required
Action
Search
- Last Name
- First Name
- E-Mail
- Number
- Phone
- Mobile
Action
Search
- Project Name
  Required
Action
Search
- Company Name
  Required
- EMail
- Number
- Phone
- Mobile
- Department
- Second EMail
- Street Name
- House Number
- Address Addition
- Zip
- City
- Country
- Correspondence Type
- Categories
- Sectors
- Phone second
- Fax
- Skype Name
- Language Id
- Remarks
- Number of Staff
- Tax Nr
- Trade Register Number
- Url
- Contact Person
Action
Search or write
- Name
  Required
- Code
  Required
- Product Type
  Required
- Description
- Remarks
- Unit
  Required
- Sales Price
  Required
- Currency
  Required
- Vat
Action
Search or write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- New Name
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- No_match_copy
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search or write

About bexio

Bexio is a business platform for offering accounting, invoices, payroll, and more for small companies in Switzerland.

Learn moreLearn moreHelpHelp

Related categories

Accounting

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 moreLearn moreHelpHelp

Related categories

Microsoft

Spreadsheets

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

bexio + Microsoft Excel

bexio + Microsoft Excel

Update rows in Microsoft Excel when new orders are placed in bexio

More things you can do with bexio and Microsoft Excel

Related Zap Templates

Related Zap Templates