End-of-Year Upgrade Offer
Save up to 50% on your first year. Ends December 31, 2025. Learn more >
C2W Inventory
Free Trial
Start A Free Trial
C2W Inventory
C2W Featured Guide
Managing Inventory
Labels
Configure and Print Item Labels
Print Labels For Batch Imported Items
Print Labels From Excel
Print Labels from Purchase Order
Print Labels From Sales Order
Set Up Label Printer
Manufacturing
Auto Complete Manufacturing
Bill of Materials (BOM)
Bundle Products
Complete Manufacturing Orders
Create Manufacturing Order
Create MO From Sales Order
Manage and Update Manufacturing Orders
Products
Create New Product
Create Service Products
Start Guide
Access Web App
Purchasing
Purchase Orders
Create and Manage Purchase Order Quotes
Create Purchase Orders
Make Payment
Manage Purchase Orders
Receive Purchase Order
Vendors
Create Vendors
Manage Vendors
Sales
Customers
Create Customers
Manage Customers
Sales Orders
Create and Manage Sales Order Quotes
Create Sales Orders
Manage Sales Orders
Manage SO Picking
Pick Sales Order
Print and Email Sales Order Forms
Reports
Excel Reports
C2W Inventory Settings
Users
Import. Export & Integrations
Customers
Find, Deactivate, and Reactivate Customers
Import Customer Records
Import Sales Order - Simplified Version
Import Sales Orders
Products
Adjust Inventory
Batch Import Brands
Batch Import Categories
Batch Import Payment Methods
Batch Import Payment Terms
Batch Import Shipping Methods
Batch Import Units of Measurement
Find, Deactivate, and Reactivate Products
Import Items and Beginning Stock
Import Serial Numbers
Manage Brands
Manage Categories
Manage Payment Methods
Manage Payment Terms
Manage Shipping Methods
Manage Stock Adjustments
Stock Count by Location
Unit of Measurement (UOM) Conversions
Vendors
Find, Deactivate, and Reactivate Vendors
Import Purchase Order - Simplified Version
Import Vendor-Specific Items
Import Vendor Records
Reading Time: 2 minutes

How to Batch Print Item Barcode Labels from Excel

C2W Inventory lets you copy a list of items and quantities directly from Excel into the Item Label screen, making it easy to print barcode labels for multiple items at once.

Note

C2W Inventory supports both 1D barcodes and QR codes for item labels.

Before You Start

Prepare your Excel sheet with the ItemNo and Quantity you want to print.

Important

The ItemNo in your Excel sheet must match the ItemNo already entered in C2W Inventory so the system can identify the correct item.

Batch Copy Items from Excel

01
From the Main Menu, navigate to Inventory > Item Label.
02
Turn on Batch Print.
03
In Excel, select and copy the ItemNo and Quantity for the items you want to print.
04
Click Batch Copy Items on the Item Label screen.
05
Paste the copied information into C2W Inventory.
06
Review the items and quantities in the batch print list.
Tip

If you need to remove an item from the list, select it and click Delete Selected Item.

Batch Print the Labels

Once the items and quantities are loaded:

01
Review your label settings and select the correct Printer.
02
Confirm the items and quantities in the batch print list.
03
Click Batch Print.
PRINT LABELS FROM EXCEL 1 Print Labels From Excel

C2W Inventory will print the item barcode labels based on the quantities entered from your Excel sheet.

Tip

If you need to change the barcode format or other label settings before printing, see How to Configure and Print Item Barcode Labels.

Related Guides

In this tab

A complete step-by-step video tutorial for setting up C2W Inventory.

Watch to Get Started
Scroll to Top

📧 Enter your email to subscribe and download now.