Free Excel to Tally XML Converter

FREE 100% – Upload Excel template & get XML for import in Tally 7.2, ERP 9, PRIME.

Download All Templates Demo Video Features Try Advanced Excel To Tally

Processing.....


How to free convert Excel data into Tally XML file?

  • Must Read HELP GUIDE
  • Download new Masters OR Vouchers OR Bank Excel Template file.
  • Do not change file name of downloaded Excel template.
  • Fill-up data as Excel template format.
  • Write Debit Amount in (-) minus sign.
  • To Auto use Features – Enable Excel Macros ON
  • Delete all Rows which are empty. To know empty Rows press CTRL+END key.
  • Upload file & click on GENERATE XML button.
  • Then It generates & downloads ready Tally XML file.
  • That XML file is ready for import in Tally.
  • Use Tally’s Import Data option from Gateway of Tally → Import Data → Vouchers or Masters.
  • Select the downloaded XML file and import it into your company.
  • Verify imported records in Day Book or Master List to ensure accuracy.
  • In case of error in Tally, refer to Excel validation or XML error hints shown during generation.

Excel To Tally Templates Details:

  • VCHR_VoucherAllTally: Excel template for all types of Vouchers – works with Tally 7.2, ERP 9 & Prime.
  • LEDN_LedgerAllTally: Universal Ledger creation template compatible with all Tally versions.
  • LEDS_LedgerTally7: Exclusive template for creating Ledgers for Tally 7.2 and ERP 9 only.
  • BANK_AllTally: Bank ledger Excel format for Bank Statements Transaction with all Tally Versions.
  • Auto_Menu: Press F1 to open Auto Menu for validate data, remove errors, Auto make Dr/Cr Ledgers values, & more.
  • Macros Enabled Templates: All templates are macros-enabled (.xlsm) to enable automated data processing.
  • Data Validation Applied: Templates include strong validation rules to avoid import errors in Tally.
  • Uniform Structure: Templates maintain fixed column order and naming to ensure accurate XML conversion.
  • Multiple Voucher Support: Voucher template supports entries like Payment, Receipt, Contra, Journal, Sales & Purchase.

Free Excel to Tally Features –

  • Totally free 100% – No need to pay for subscriptions.
  • Secure process: No data is stored on the server after conversion.
  • Upload Excel template file up-to 1 MB size.
  • Unlimited convert Excel data into Tally XML file.
  • Included All templates modules of Masters & Vouchers.
  • Get free access of all upcoming new templates modules.
  • No need of Log-in OR Sign-up.
  • Donate Now – To Help us build more.
  • Import all types of vouchers: Receipt, Payment, Contra, Journal, Sales, Purchase, Credit Note, Debit Note.
  • Import various Excel bank statement formats into Tally.
  • Import master ledgers with comprehensive fields including addresses and GST numbers.
  • Auto-generate Tally XML files for vouchers, masters & Bank directly from Excel data.
  • Use ‘AUTO MENU’ in templates to automatically assign Debit/Credit ledger amounts.
  • No need to manually mention DR/CR amounts; the system auto-calculates them.
  • Supports multi-ledger debit and credit voucher entries, accommodating up to 30 ledgers per voucher.
  • Strong data validation to ensure accuracy and remove data errors.
  • Fully automated data processing for quick and efficient conversions.
  • Compatible with Tally Prime, ERP 9, Tally 7.2, and higher versions.
  • Online utility accessible from anywhere without the need for additional software.
  • User-friendly Excel templates designed for ease of use.
  • Average import speed of 5000 records per minute.
  • Standard easy sheet templates with strong data validations and error reports.