Export tally data to excel format

My tally version is Tally 9 Release 1.0, my problum is, how to export my tally data in to excel format. in my tally export option only three option's where occuring that are as follows
1. ASCII
2. HTML and
3. XML

here how can i add excel format in to my tally

24 more comments
Anonymous May 26, 2008

same same
aniket303 Jun 18, 2008

i have tally 6.3 my data is exporting in xls format but

the all colums are coming in one colum i.e. dr. cr. date

vou. no. amt etc. pl tell be how to do separate coloum

for separate details

thanks n regards,

vrushali
satish_time Jun 23, 2008

want to learn it that how can we get result from tally to excel
priyag Jul 18, 2008

Same problem mentaioned above... how to export tally 9.0 data to xml.
madhumathi Aug 18, 2008

how to export sales and purchase in excell format
Anonymous Aug 28, 2008

Export tally data to excel format problem ?

pl give me a solution....
Anonymous Sep 08, 2008

i have tally 9 my data is exporting in xls format but
the all colums are coming in one colum i.e. dr. cr. date
vou. no. amt etc. pl tell be how to do separate coloum
for separate details

pvd
saravanann vell Oct 06, 2008
i have the same problem please solve this
i have the same problem please solve this
Anonymous Dec 29, 2008

They all are having the same prob.... since Tally 9.0....

They all supports uploads to .TXT, .XML, .HTML.....

There's an upgrade available for Tally 9.0 (Release 2.0)...

I think, it facilitates exports n uploads to .XSL Format (Excel spreadsheet)

Plz chkout n inform me if there's another solution fo dat..

SMG Soft Solutions........

[email protected]
sumipoojari Jan 15, 2009

how is export tally data to excel formate
Anonymous Feb 10, 2009

tally 7.2 have the same tally 7.2 have the same
RAMASUVA Feb 24, 2009

MY TALLY VERSION IS TALLY 7.2 MY PROBLEM IS HOW TO EXPORT MY TALLY DATA TO EXCEL FORMAT in my tally export option only three option's where occuring that are as follows
1. ASCII
2. HTML and
3. XML

here how can i add excel format in to my tally
afsar_wajid2 Feb 28, 2009

i donot know how to expor tally data in excel.
mukthakv Mar 04, 2009

my tally version is Tally 7.2 Release , my problum is, how to export my tally data in to excel format. in my tally export option only three option's where occuring that are as follows
1. ASCII
2. HTML and
3. XML
4. SDF

here how can i add excel format in to my tally
arjuntagare Mar 09, 2009

Please send how Tally data convert excel or Access directly, my email id : [email protected]
Anonymous Mar 09, 2009

how to export data from tally9 to excel sheet
pawan_dev Mar 23, 2009

my tally version is Tally 9 Release 1.0, my problum is, how to export my tally data in to excel format. in my tally export option only three option's where occuring that are as follows
1. ASCII
2. HTML and
3. XML

here how can i add excel format in to my tally
Anonymous Mar 25, 2009

HOW CAN I EXPORT FROM TALLY VERSION 9 HOW CAN I EXPORT FROM TALLY VERSION 9
Anonymous Apr 06, 2009

export tally data to excel

export tally data to excel
rawat_rawat2 Apr 07, 2009

excel formet is not show how can add excel plz
varungupta_a Apr 24, 2009

I cant Export Tally Data in Excel Format
kishor_s8 May 11, 2010

how to convert tally 9.0 data to excel sheet
Vikram Jain Oct 23, 2012

i want to how to convert tally data to any other RDBMS database
Nitu Kumari Mar 19, 2014

Download Excel to Tally Software - www.xl.nikash.in
niranjan adhikari May 22, 2014

How to convert tally 5.4 data to excel How to convert tally 5.4 data to excel
Sunny Bawany Aug 23, 2019

Export tally data to excel format
My tally version is Tally 9 Release 1.0, my problum is, how to export my tally data in to excel format. in my tally export option only three option's where occuring that are as follows
1. ASCII
2. HTML and
3. XML

here how can i add excel format in to my tally

2 Related Answers

Anonymous

1 Answer

SOURCE: my tally version is Tally 9 Release 1.0, my

whenever you are going to export any tally report into excel then press alt+e then press backspace and the will blink on the status of ascii,html,and xml options popup then choose ascii then choose condensed or deatailed then press enter.then close tally.after closing tally open excel, click file then open then choose c drive where the tally folder is installed then choose all files you see that a notepad is being created then click on it then choose colon semicolon with next and next procedure then it will automatically arrange in excel sheet.

Posted on Feb 27, 2010

Anonymous

5 Answers

SOURCE: My tally version is Tally 7.2 my problum is how

Go to 2 Point Html than give the any name of output file (for example sale register.xls) after that you can see your file in exel format.
any problem you may contact me at 09310947557 (Delhi)
Narendra Chaudhary

