To extract information from the ledger master to Excel, such as shown below:

To extract ledger data to Microsoft Excel

A. First click here to Enable ODBC in Tally

1. Open Microsoft Excel on your computer.

2. Click Data > Get External Data > From Other Sources > From Microsoft Query , as shown below:

3. Select TallyODBC64_9000* , as ODBC is enabled on the server 9000.

4. Click OK . The Query Wizard – Choose Columns screen appears as shown below:

5. Click Ledger and expand the list to select the required fields.

6. Click Next . The Query Wizard – Filter Data screen with the column names appears as shown below:

7. Click Next . The Query Wizard – Sort Order screen appears as shown below:

o Select Ascending or Descending for each drop down list under Sort by , as required.

8. Click Next . The Query Wizard – Finish screen appears as shown below:

o Select the option Return Data to Microsoft Office Excel .

o Click Finish . The Import Data screen appears as shown below:

9. Click OK . The Microsoft Excel sheet with the imported data appears as shown below:

Similarly, any data can be extracted from Tally.ERP 9 by using the Microsoft Excel Query Wizard.