Connect Cin7 Core Inventory and Microsoft Excel to unlock the power of automation

No credit card required
Free forever for core features
14-day trial for premium features and apps

Choose a Trigger

Choose an Action

Set up your first integration

Quickly connect Cin7 Core Inventory to Microsoft Excel with a Zapier template.

Our most popular template

Automate new or updated purchases in Cin7 Core Inventory by adding rows in Microsoft Excel
Details
Try it
Cin7 Core Inventory + Microsoft Excel
Add new sale shipments in Cin7 Core Inventory for updated rows in Microsoft Excel
Details
Try it
Microsoft Excel + Cin7 Core Inventory
Add rows in Microsoft Excel for new or updated products in Cin7 Core Inventory
Details
Try it
Cin7 Core Inventory + Microsoft Excel
Update api requests in Cin7 Core Inventory upon modification of rows in Microsoft Excel
Details
Try it
Microsoft Excel + Cin7 Core Inventory

Automate new or updated purchases in Cin7 Core Inventory by adding rows in Microsoft Excel

Details

Try it

Cin7 Core Inventory + Microsoft Excel

Add new sale shipments in Cin7 Core Inventory for updated rows in Microsoft Excel

Details

Try it

Microsoft Excel + Cin7 Core Inventory

Add rows in Microsoft Excel for new or updated products in Cin7 Core Inventory

Details

Try it

Cin7 Core Inventory + Microsoft Excel

Update api requests in Cin7 Core Inventory upon modification of rows in Microsoft Excel

Details

Try it

Microsoft Excel + Cin7 Core Inventory

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

How Zapier works

Zapier makes it easy to integrate Cin7 Core Inventory with Microsoft Excel - no code necessary. See how you can get setup in minutes.

100%

Help

1. Choose trigger event

2. Choose action

1. Select the event

Setup

Test

App

Trigger event

Choose a trigger event

Choose a trigger

A trigger is the event that starts your Zap—like a "New Customer / Updated Customer" from Cin7 Core Inventory.

Add your action

An action happens after the trigger—such as "Add Row" in Microsoft Excel.

You’re connected!

Zapier seamlessly connects Cin7 Core Inventory and Microsoft Excel, automating your workflow.

Supported triggers and actions

Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.

- Status
  Required
Trigger
Instant
Try It
- Status
  Required
Trigger
Instant
Try It
Sale Attachment Added
Triggers when an attachment is added to a sale
Trigger
Instant
Try It
New Sale
Triggers when a new sale is created.
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It

- Event Type
  Required
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It

- Status
  Required
Trigger
Instant
Try It
- Name
  Required
- Currency
  Required
- Payment Term
  Required
- Discount
- TaxRule
  Required
- Carrier
- Sales Representative
- Location
- Comments
- Account Receivable
  Required
- Revenue Account
  Required
- Price Tier
- Tax Number
- On Credit Hold
- AttributeSet
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Tags
- Line1 (required when Addresses provided)
- Line2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Sale ID
  Required
- Payment Type
- Reference
- Amount
  Required
- Date Paid
  Required
- Account
  Required
- Currency Rate
  Required
Action
Write
- Customer
  Required
- Contact
- Phone
- Email
- Order Date
- Sale Account
- SKU
  Required
- Quantity
  Required
- Price
  Required
- Tax
  Required
- Total
  Required
- Line Order
- Discount
- Sale Account
- Tax Rule
  Required
- Comment
- DropShip
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address State
- Billing Address Postcode
- Billing Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State
- Shipping Address Postcode
- Shipping Address Country
- Shipping Address Contact
- Shipping Address Company
- Shipping Address Ship To Other
- Carrier
- Ship By
- Tax Rule
- Tax Inclusive
- Terms
- Price Tier
- Location
- Note
- Customer Reference
- Invoice Status
- Order Status
- AutoPickPackShip Mode
- Sales Representative
- Invoice Date
- Invoice Due Date
- Currency Rate
- Order Memo
- Invoice Memo
- Reference
- Amount
- DatePaid
- Account
- Currency Rate
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
Action
Write
- Effective Date
  Required
- Account
- Reference
- SKU
  Required
- Quantity
  Required
- Unit Cost
  Required
- Location
  Required
- Batch Serial Number
- Expiry Date
- Comments
Action
Write
- Name
  Required
- Currency
  Required
- Payment Term
  Required
- Discount
- Tax Rule
  Required
- Comments
- Account Payable
  Required
- Tax Number
- Attribute Set
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Line 1 (required when Addresses provided)
- Line 2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Product ID
  Required
