Import data from excel to tally 7.2

YOU CANNOT IMPORT EXCEL DATA TO TALLY, 

Hi Dhara,

You can very well import Data in excel form to Tally 7.2, provided you buy the tally version 7.2. A week back we did that for one our friend's business. I 'll give full details as soon as possible.

Regards

Hari

Originally posted by : Dhara
	Does anyone know how to import data from excel to tally 7.2? There are number of transaction of sales in excel & want to import them directly in tally 7.2.

 Hi,

Directly it is not possible to import excel data to Tally.

However, you can convert that excel data to xml format (as per Tally standards) so that you can import the same into Tally.

Subramanya

ya what subramaniya said is right that the excel can be changed into xml via foxpro programe i have that programe but with few errors but i will come up with a complete one with in a month or two. Currently i am working on it 

Originally posted by : ramajayam
	ya what subramaniya said is right that the excel can be changed into xml via foxpro programe i have that programe but with few errors but i will come up with a complete one with in a month or two. Currently i am working on it

Dear Mr. Ramajayam,

please update me on hardik @ mevada.in once you have completed your excersise.

- CA Hardik Mevada

surely 

Yes we need to convert into XML to export the data to tally. 

Its very simple process.

1. make a sale entry in tally
2. Export the voucher from tally in xml format (this is to give u how the xml looks)
3. Open the excel file where all the data is ther.
4. open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility
5. in the XML which we did in step two, copy the data from "<TALLYMESSAGE xmlns:UDF="TallyUDF">" till the </TALLYMESSAGE> 
6. Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.
7. create the mail merge. 
8. copy the data what you got in word file to a note pad and name it as sample.
9. open again the step 2 - copy data from " <ENVELOPE> to <REQUESTDATA>" and paste in the begining of the notepad sample
10. go the end of the notepad sample  and copy the data from first file -"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the file
11. Open tally
12. go to import vocuhers
13. specify the path of the notepad sample and yes ur data got imported.

I hope i have explained it for ur understanding. I will be able to post any reply only after my exams - 9th May - you can mail me at rajukhatri1atgmail.com

Thanks

Dear Raju

Thanks for your explaination, your explaination is very good for the Credit Sales, my problem is my firm deals with Cash sales only inculding VAT. please tell me how to import the data from EXCEL to Tally 7.2 as the volume of the data is more

Data can be imported in Tally 7.2 and even more conveniently in Tally.ERP 9.

A program is required to be written to convert excel data to XML as it is correctly mentioned above that Tally can pull data only through XML or through its own language - TDL.

Our company is involved in lot of such tally integration and extension projects.

Please feel free to contact me at  rishabh.beria @ janusconsultrix.com for any help or if any such solution is required. 

Originally posted by : Raju
	Yes we need to convert into XML to export the data to tally.  Its very simple process. make a sale entry in tally Export the voucher from tally in xml format (this is to give u how the xml looks) Open the excel file where all the data is ther. open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility in the XML which we did in step two, copy the data from "" till the   Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher. create the mail merge.  copy the data what you got in word file to a note pad and name it as sample. open again the step 2 - copy data from "  to " and paste in the begining of the notepad sample go the end of the notepad sample  and copy the data from first file -"step 2" from "  to " and save the file Open tally go to import vocuhers specify the path of the notepad sample and yes ur data got imported.   I hope i have explained it for ur understanding. I will be able to post any reply only after my exams - 9th May - you can mail me at rajukhatri1atgmail.com Thank

The above solution posted can be extended for posting cash sales having VAT amount also. 

You would only need to export a similar entry (Cash Sales containing VAT information) from tally and continue with steps mentioned above from step 3.

Dear Mr. Ramajayam,

please update me on nagakrishnashasthri @ in.com once you have completed your excersise

i need still few days to complete it fully but right now i am preparing for exams surely come back with a good package

Dear,

Data in Tally can be imported in Tally in XML & SDF format. Presently I am working on a tool to import data in Tally in XML format.

Regards,

Manoj Garg

Originally posted by : ramajayam
	i need still few days to complete it fully but right now i am preparing for exams surely come back with a good package

Dear Ramajayam 

Pl.send your software to sk_cbe @ sify.com