Import products, customers, and opening stock from Excel or CSV into Tiram

The import wizard exists for two moments: switching to Tiram from Tally, Vyapar, Excel, or another billing tool with an existing product and customer list, and simply starting with a catalog you've already built in a spreadsheet rather than typing every SKU in by hand. Either way, the goal is the same — get your existing data into Tiram once, correctly, instead of re-entering it product by product.

1. Choose data — pick exactly one dataset to import: Products, Customers, or Opening stock. You can run the wizard again for the others afterward. 2. Upload file — a CSV or XLSX exported from Tally, Vyapar, Excel, or any other tool. 3. Match columns — map your file's column headers to Tiram's fields; Tally's own column names are detected automatically, so most Tally exports need little to no manual mapping. 4. Review rows — every row is validated before anything saves, with errors fixed inline, right in the browser. 5. Import — commit the reviewed rows to your account.

Products expects SKU, name, price, GST rate, HSN code, and unit — the same fields you'd fill in one at a time on the product form, just for your whole catalog at once. Customers expects name, phone, GSTIN, address, and any opening balance you want to carry over (so a customer's existing khata dues aren't lost in the switch). Opening stock expects a product reference, warehouse, and quantity on hand, and needs products imported first since each stock row has to match an existing product.

Tiram's column-matching step recognizes common Tally export column names automatically, so a typical Tally product or customer export maps itself with little manual work. Any column that doesn't map automatically can be matched by hand — nothing about the wizard requires your source file's headers to match Tiram's field names exactly.

The wizard's Review rows step exists precisely so a messy export doesn't create messy data in Tiram — every row is checked before any of it is written to your account, and rows with problems (a missing required field, an invalid GST rate, a malformed phone number) are flagged for you to fix inline rather than silently skipped or silently accepted. You commit only once you're satisfied the reviewed data is correct.

The import wizard — for products, customers, and opening stock — is included on every Tiram plan — Silver, Gold, and Platinum — on both the cloud app and the offline Windows/Mac desktop app. There's no limit on how many times you can run it; import products today and customers next week without any restriction.