Always required Excel in a business or accounting to maintain books of income, expenses and taxes etc. Excel is most usable software for calculations/presentations for a business. And also lots of businesses use Tally to maintain books properly. If it possible to connect Tally with Excel to fetch Tally Data into Excel then our most of problems will be solved. This Tally to Excel data import method will be “Sanjeevani” for CA and accountants.
So this can possible through Excel Power Query and Tally ODBC connectivity. To Import Tally Data into Excel most powerful and fastest way is Excel Power BI. We can import any report of Tally directly into excel through this Power BI method.
After reading this post you will be able to import GST summary from Tally to Excel and can refresh it every time after any changes.
Required Tools/Codes to connect Tally with Excel:
1. Microsoft Excel
2. Tally Software
3. Tally ODBC URL
4. XML Schema for Export
5. Report Name
Follow below Steps to Import Data from Tally to Excel:
1. Open Tally and Excel
2. Go to Excel Data Tab – New Query – From Other Source – Blank Query
3. We can change Query Name in properties section at right hand side.