"Templates are a round-trip: download the Excel file, fill it, then Bulk upload it back." Row 1 holds the headers, row 2 holds hints, and your data starts on row 3. Keep the headers exactly as they are.

Data Import templates

ImportFileRow 1 headers, in orderRowsA bad row
Supplierssuppliers_template.xlsxname, contactPerson, email, phone, address, city, state, zipCode, category, paymentTerms, status, notes150Stops the whole file
Clientsclients_template.xlsxname, email, phone, companyName, address, status, notesNot statedStops the whole file
Item catalogitems_template.xlsxname, category, unit, description, sku, brand, model, specifications, minStock, capacity, location, status, equipmentType, maintenanceTemplate. A second sheet lists units for each category.150Stops the whole file
Open enquiriesenquiries_template.xlsxclientName, clientEmail, clientPhone, clientCompany, clientAddress, projectType, projectDescription, budget, estimatedDuration, priority, status, source, notes, followUpDate150Stops the whole file
Employeesemployees_template.xlsxEmployee code, Full name, Phone, Email, Department, Designation, Date of joining, StatusSee HRMSOnly that row is rejected
AMC / service contractscontracts_template.xlsxClient name, Client phone, Client GSTIN, Contract number, Contract type, Start date, End date, Contract value, Visit frequency, Visits already completed, Machine description, Site address, Contact person, Contact phone, NotesSee ServiceOnly that row is rejected
Opening stockopening_stock_template.xlsxItem Name, SKU, Category, Unit, Brand, Model, Capacity, Quantity, Unit Price, Location, Serial Numbers, Min Stock, Supplier Name, PO Reference, Warehouse1,000Nothing is written until you confirm

Employees hints: Employee code "Optional: left blank, a code such as EMP-014 is given"; Full name and Phone "Required"; Date of joining "Optional: DD/MM/YYYY or YYYY-MM-DD"; Status "Optional: active (default), inactive, on_leave, resigned".

Opening stock hints

ColumnHint
Item NameRequired
SKUOptional: primary match key (no spaces)
CategoryRequired: pick from dropdown
UnitRequired: filtered by category
CapacityOptional (whole number for pieces/units/rolls/box)
QuantityRequired: whole number ≥ 1
Unit PriceOptional: blank = Not valued (never 0)
Serial NumbersOptional: comma-separated; count must equal Quantity
Min StockOptional: used only when a NEW item is created
Supplier NameOptional: exact match links; new name = pending supplier
PO ReferenceOptional: your old PO number (reference only)
WarehouseOptional: warehouse name; blank = your default warehouse

The file must be .xlsx or .xls, up to 1,000 rows and 2 MB.

Users template

Management › Users › Download Template gives users_bulk_upload_template.xlsx, sheet "Users".

HeaderHint
nameRequired: letters and spaces only
emailRequired: valid email address
passwordRequired: min 8 chars, include A-Z a-z 0-9 and special char (any symbol, e.g. @ # - _ !)
roleRequired: select from dropdown
phoneOptional: e.g. +919876543210
departmentOptional: e.g. Operations

Rows 3 to 102, so 100 users per file. The file must be .xlsx or .xls and under 500 KB.