+ Reply to Thread
Results 1 to 6 of 6

how to combine multiple google sheets data in one sheet

  1. #1
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    220

    how to combine multiple google sheets data in one sheet

    Hi All,

    we have a google spreadsheet and there we have approx 46 sheets with different different names,

    how can combine all of them in one sheet, any short method because if we use importrange we need to url of each sheet and his name its a very lengthy work

    any short method

    helppls

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,409

    Re: how to combine multiple google sheets data in one sheet

    If you are willing to use Power Query, here is a tutorial

    https://www.excelinppc.com/using-goo...n-power-query/

  3. #3
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    220

    Re: how to combine multiple google sheets data in one sheet

    i have no experience with power query,

    can we do it through google sheets or excel

    thanks for your advice alansidman

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,409

    Re: how to combine multiple google sheets data in one sheet

    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.

  5. #5
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    220

    Re: how to combine multiple google sheets data in one sheet

    Thanks alansidman

    we will do as you have suggested

    thanks

  6. #6
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Türkiye
    MS-Off Ver
    2010 - 64 Bit
    Posts
    710

    Re: how to combine multiple google sheets data in one sheet

    Alternative:

    In Google Sheets, the below formula will merge all the datas in range (A1:C500) of Sheet1, Sheet2 and Sheet3 when entered in another tab, say Sheet4;

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Combine Data from Multiple Sheets into one Sheet
    By billykiller05 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-30-2016, 05:14 PM
  2. Combine data in multiple sheets to one sheet
    By RDevi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2016, 10:44 AM
  3. Replies: 0
    Last Post: 10-12-2015, 10:02 AM
  4. Combine columns data from multiple sheets to existing master sheet via cell value
    By 253.Asmo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2015, 12:13 PM
  5. [SOLVED] Formula to combine data from multiple sheets to a summary sheet
    By laurann in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2013, 02:38 PM
  6. Replies: 7
    Last Post: 10-19-2011, 08:33 AM
  7. Combine Data from Multiple Sheets to Single Sheet
    By mpquin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2009, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1