First open Tally 9 and select the company from which you want the data to be transferred. Then minimize Tally and open MS-Excel and click on Data as shown in the picture and then click on Import External Data.
Then click on New Database Query as shown in the picture.
As you click on New Database Query it will ask you to Choose Data Source. There you have to select TallyODBC.
Then select the column you want to include in the query.
Click Next after the selection is done. The data will be transferred to MS-Excel.
