bexio + Microsoft Excel

Create sales invoices in bexio for new rows in Microsoft Excel table

Boost your billing efficiency with this seamless workflow. When new data is inputted into your Microsoft Excel table, it prompts bexio to generate a sales invoice. This process not merely ensures uniform billing but also cuts down on time and minimizes manual entry mistakes. Ideal for small ventures aiming to upgrade the effectiveness of their billing operations.

When this happens...
New Row in Table
Triggers when a new row is added to a table in a spreadsheet.
TriggerPolling
automatically do this!
Create a Sales Invoice
Create a product based sales invoice.
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 IDRequired
- Column IndexRequired
- Apply To
- Header Preservation
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
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
- Status of Invoice
- Trigger each status changeRequired
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 changeRequired
Trigger
Polling
Try It
- Combined EntryRequired
- Automatic Reference Number
- Date (line item support)Required
- Reference Number (line item support)
- CurrencyRequired
- 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 NameRequired
- First NameRequired
- 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 uploadRequired
- FilenameRequired
Action
Write
- InvoiceRequired
Action
Write
- Company or PersonRequired
- Company Contact Person
- Order Date
- API Reference
- Order Title
- VAT included in the total
- Project
- Line Item Name/IdRequired
- Line Item QuantityRequired
- Line Item PriceRequired
- Line Item Text
- Line Item Discount in %
Action
Write
- CodeRequired
- Name
- Description
- Remarks
- Sales Price
- Currency
- Vat
Action
Write
- Company or PersonRequired
- Company Contact Person
- Quote Date
- API Reference
- quote Title
- VAT included in the total
- Project
- Line Item Name/IdRequired
- Line Item QuantityRequired
- Line Item PriceRequired
- Line Item Text
- Line Item Discount in %
Action
Write
- Identifier For Existing CompanyRequired
- 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 PositionsRequired
Action
Search
- Last Name
- First Name
- E-Mail
- Number
- Phone
- Mobile
Action
Search
- Project NameRequired
Action
Search
- Company NameRequired
- 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
- NameRequired
- CodeRequired
- Product TypeRequired
- Description
- Remarks
- UnitRequired
- Sales PriceRequired
- CurrencyRequired
- Vat
Action
Search or 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
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- New NameRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
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
New/Updated Company
Triggers when a company is added or updated.
Trigger
Polling
Try It
- Status of Order
- Trigger each status changeRequired
Trigger
Polling
Try It
New Product
Triggers new Products.
Trigger
Polling
Try It
- Status of Quote
- Trigger each status changeRequired
Trigger
Polling
Try It
- Company NameRequired
- 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 PeopleRequired
- 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 PersonRequired
- 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/CodeRequired
- Line Item QuantityRequired
- Line Item PriceRequired
- Line Item Text
- Line Item Discount in %
Action
Write
- InvoiceRequired
- Recipient MailRequired
- SubjectRequired
- MessageRequired
- Mark as pending
Action
Write
- Product TypeRequired
- NameRequired
- Description
- CodeRequired
- Remarks
- UnitRequired
- Sales PriceRequired
- CurrencyRequired
- Vat
Action
Write
- NameRequired
- Project TypeRequired
- Project StateRequired
- Company or PersonRequired
- Company Contact Person
- Start Date
- End Date
- Comment
Action
Write
- BillableRequired
- Business ActivityRequired
- Company or Person
- Company Contact Person
- Project
- Status
- TypeRequired
- Date
- Duration
- Start Time
- End Time
- Text
Action
Write
- Account NumberRequired
Action
Search
- Name
- ISO 3166
Action
Search
- Order Number
- API Reference
- Include Order PositionsRequired
Action
Search
- Name
- Code
Action
Search
- Quote Number
- API Reference
- Include Quote PositionsRequired
Action
Search
- Last NameRequired
- First NameRequired
- 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

About bexio

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

Learn more

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 more

bexio + Microsoft Excel

Create sales invoices in bexio for new rows in Microsoft Excel table

New Row

New Worksheet

Add Row

Add Row to Table

Clear Column by Index

Create Workbook

Delete Worksheet

Update Row

Find Row

Get Cells in Range

Get Worksheet by ID

Find or Create Worksheet

New Sales-Invoice

New/Updated Person

New Project

Create Manual Entry

Create Person

Upload File to Inbox

Export Invoice to PDF

Create a Sales Order

Update Product

Create a Sales Quote

Update Company

Find Company

Search Invoice

Find Person

Search Project

Find or Create Company

Find or Create Product

New Row in Table

Updated Row

Add Row(s)

Clear Cells by Range

Clear Row by ID

Create Worksheet

Rename Worksheet

API Request (Beta)

Find Worksheet(s)

Get Row by ID

Find or Create Row

New/Updated Company

New Order

New Product

New Quotes

Create Company

Update Person

Create a Sales Invoice

Send a Sales-Invoice

Create Product

Create Project

Create Time Tracking

Find Account

Find Country

Search Order

Find Product

Search Quote

Find or Create Person

About bexio

Related categories

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

Related Zap Templates

Related Zap Templates