Importing CSV data into Tally Software using UDIMagic
CSV (Comma Separated values) files are plain-text files having extension (.csv or .txt) that contains data-values that are separated by commas. The first line in the file must be the Header-line and is followed by data-rows. CSV files can be directly opened/ viewed in MS-Excel. This post provides a CSV file that contains Ledger-Master records. Follow the steps given underneath to import data from the CSV file into Tally 9 :- STEPS:- 1) Download and unzip the ledger-master-csv.zip file. The zip file contents are :- a) Ledger-Master.csv (Can be directly opened in MS-Excel) b) Ledger-Master.xml (Use Internet Explorer to view this file) 2) Next, start Tally and create/open any Dummy Company 3) Next, minimize Tally 4) Start UDIMagic Software 5) Select option "Excel to Tally" 6) Select option "Masters" 7) Next, select the CSV file by clicking on the Browse button. By default, only Excel-files are displayed in the list-box. You need to set the option "Files o...