Import items from Excel
Upload a spreadsheet of products and services instead of typing hundreds of rows in the item stepper.
TIM…Selected
Support🇺🇸9+
Items
Items - Items
₹ 9,886,226.00
Inventory Valuation
8
Low Stock
4
All Services
Showing 101 items
Import+ Create Item
Item nameItem codeStock qtySelling pricePurchase priceActions
Amul Taaza Toned MilkNot on AmazonTI-ITEM-1550 Packets₹ 29.00₹ 28.00
Amul Gold Full Cream MilkNot on AmazonTI-ITEM-156123 Packs₹ 33.00₹ 31.00
Mother Dairy Toned MilkTI-ITEM-15740 Packets₹ 27.00₹ 26.00
Amul Cow MilkNot on AmazonTI-ITEM-15812 Packets₹ 30.00₹ 28.50
How this looks in TiBook
How to
- 1Go to Items and open Import (toolbar or empty state when the catalog is empty).
- 2Download the sample Excel template if shown — match column headers exactly.
- 3Fill rows with name, type (product/service), prices, HSN/SAC, tax group, units, opening stock, and other columns you use.
- 4Upload the file. TiBook validates rows and flags errors (duplicate name, bad tax group, missing unit).
- 5Fix errors in the sheet or skip bad rows, then confirm the import.
- 6Review Items — imported lines are ready for invoices, POS, and stock reports.
Before you import
Create tax groups and categories in Settings first so the sheet references names TiBook already knows. Images and custom fields may need a second pass in the UI.
Updating existing items
Imports usually add new rows. To change an old item, edit it in TiBook or follow the import guide for update-by-name if your template supports it.
Start with fifty rows, import, and bill one item — then run the full catalog.
Same trick works for parties — see Import parties if you are migrating both lists.
Related articles
- Add a product or serviceOpen the item stepper from Items, choose product or service, set prices, tax, units, and stock so you can bill on the first invoice.
- Opening stock and stock adjustmentEnter opening quantity when you start on TiBook, then fix counts after a physical check with the stock adjustment modal.
- Complete the Quick Start checklistThe first-run checklist walks you through company, a party, an item, and your first invoice so the books are usable the same day.
Need more help?
Email, call, or WhatsApp the TiBook team. We can walk through invoicing, stock, POS, or your GST setup.
Open TiBook