Share via

I want an alternative of google sheet's import range and query function in excel online or dektop which helps to transfer data on real time or if not real time than while rfreshing into another sheet and vice versa for only limited data

Chandra Prakash Nagar 0 Reputation points
2025-08-06T07:12:52.6933333+00:00

I have 71 sheets in excel one is master sheet and other are branches sheets, in which whenever any branch will update their data in their own sheet it should reflect into concern sheet of another workbook that is master sheet and when a column is updated in master sheet it should reflect into concern branch sheet.
For example, I have a workbook which is master sheet and 70 branches sheet according to which there are 70 sheets in master workbook.
So suppose when i update column A to N in any branch workbook it should reflect in its concern branch sheet of master workbook and when i update the respective branch sheet's column O it shoulfd reflect into branch sheet. How do i Do that.
It was very easy in google sheet with importrange and query function.

Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rin-L 1,755 Reputation points Microsoft External Staff Moderator
    2025-08-06T08:37:28.7266667+00:00

    Hi @Chandra Prakash Nagar, 

    Thank you for posting your question in the Microsoft Q&A forum. 

    I understand your requirement clearly. Unfortunately, Excel does not have a direct equivalent to Google Sheets' IMPORTRANGE and QUERY functions that allow real-time two-way data sync between workbooks. This is one of Excel’s current limitations. 

    From what I’ve researched, Power Query is the closest feature in Excel to IMPORTRANGE. However, it only supports one-way data import, and requires manual or scheduled refresh - it does not work in real time. 

    Alternatively, you might consider using Power Automate, which allows you to create automated flows to sync data between files. This could help you achieve your desired result, although it may require some setup and testing, and it may seem quite complicated.

    For your reference: Official Microsoft Power Automate documentation - Power Automate | Microsoft Learn 

    Note: As this category focuses on Office 365 products, I regret to inform you that Power Automate falls outside my support scope. I have limited resources and knowledge in that area.  That said, I truly want to help you as much as I can. If you're serious about implementing this solution, I recommend posting a thread in the Microsoft Power Platform Community Forum Thread , where you'll find the most qualified group of respondents. Other partners who regularly read the forums can also share their insights or learn from your experience. 

    As a Microsoft Community Support Specialist, I cannot change product limitations, and I understand this might be frustrating. However, I hope the information I’ve provided is still helpful to you.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

    User's image

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.