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.
Printable View
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.
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.
Export data from Tally into Excel :
- Start Tally. Log in with your user name and password, if any
- Open, your balance sheet. Click anywhere inside your balance sheet.
- Click on 'Export' in the menu bar or press 'Alt+E' on the keyboard.
- A dialogue box appears. Follow the initiative instructions step-by-step.
- Finally click 'yes'.
- 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.
Exporting data to excel from tally do following steps :
- Select ledger for export
- press export tab
- select ASCII in first place
- put file name.
- at last "yes"
- open new excel sheet
- Go to file then open then file name place type"c:\\export" then ok
- select " delimited" then next then select "comma" then next then
finish...now.
- your data exported and save it in separate excel sheet.
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
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.