Get Data from Tally to Excel using Power Query
- Alok Singh
- Mar 20, 2022
- 1 min read
Updated: Jul 10, 2024

To import data from Tally to Excel using Power Query, you can follow these steps: Set up ODBC for Tally, access Power Query in Excel, connect to Tally using the Navigator window, select the data to import, transform the data if needed, and then load the data into Excel.
Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources
What is Power Query?
Microsoft's Data Connectivity and Data Preparation technology enables users to effortlessly access data from numerous sources and modify it to suit their requirements, all through a user-friendly, interactive, code-free interface.
Thanks to Mr. Dhananjay for sharing the code, the trial balance for the period is available as an open-source Power Query.
Comments