Question about Tally T2245 Matrix Printer

15 Answers

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

Posted by on

  • 23 more comments 
  • Anonymous May 26, 2008

    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
    saravanann vell Oct 06, 2008

    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........

    smg007smg@gmail.com

  • sumipoojari Jan 15, 2009

    how is export tally data to excel formate

  • Anonymous Feb 10, 2009

    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 : arjuntagare@rediffmail.com

  • 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

  • Anonymous Apr 06, 2009

    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
    Nitu Kumari Mar 19, 2014

    Download Excel to Tally Software - www.xl.nikash.in

  • niranjan adhikari
    niranjan adhikari May 22, 2014

    How to convert tally 5.4 data to excel

×

15 Answers

  • Level 1:

    An expert who has achieved level 1.

    Governor:

    An expert whose answer got voted for 20 times.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

Select ASCII. Give output file name Eg:d:/exp Open the file using EXcel.Select Delimite  nexxt comma finish.Export is completed

Posted on Sep 28, 2008

  • solonan5001 Mar 29, 2011

    sir how to excel sheet exports into tally 7.2 or 9.1 please guide me to slove this solution

×

  • Level 1:

    An expert who has achieved level 1.

    Governor:

    An expert whose answer got voted for 20 times.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

How tally export to excel format.

Posted on Nov 27, 2008

  • Level 1:

    An expert who has achieved level 1.

    Governor:

    An expert whose answer got voted for 20 times.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

Hi ,

You can do 2 things , first you could export as text and import it back to excel using the text file you created , secondly you can select HTML and give the file name as eg-XYZ.xls
Regards

Sanjaya

Posted on Oct 28, 2008

  • drpamit Jan 08, 2011

    thanks friend......it works

  • sanjaya72 May 25, 2015

    cheers

×

  • Level 1:

    An expert who has achieved level 1.

    Governor:

    An expert whose answer got voted for 20 times.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

Tally 7.2, data export convert to excel direct

Posted on Aug 23, 2010

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

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 tall

Posted on Dec 25, 2012

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 2 Answers

Plz give me code how to convert excel to Tally

Posted on Apr 19, 2010

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

The problems that i've got,

is how to export data in tally 9 to ms excel or how to add new format exporting data in tally 9 such as .xls or any format exporting data




thanks

Posted on Nov 24, 2008

  • surabhi Karpe
    surabhi Karpe Apr 29, 2014

    Please give me a solution

×

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

Try using UDIMagic Free Edition to Export Tally data. Download it from http://www.rtslink.com/images/udimagic-free-edition-setup.zip

Posted on Oct 25, 2008

  • drpamit Jan 08, 2011

    hii shweta ..thanks friend

  • kalai_tamizh
    kalai_tamizh Sep 05, 2012

    Hi Shweta how to use this UDI I tried but i couldn't find

×

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 2 Answers

Learn Tally 7.2, Tally 8.1, Tally 9 @ your home.
Fee Rs.2000 PrePaid (Rs. 500 extra for study material) (weekly 3 days class, 1 hour duration / total 9 class)
Ph : 9341-202004
E-mail : shekhar202004@rediffmail.com

Posted on Feb 07, 2008

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

For export the data of tally
Command is Alt+E {or mentioned in right side top} after pressing the command, we view options to convert, Now we going top of the viewing page and select in HTML & revolution 1068x720, and click in Y .

After clicking the data is going on the target of tallyies drive


Thanking You!
with warm regards

Abhishek Sharma.
9939112087, 9304821430

Posted on Jun 10, 2009

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Tally 7.2, data export convert to excel direct

Posted on Feb 12, 2013

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

HOW REMOVE ALL DATA IN TALLY ERP9

Posted on Jun 30, 2011

×

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

Download excel to tally software - www.xl.nikash.in

Posted on Mar 19, 2014

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

1] open req. tally data to convert into excel.
2] click on E-export which is situated on left side.
3] click yes on instruction
4] then automatically generate the excel sheet.

Posted on Mar 02, 2013

  • sunil kanojia Mar 02, 2013

    1] open req. tally data to convert into excel.
    2] click on E-export which is situated on left side.
    3] click yes on instruction
    4] then automatically generate the excel sheet.
    5] try it you vll get beter ans.

    sunil kanojia [9820537771]

×

Go for release 2 version of Tally 9, where there is provision for data export to excel, check all the features, with help button.
Satish from Nashik

Posted on Jan 02, 2008

3 Suggested Answers

  • 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

Chaudhary G
  • 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

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to export tally 9 to excel sheet


Hi,
Great question and there are two way export date. Please follow step by step instruction.
  1. In the Balance sheet screen click E : Export or press Alt+E.
  2. Select the required language from the list of Languages displayed.
  3. Select a format from the list of Formats displayed.
  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
  5. 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.
  6. Press Enter to accept the default Output Sheet Name.
  7. To update the existing file select Yes in Update Existing File.
  8. To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
  9. 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,

Jun 10, 2014 | HP Office Equipment & Supplies

1 Answer

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

Jun 04, 2011 | Tally T2245 Matrix Printer

1 Answer

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

Jan 13, 2011 | Tally T2245 Matrix Printer

2 Answers

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.

tally-export-screen-300x82.gif

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.

tally-export-ready-screen-300x81.gif

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

csv-file.gif

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

Nov 24, 2010 | Tally T2245 Matrix Printer

1 Answer

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


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

Jul 07, 2010 | Tally T2245 Matrix Printer

1 Answer

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...


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.

Feb 24, 2010 | Tally T2245 Matrix Printer

3 Answers

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

Aug 27, 2009 | Tally T2245 Matrix Printer

1 Answer

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

Apr 30, 2009 | Tally T2245 Matrix Printer

3 Answers

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

Mar 10, 2009 | Tally T2245 Matrix Printer

4 Answers

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. excelexport.jpgIf 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.

excelexport2.jpgThe 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.

Feb 27, 2008 | Computers & Internet

Not finding what you are looking for?
Tally T2245 Matrix Printer Logo

24,768 people viewed this question

Ask a Question

Usually answered in minutes!

Top Tally Office Equipment & Supplies Experts

Toby
Toby

Level 1 Expert

34 Answers

mukhtar21 shaikh
mukhtar21 shaikh

Level 3 Expert

2017 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Tally Office Equipment and Supply Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...