Tally TDL Excel Sales Import

I have a steady flow of sales and bank records maintained in Excel and I need a solid, reusable TDL that lets me pull that data straight into Tally ( 9 or TallyPrime). The objective is simple: click Import, point to the spreadsheet, and see each invoice appear in the Sales Voucher register with every amount, customer reference, and tax detail exactly where it belongs—no manual re-typing, no copy-paste errors.

What I need from you
• A clean, well-commented TDL file (or set of files) that reads my Excel sheet and maps its columns to the correct voucher fields in Tally.
• A quick-start guide: where to copy the TDL, how to configure the import, and how to extend the mapping if my column order changes later.
• A brief video or annotated screenshots showing one successful import on a sample company.

Acceptance check
The job is done when I can open Tally, load the TDL, choose my Excel file, and watch at least twenty test invoices import without validation errors. Totals in Tally must reconcile with the totals in Excel to the paise.

If you’ve built similar import tools or worked extensively with TDL, let me know—links or short demos are welcome.