- SKU
  Required
- Name
  Required
- Category
  Required
- Brand
- Type
  Required
- Costing Method
  Required
- DropShip Mode
- Length
- Width
- Height
- Weight
- Unit of Measure
  Required
- Weight Unit of Measure
- Dimensions Unit of Measure
- Barcode
- Minimum Before Reorder
- Reorder Quantity
- Price Tier 1
  Required
- Price Tier 2
- Price Tier 3
- Price Tier 4
- Price Tier 5
- Price Tier 6
- Price Tier 7
- Price Tier 8
- Price Tier 9
- Price Tier 10
- Short Description
- Description
- Tags
- Stock Locator
- Pick Zones
Action
Write
- ID
  Required
- Name
  Required
- Currency
  Required
- PaymentTerm
  Required
- Discount
- Tax Rule
  Required
- Comments
- Account Payable
  Required
- Tax Number
- Attribute Set
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Line 1 (required when Addresses provided)
- Line 2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Assembly Status
- Search
- Sale ID
Action
Search
- Sale ID
- Order Number
- Invoice Number
- Credit Note Number
Action
Search
- Product ID
- Product Name
- Product SKU
Action
Search
- Task ID
  Required
Action
Search
- Sale ID
  Required
Action
Search
- Name
  Required
- Contact Name / Email
- Currency
  Required
- Payment Term
  Required
- Discount
- TaxRule
  Required
- Carrier
- Sales Representative
- Location
- Comments
- Account Receivable
  Required
- Revenue Account
  Required
- Price Tier
- Tax Number
- On Credit Hold
- AttributeSet
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Tags
- Line1 (required when Addresses provided)
- Line2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
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
- Title
  Required
- Column Headers
- Zap_step_id
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Search or write

- Status
  Required
Trigger
Instant
Try It
Sale Additional Info Added
Triggers when an additional information is added to a sale
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It
Sale Credit Note Authorised
Triggers when a sales credit note authorised.
Trigger
Instant
Try It
Sale Invoice Authorised
Triggers when a sales invoice authorised.
Trigger
Instant
Try It
Sale Shipment Tracking Number Changed
Triggers when a sale's shipment tracking number changed.
Trigger
Instant
Try It
Stock Level Update
Triggered when a change is made to product availability.
Trigger
Instant
Try It
- Sale ID
  Required
- File Name
  Required
- Is Processed
- File Content
- File Download URL
Action
Write
- Sale ID
  Required
- Status
  Required
- SKU
  Required
- Location
  Required
- Package #
- Quantity
  Required
- Batch Serial Number
- Expiry Date
Action
Write
- SKU
  Required
- Name
  Required
- Category
  Required
- Brand
- Type
  Required
- Costing Method
  Required
- DropShip Mode
- Length
- Width
- Height
- Weight
- Unit of Measure
  Required
- Weight Unit of Measure
- Dimensions Unit of Measure
- Barcode
- Minimum Before Reorder
- Reorder Quantity
- Price Tier 1
  Required
- Price Tier 2
- Price Tier 3
- Price Tier 4
- Price Tier 5
- Price Tier 6
- Price Tier 7
- Price Tier 8
- Price Tier 9
- Price Tier 10
- Short Description
- Description
- Tags
- Stock Locator
- Pick Zones
Action
Write
- Sale ID
  Required
- Keep Existing Shipment Lines
- Status
  Required
- Require By Date
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State
- Shipping Address Postcode
- Shipping Address Country
- Shipping Address Contact
- Shipping Address Company
- Shipping Address Ship To Other
- Shipping Notes
- Shipment Date
  Required
- Carrier
- Package #
  Required
- Tracking Number
Action
Write
- From Location
  Required
- To Location
  Required
- Departure Date
  Required
- Completion Date
  Required
- Reference
- SKU
  Required
- Transfer Quantity
  Required
- Batch Serial Number
- Expiry Date
- Comment
Action
Write
- ID
  Required
- Name
- Currency
- Payment Term
- Discount
- TaxRule
- Carrier
- Sales Representative
- Location
- Comments
- Account Receivable
- Revenue Account
- Price Tier
- Tax Number
- On Credit Hold
- AttributeSet
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
- Tags
- Line1 (required when Addresses provided)
- Line2
- City
- State
- Postcode
- Country (required when Addresses provided)
- Type (required when Addresses provided)
- Default For Type
- Name (required when Contacts provided)
- Job Title
- Phone
- Mobile Phone
- Fax
- Email
- Website
- Default
- Comment
- Include In Email
Action
Write
- Sale ID
  Required
