Here's a video that shows how to use the template Vouchers-V8-Sales-Purchase.xls to upload GST Sales and Purchase using udiMagic v8.0

Video  :
How to import GST Sales, Purchase from Excel to Tally?

Some basic guidelines

  1. In most of the Standard templates, the first row is for headings and data starts from row no 2.
  2. If a blank row (or blank date or blank unique-id) is found, udiMagic stops further processing.
  3. You must always start Tally first and then start udiMagic software.
  4. By default, the Ledgers, StockItems and other masters are created automatically before uploading / creating vouchers in Tally ERP. If you do not want to create Masters but only create/upload Vouchers, then disable the option "Create dependent masters" using the Settings button in udiMagic.

For more information :

Watch the Getting Started tutorials