Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to export data from tally to excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 13-05-2009
Member
 
Join Date: Mar 2009
Posts: 37
How to export data from tally to excel
  

I want to export all my accounting data to an excel sheet as my client don't know to use Tally. if i give all that data in excel it will be easy for him to look at it even if he want to look it at home.

Reply With Quote
  #2  
Old 13-05-2009
Member
 
Join Date: Jan 2008
Posts: 3,755
Re: How to export data from tally to excel

The tally 9 is given a new & a fantastic feature for exporting the data to excel. To export data with the tally 9 is as follows :
  • In the Export Balance Sheet change the format of the export data in the excel format.

If you export in this format can be saved in file format .xls. Most of Excel if you put up the option to match yes compose data automatically in the format presentable. The control automatically "BOLD" title and the main fields for you and the data format of a good way. Take a look at the snapshot of the excellent balance of control exported.
Reply With Quote
  #3  
Old 13-05-2009
Member
 
Join Date: May 2008
Posts: 4,826
Re: How to export data from tally to excel

Export data from Tally into Excel :
  1. Start Tally. Log in with your user name and password, if any

  2. Open, your balance sheet. Click anywhere inside your balance sheet.

  3. Click on 'Export' in the menu bar or press 'Alt+E' on the keyboard.

  4. A dialogue box appears. Follow the initiative instructions step-by-step.

  5. Finally click 'yes'.

  6. Your data will be exported to the 'Tally' folder on your hard disk (C:\) as 'bsheet.xls' You can now double-click on it to view in Excel.
Reply With Quote
  #4  
Old 13-05-2009
Member
 
Join Date: Apr 2008
Posts: 4,092
Re: How to export data from tally to excel

Exporting data to excel from tally do following steps :
  1. Select ledger for export

  2. press export tab

  3. select ASCII in first place

  4. put file name.

  5. at last "yes"

  6. open new excel sheet

  7. Go to file then open then file name place type"c:\\export" then ok

  8. select " delimited" then next then select "comma" then next then
    finish...now.

  9. your data exported and save it in separate excel sheet.
Reply With Quote
  #5  
Old 16-02-2011
Member
 
Join Date: Feb 2011
Posts: 1
Re: How to export data from tally to excel

I use one component for exporting data to Excel. I think it is very useful so that I want to introduce it to you. It named Spire.DataExport.
You can download the free data export component one to evaluate if it is really useful
Reply With Quote
  #6  
Old 19-02-2011
minasshepard
 
Posts: n/a
Re: How to export data from tally to excel

This applies to Tally 7.2 and above.
1. You can export only registers and not masters
2. In any view register mode the export / import option becomes availble.
3. Click export.
4. Tally prompts you for a file name. The default name is always Tally.txt.
5. Pl rename the file to represent the ledger you are exporting else Tally will over write an existing file.
6. Tally will always save the file in the same drive / folder where Tally data resides. You cannot change this.
7. The file saved is the CSV file.
8. Open this file with Excel and map the fields.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to export data from tally to excel"
Thread Thread Starter Forum Replies Last Post
How to Export and Import DATA from Tally SoftwareGuy Tips & Tweaks 3 08-03-2012 02:18 AM
data transfer from tally to excel in a modified format. jasghuman Windows Software 1 22-08-2011 04:44 PM
Export excel data to Word 2007 Uzair Windows Software 5 25-02-2010 05:31 PM
How to export data from acess to excel Gunter Windows Software 3 13-05-2009 12:45 PM
Export Project Data to Excel Asgar Microsoft Project 3 20-06-2007 07:56 AM


All times are GMT +5.5. The time now is 08:11 PM.