- Customer
  Required
- Contact
- Phone
- Email
- Order Date
- Sale Account
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address State
- Billing Address Postcode
- Billing Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State
- Shipping Address Postcode
- Shipping Address Country
- Shipping Address Contact
- Shipping Address Company
- Shipping Address Ship To Other
- Carrier
- Ship By
- Tax Rule
- Tax Inclusive
- Terms
- Price Tier
- Location
- Note
- Customer Reference
- Sales Representative
- Currency Rate
- Additional Attribute 1
- Additional Attribute 2
- Additional Attribute 3
- Additional Attribute 4
- Additional Attribute 5
- Additional Attribute 6
- Additional Attribute 7
- Additional Attribute 8
- Additional Attribute 9
- Additional Attribute 10
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Customer Name
- Contact Name / Email
Action
Search
- Page number
  Required
- Limit per page
  Required
- ID of product
- Name of product
- Sku of product
- Non Zero Products Only
  Required
- Location
- Batch #
- Category
Action
Search
- Task ID
  Required
Action
Search
- Task ID
  Required
Action
Search
- Search
- Status
Action
Search
- 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 Name
  Required
- Column Headers
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
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search or write

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

G2 Badge - Most Implementable - Winter 2024

G2 Badge - Leader Mid-Market - Winter 2024

93%

Customers who say using Zapier has made them better at their job

25m

Customers have created over 25 million Zaps on the platform

6 mins

The average user takes less than 6 minutes to set up a Zap

Practical ways you can use Cin7 Core Inventory and Microsoft Excel

Track sales data in Excel for performance monitoring.

Zapier automatically logs new sales from Cin7 Core Inventory into a Microsoft Excel spreadsheet, creating a clear and organized view of your revenue data. With each new sale, a new row is added to an Excel worksheet, making performance tracking straightforward and eliminating manual data entry.

Business Owner

Try it

Export inventory updates to Excel for analysis.

Zapier automates the exporting of inventory updates from Cin7 Core Inventory to Microsoft Excel. Every time a product availability change is detected in Cin7, Zapier will add the updated product data as a new row in an Excel worksheet. This allows data scientists to analyze changes and trends in inventory with greater accuracy and efficiency.

Data Science

Try it

Log inventory changes to Excel for project tracking.

When Cin7 Core Inventory detects updates to product stock levels, Zapier logs these changes in a Microsoft Excel file. Project managers can use these up-to-date records to monitor inventory impacted by ongoing projects, ensuring alignment and reducing the risk of stockouts or project delays.

Project Management

Try it

Learn how to automate Microsoft Excel on the Zapier blog

Make work flow with AI

Level up your Cin7 Core Inventory to Microsoft Excel integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.

Learn about AI automation

About Cin7 Core Inventory

Cin7 Core Inventory is an all in one holistic solution for Inventory Management, POS & B2B eCommerce. Easily manage all your inventory, purchases, sales, suppliers and customers in one easy to use system.

HelpHelp

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

Connect Cin7 Core Inventory and Microsoft Excel to unlock the power of automation

Set up your first integration

Automate new or updated purchases in Cin7 Core Inventory by adding rows in Microsoft Excel

Add new sale shipments in Cin7 Core Inventory for updated rows in Microsoft Excel

Add rows in Microsoft Excel for new or updated products in Cin7 Core Inventory

Update api requests in Cin7 Core Inventory upon modification of rows in Microsoft Excel

Automate new or updated purchases in Cin7 Core Inventory by adding rows in Microsoft Excel

Add new sale shipments in Cin7 Core Inventory for updated rows in Microsoft Excel

Add rows in Microsoft Excel for new or updated products in Cin7 Core Inventory

Update api requests in Cin7 Core Inventory upon modification of rows in Microsoft Excel

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

How Zapier works

Choose a trigger

Add your action

You’re connected!

Supported triggers and actions

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

Practical ways you can use Cin7 Core Inventory and Microsoft Excel

Track sales data in Excel for performance monitoring.

Export inventory updates to Excel for analysis.

Log inventory changes to Excel for project tracking.

Learn how to automate Microsoft Excel on the Zapier blog

How to automatically copy rows between Excel spreadsheets

5 ways to automate Microsoft Excel

How to connect Google Sheets with Excel

Make work flow with AI

Connect Cin7 Core Inventory to Microsoft Excel on the world's largest no-code automation platform