Posted on Jul 28, 2010

Add Your Answer

Upload

Upload an image from your computer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

Loading...

Include an image. It's worth a thousand words.

prev next

Related Questions:

0helpful

1answer

How to export tally 9 to excel sheet

Hi,
Great question and there are two way export date. Please follow step by step instruction.

In the Balance sheet screen click E : Export or press Alt+E.
Select the required language from the list of Languages displayed.
Select a format from the list of Formats displayed.
By default, the exported file will be stored in C:\Program Files\Tally.ERP 9 for Windows 7 and C:\Tally.ERP 9 for Windows XP operating systems
Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.
Press Enter to accept the default Output Sheet Name.
To update the existing file select Yes in Update Existing File.
To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
Select Yes for the Field with Colour, to retain the background colour in the exported file.

And Second:
selecting the ASCII (Comma Delimited) format, the user can export all the reports or data from Tally.ERP 9. The data exported is converted to plain text separated with commas and stored in a file with the extension .txt. This file format is widely used for emailing and used for importing data into another company using Tally.ERP 9

More information please visit this link.
http://www.tallysolutions.com/website/CHM/TallyERP9/Data_Management/Export_Formats.htm

Thanks,

Read full answer

Jun 10, 2014 • HP Office Equipment & Supplies

0helpful

1answer

EXPORT TALLY7.2 DATA INTO EXCEL SPREADSHEET

Hi,

Please follow the below step for your problem.

Go to Gateway of Tally> Balance Sheet (Here you can choose any report which you want export in tally)

Step 1: In the Balance sheet screen click E: Export or press Alt+E.

Step 2: Select the required language from the list of languages displayed.

Step 3: Select a format from the list of formats displayed.

Step 4: By default, the exported file will be stored in C:\Program files\Tally.ERP 9 for windows 7 and C:\Tally.ERP 9 for windows XP operating systems.

Step 5: Press Enter to accept the default output sheet name.

Step 6: To update the existing file select yes in update existing file.

Step 7: To format the contents of the file selects yes in Excel (Spreadsheet) formatting.

Step 8: Select yes for the filed with color, to retain the background color in the exported file.

Step 9: Accept to export the Balance Sheet to an excel file.

Thanking you

davevipul197

Read full answer

Jun 04, 2011 • Tally T2245 Matrix Printer

0helpful

1answer

The steps to export tally data in excel format?

Hi,

Please follow the below link for your problem.

http://www.apnitally.com/2007/11/export-data-from-tally-9-to-excel-more.html

you can find your answer in middle of the page.

thanking you

davevipul197

Read full answer

Jan 13, 2011 • Tally T2245 Matrix Printer

4helpful

2answers

How can i export the data tally to excel

Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls

Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.

Hope this is helpful. Let us know if the issue is resolved.

*Rating and Comments are invited for this solution

Read full answer

Nov 24, 2010 • Tally T2245 Matrix Printer

2helpful

1answer

My tally version is Tally 7.2 my problum is how to export my tally data in to excel format. In my tally export option only three option's where occuring that are as follows 1. ASCII 2. Html and 3. Xml

Read full answer

Jul 07, 2010 • Tally T2245 Matrix Printer

0helpful

1answer

My tally version is Tally 9 Release 1.0, my problum is, how to export my tally data in to excel format. in my tally export option only three option's where occuring that are as follows 1. ASCII 2. HTML and...

Read full answer

Feb 24, 2010 • Tally T2245 Matrix Printer

9helpful

3answers

Export tally data to excel

tally data to excel converting . i have some data export to excel but no excel formating you have some tally data to excel spred sheet software

Read full answer

Aug 27, 2009 • Tally T2245 Matrix Printer

0helpful

1answer

How can i export Tally Data to Excel

when u give the print commant u get an export button on the right side. Press that button and then then selest the rewuired format. XML is the genaralised format used these days. Then import the data in tally

Read full answer

Apr 30, 2009 • Tally T2245 Matrix Printer

7helpful

3answers

Export ledger tally to excell

my name is saurabh yadav

i want to know that how export my sales book ledger export to excell form tally 7.2

Read full answer

Mar 10, 2009 • Tally T2245 Matrix Printer

9helpful

4answers

How can i export tally data to excel format?

Export to Excel With new release now you would get one more options while exporting data. One added format option is Excel format.

If you export in this format then file would be saved in xls format. More over if you put Excel formating option to Yes then tally would automatically format the data in presentable format. Tally would automatically bold the headlines and main fields for you and format data in a good way. Take a look at excel snapshot of balance sheet exported from Tally.

The special thing here is that you can do the calculation on any amount figure or any row or column, which was earlier not possible. The only drawback which i could find was that amount figures are not right aligned which is must for numbers for easy calculation, although you can do it by selecting the amount figures and putting them right aligned.