+ Reply to Thread
Results 1 to 6 of 6

how to combine multiple google sheets data in one sheet

  1. 11-25-2020, 01:09 PM #1
    Ajay45822
    Ajay45822 is offline
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    241

    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
    Reply With QuoteRegister To Reply
  2. 11-25-2020, 01:26 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    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/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 11-25-2020, 01:43 PM #3
    Ajay45822
    Ajay45822 is offline
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    241

    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
    Reply With QuoteRegister To Reply
  4. 11-25-2020, 01:44 PM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    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.
    Reply With QuoteRegister To Reply
  5. 11-25-2020, 02:18 PM #5
    Ajay45822
    Ajay45822 is offline
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    241

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

    Thanks alansidman

    we will do as you have suggested

    thanks
    Reply With QuoteRegister To Reply
  6. 11-26-2020, 09:46 AM #6
    Haluk
    Haluk is offline
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,147

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. combine data from multiple files/sheets into single sheet and label with file/sheet name
    By cwyn in forum Excel General
    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. Excel 2007 : Macro to combine data from multiple sheets into one sheet
    By bpatters69 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1