HOW TO EXPORT ALL LEDGER DETAILS FROM TALLY TO EXCEL COLUMN-WISE WITHOUT CUSTOMISATION ?

Описание: How to export all Ledger details from Tally to Excel column-wise without Customisation ?
The default feature in Tally for exporting Ledger masters from Tally to Excel only gives the Ledger name and their Group name. From the default Tally export we will not get ledger details in column-wise.
Lets check how to Export all ledger details like Name, Group, Address, Credit period, Phone Number, Contact person, Mobile number, GSTIN number and State column-wise from Tally to Excel.
Let us also know how to fetch Ledger details only from selected Groups like Sundry Debtors and Sundry Creditors.

Please find the Text or formula required to fetch all the Ledgers details from Tally below

SELECT $NAME , $PARENT , $ADDRESS[1].ADDRESS , $ADDRESS[2].ADDRESS, $BILLCREDITPERIOD , $LEDGERPHONE , $LEDGERCONTACT , $LEDGERMOBILE , $PARTYGSTIN , $LEDSTATENAME FROM LEDGER

Please find the Text or formula required to fetch only specific Group Ledger details below

SELECT $NAME , $PARENT , $ADDRESS[1].ADDRESS , $ADDRESS[2].ADDRESS, $BILLCREDITPERIOD , $LEDGERPHONE , $LEDGERCONTACT , $LEDGERMOBILE , $PARTYGSTIN , $LEDSTATENAME FROM LEDGER WHERE $PARENT="SUNDRY DEBTORS"