Question: how to export tally data in excel file?
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.