Skip to content

Import items and customers from Tally, Marg, Vyapar, Busy or Excel

Export your items and customers from your old software to Excel, then bring them in with Settings › Import Data. No retyping.

Updated · 2 min read

Moving from another billing app? Export your item list and customer list to Excel there, then import the files in Galla Guru. Sizes, colours, batches and khata balances come across too.

Import a file

  1. Open Settings › Import Data (shop owner only).
  2. Choose What to import: items, customers & khata, or (for restaurants) add-ons, raw materials and recipes.
  3. Pick the software you're coming from. The app shows exactly where to export the file there, and you can Download the format if you'd rather fill in a sheet yourself.
  4. Choose the file, check how its columns were matched, and import. Rows that can't be imported are listed with the reason.

Where to find the export in your old software

Coming fromItemsCustomers
TallyDisplay More Reports › Stock Summary, then Export (Alt+E) › ExcelDisplay More Reports › Group Summary › Sundry Debtors, then Export (Alt+E) › Excel
Marg ERPReports › Stock & Inventory › Stock Status (batch-wise for a chemist), then Export › ExcelReports › Outstanding › Party-wise (Sundry Debtors), then Export › Excel
VyaparItems › ⋮ › Export Items to ExcelParties › ⋮ › Export Parties to Excel
BusyDisplay › Inventory Books › Stock Status, then Export to ExcelDisplay › Outstanding Analysis › Party-wise Balance (Sundry Debtors), then Export to Excel
PetpoojaMenu › Items, then Export (or Download menu) to ExcelCRM › Customers, then Export to Excel
Excel or otherAny sheet with a header row: Item Name, MRP, Sale Price, Stock, GST %, HSN, Batch, Expiry…Any sheet with a header row: Name, Mobile, GSTIN, City, State, Balance with Dr/Cr…

Menu names can differ between versions of those apps. Tally's Stock Summary shows cost rates, so items from Tally come in needing a selling price.

A supplier's bill

To add stock from a supplier's bill without typing it, ask the supplier to export the bill to Excel (or send the GST e-invoice JSON), then open Purchases › New purchase bill and choose Import file.

Still need help?

Open Help & Support in the app to send us a question with your shop details, or reach us directly. We answer Mon-Sat (10AM-6PM).