top of page
  • White Facebook Icon
  • White Twitter Icon
Search

Get Data from Tally to Excel using Power Query

Updated: Jul 10, 2024

ree

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


© 2023 Impact Education India. All rights reserved.

bottom of page