+91 93584 44502 | +91 92160 90617 | support@quick2tally.com
Quick2Tally

Export Data from Tally to Excel

Tally’s normal export gives names only. To get every field (GSTIN, address, mobile, HSN, GST rate and more), use a query in Tally’s calculator pane. Or, with QuikAccount, click Fetch Ledgers from Tally on LedgerCreation, or Fetch Items from Tally on ItemCreation, to bring masters straight into Excel.

Need help? Call or WhatsApp +91 93584 44502. Free installation and demo support.

Export all ledgers

  1. In Tally, press Ctrl+N to open the calculator pane.
  2. Type Select * from Ledger and press Enter. All ledger fields are listed.
  3. Press Ctrl+E and export to Excel.
Ledger export – all fields

Export selected ledger fields

  1. Press Ctrl+N.
  2. Type Select $Name, $Parent, $LedgerMobile, $Email, $PartyGSTIN from Ledger and press Enter.
  3. Press Ctrl+E and export. Run Select * from Ledger to see other field names.
Ledger export – selected fields

Export all stock items

  1. Press Ctrl+N.
  2. Type Select * from StockItem and press Enter.
  3. Press Ctrl+E and export.
Stock item export – all fields

Export selected stock item fields

  1. Press Ctrl+N.
  2. Type Select $Name, $Parent, $BaseUnits, $Category, $_HSNCode, $_IntegratedTax, $_LastPurcPrice from StockItem and press Enter.
  3. Press Ctrl+E and export.
Stock item export – selected fields

Trusted by Businesses Across India

Happy Clients

10,000

Transactions Processed

25,15,40,200

Partners

105

Trusted by 10,000+ Tally Users

For Utility, Support and Service

Trusted by Tally users

4.9-star Google rating based on 300+ reviews

Kamal Jain, FCA, CCA
Kamal Jain, FCA, CCA 1 review

Great software, User friendly & Superb support. All GST reports show accurate results. Multiple formats for each voucher to suit our needs. Whatever format of data you have, you can export it to Tally. Good job, QuikAccount team!

Sanjay Jain
Sanjay Jain 1 review

The software is user-friendly. It provides a lot of options to cater to your needs and gives results in desired format. It also asks for minimum data and most of the fields are either auto-calculated or imported from Tally, which makes working on this software much faster.

Prachi Shah, Senior Executive
Prachi Shah, Senior Executive 1 review

Superb tool to integrate Excel data with Tally. We have imported complex e-commerce reports with this tool and it imported large data accurately and very fast. The company provides a one-click import option for multiple e-commerce platforms.

Get in touch

Share your details and we will get back to you.