Question: how to export data from tally to excel in tally 9?
Answer: Open Data which is to be exported (Ledger/P&L or Balance Sheet)
Click Export ( Shortcut Alt E)
Esc.
Select Excel or pdf format.
Put File Name Requied.
Leave other details as it is.
Enter Enter or Ctrl A.
File Downloaded in Tally folder.