bexio + Microsoft Excel

Update persons in bexio when new rows are added in Microsoft Excel

Keep your bexio contacts up-to-date with fresh data from Microsoft Excel without lifting a finger. With this workflow, every time a new row is added in the Microsoft Excel app, the corresponding person's information in bexio is updated immediately. This saves you time and ensures accuracy across your databases.

When this happens...
New Row
Triggers when a new row is added to a worksheet in a spreadsheet.
TriggerPolling
automatically do this!
Update Person
Updates a person.
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

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

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

Update persons in bexio when new rows are added in Microsoft Excel

New Row

New Worksheet

Add Row

Add Row to Table

Create Worksheet

Find Row

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

New Row in Table

Updated Row

Add Row(s)

Create Workbook

Update Row

Find Worksheet

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

About bexio

Related categories

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

Related Zap Templates

Related Zap Templates