Questions tagged [importrange]

This tag should be used to differentiate questions about the importation of a range of data from other questions on this site. Use when the topic is the IMPORTRANGE function. Should generally be used in conjunction with a tag for a specific app.

Filter by
Sorted by
Tagged with
1 vote
1 answer
565 views

How to create Google sheets range off of 2 separate columns

I need to create a range off of two separate columns within a sheet. Let's say column A is my index, while column D is third party index. When using VLOOKUP i can lookup my index to find 3rd party ...
1 vote
2 answers
975 views

Appending / Adding manual data input to end of IMPORTRANGE dataset

I am trying to figure out how to append / enter manual data to the end of an IMPORTRANGE list. In my spreadsheet, each tab is a month. I want to IMPORT the prior month's list (rows) and then be able ...
3 votes
2 answers
145 views

Combine different sheets with importrange for dynamic data from google forms

I have 4 identical google sheets that get continuously filled with data from 4 different google forms. I want to merge the 4 resulting sheets into one Final Sheet. Moreover I want to be able to ...
0 votes
1 answer
33 views

IMPORTRANGE sum column with condition

=SUM(IMPORTRANGE("1kWMBhk0T423p411K5_5sKOMQFdAsEDapdasYyr9gZj8","Oct!N2:N") "SELECT Col16, where Col16 contains 'Paid' )") I need to calculate only the total of paid ...
0 votes
2 answers
2k views

Import Range of cells as per today date in another sheet

There are three columns A, B, C AND today date is in the first row of the column A means A1. I need to import these three columns date excluding date row. A2:A100, B2:B100, C2:C100 in another sheet. ...
0 votes
1 answer
2k views

I want to bring in already filtered data into a new spreadsheet

Is it possible to reference filtered data from one sheet to another in Google Sheets? I use the filter button to sort in a master sheet. I then use this formula in a new sheet: =IMPORTRANGE("...
1 vote
2 answers
452 views

Updating IMPORTRANGE based on date

I have a spreadsheet I have created with multiple tabs for users to input data on Wednesday of each week. I have a cover worksheet with an IMPORTRANGE formula to pull the data from the users sheets so ...
1 vote
1 answer
536 views

Query, Import Range and Concat

I'm wanting to import whole rows of data from 'SPREADSHEET A' to 'SPREADSHEET B' but only if Column 11 in 'SPREADSHEET A' contains the text 'EXPIRED'. The data in 'SPREADSHEET A' contains about 12 ...
0 votes
1 answer
89 views

RC notation in IMPORTRANGE

Is there a way to use RC notation in the IMPORTRANGE function? What I need to do is to import a certain column, which I'm finding using MATCH in the first row (headers) =importrange("linktosheet&...
0 votes
1 answer
1k views

Dynamically reference DATA in Query in Google Sheets

I have a query in a Google Sheet structured like so: =QUERY({IMPORTRANGE(Expenses_2018Q4,"DATA_Expenses"); IMPORTRANGE(Expenses_2019Q1,"DATA_Expenses");IMPORTRANGE(Expenses_2019Q2,"DATA_Expenses")},"...
0 votes
1 answer
25 views

Return only those rows with a date on or before today using Query and Importrange

In Google Sheets I have a QUERY where I want to import only those rows where the dates in Col23 are on or before today's date. This is my current formula: =QUERY( IMPORTRANGE( "...
1 vote
1 answer
492 views

How to filter out empty cells in Google Sheets with Query & Importrange

I am trying to use this formula but it's not working. Do you hava an idea why? QUERY(IMPORTRANGE("IMPORTEDDATASHEET";"06_20!M:AJ");"SELECT SUM(Col17) WHERE Col1 = 'Company ...
1 vote
1 answer
26 views

How to combine/Link values of Spreadsheet A onto B while preserving data added on B Sheets against data coming from A?

There are two spreadsheets that are used by two teams, Team A and Team B. Team A provides directions and posts work orders to Team B. Team B in turn enters comments on the actions completed. Each team ...
1 vote
1 answer
3k views

Remove blanks in import range of multiple arrays

I have an importrange formula as below which references multiple ranges, calling the sheet URL's using the 'L Links'!Bx, reference, each 'book' having an identical sheet set. (There are actually 90 ...
1 vote
1 answer
327 views

Google sheets import columns based on date value

Google sheets for simplicity's sake say I have two tabs, one with master data and one that is a search function to display a certain part of the master data. The issue is I only want import certain ...
1 vote
1 answer
124 views

How to combine 3 sheets into one using QUERY(IMPORTRANGE)?

I am trying to combine 3 different sheets of data from range A2:O Col1, Col4, Col5, Col6, Col8, Col11, Col12, Col13, Col14, Col15 using Query({IMPORTRANGE(... function. I tried using the formula below ...
1 vote
1 answer
56 views

Downloading CSV results in empty (#ref) file. Is it a problem with IMPORTRANGE? [duplicate]

I have a multi sheet workbook in Google Sheets. I need to export a compilation of tables from this workbook to CSV. I therefore have added a new sheet where I use IMPORTRANGE to combine values from ...
0 votes
1 answer
43 views

Creating a sheet that pulls columns from other tabs

I have created a Google Sheet with multiple tabs for individual project schedules. The individual schedules have two columns: one with the tasks, a second with the project's name and the due dates. I ...
2 votes
1 answer
2k views

Dynamic updating referenced cell from another workbook after adding/deleting rows using IMPORTRANGE - use ARRAY or VLOOKUP?

I add/deleted/move rows frequently in my workbooks. When I add/remove rows from Spreadsheet#1 ("S1"), I need the referenced cell in Spreadsheet#2 ("S2") to dynamically update so it still references ...
0 votes
1 answer
2k views

ImportRange not pulling in Dates from first sheet in correct format

I'm trying to pull in a date cell from one sheet to another with an importrange function: =iferror(query(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UClhpev01z-...
0 votes
2 answers
346 views

Move existing SUM downward when IMPORTRANGE expands

I'm building a complex Google Sheets document and for one sheet I use the function IMPORTRANGE. It's very handy and imports new rows from another sheet when they are added. The problem is this: After ...
1 vote
2 answers
167 views

Formula parse error on importrange query

I'm trying to recreate what's happening in this video at 7:17 https://youtu.be/5S7laJS9meU?t=437 I want to merge two sheets and remove the empty rows. =QUERY({IMPORTRANGE(L2 ,"sheet1!A2:F20")...
1 vote
1 answer
726 views

How to use IMPORTRANGE across discontinuous columns? (Or, how to omit columns?)

How are discontinuous columns imported? Here, the import is inclusive from B3 to D7 as: Here, the formula is: =importrange("https://docs.google.com/spreadsheets/d/...
1 vote
1 answer
57 views

How to check separate sheet cell for any data, and return a Y?

I'm using several Google sheets to capture product data and optimize it. One sheet will feed data into the next, and then again into another sheet, using this formula: =IMPORTRANGE("https://url-to-...
0 votes
3 answers
2k views

Importrange with multiple criteria

Looking to countifs data from another workbook with multiple criteria. So far I have =COUNTIFS(IMPORTRANGE("URL", "Data save!$A$2:$A$5011"),">=01/04/2022") This ...
1 vote
1 answer
31 views

How to sum data on one row from multiple selected Google Sheets

I am tracking paid advertising key performing metrics on both Google & Facebook ads platforms on two separate Google Sheets, however, I'd like to combine both datas collected into one master sheet....
0 votes
1 answer
62 views

IMPORTRANGE to refer the function but not the value/result

There are 5 different spreadsheets, i.e. Master, 1, 2, 3, 4) All cell A1 in 5 different spreadsheets have the same function e.g. =count(B1:B5), they count the data in their own spreadsheet. And I want ...
1 vote
1 answer
102 views

Recalculation delays are making my spreadsheet difficult to use

I have a worksheet with 13 sheets. the largest one has 2000 rows. I have already deleted all the possible blank rows i could. I have also read all the guides on how to make a Google Sheet faster and ...
7 votes
6 answers
139k views

How to work around the IMPORTRANGE error: "Results too large"?

I'm trying to IMPORTRANGE from a range containing 240,000 cells (40 columns and 6,000 rows). The IMPORTRANGE function is erroring out with "Results too large". I can't seem to find documentation on ...
2 votes
1 answer
450 views

importing from multiple workbooks for Google Sheets to ignore workbooks that have nothing listed, instead of returning an error

={FILTER(IMPORTRANGE("116uNZi52pAQe1_D_ZLNuD18gSx3zfB1P08TL2cT7Vdk", "Trade and Manufacture!P17:T"), IMPORTRANGE("116uNZi52pAQe1_D_ZLNuD18gSx3zfB1P08TL2cT7Vdk", "...
2 votes
1 answer
144 views

Looking up two criteria in a table, one vertical, one horizontal and finding a value

I have a large table of data. Column A is names Columns C-I are monthly commissions. (Column C is March 2023, Column D is April 2023, etc) Columns C-I are going to change regularly as we are pulling ...
2 votes
1 answer
264 views

How to insert cell text from one cell into an ImportRange Function

Hello! so I have an issue where I am trying to do is have multiple functions in C, D, and E where a link is required. Instead of copying and pasting the link inside all the functions in specific ...
0 votes
0 answers
14 views

How to use IMPORTRANGE function [duplicate]

I’m just having an issue. I need to IMPORTRANGE two Google sheet tables, but in the main source table is a filter turned on. I need to connect data from column "D" with name RM and ...
1 vote
1 answer
1k views

Date Query in Google Sheets with importrange [closed]

I have two tables. Table A= Customer Feedback Table B= KPI In Table A I have a column for a date with format mm/dd/yyyy and in Table B I have 2 columns as from date and to date with the format. I ...
0 votes
1 answer
3k views

Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: D

I have data in a sheet called "PASTE HERE" that I want to import into another sheet in the same workbook. I don't want to use IMPORTRANGE because then copying the workbook would necessitate ...
19 votes
7 answers
119k views

IMPORTRANGE with preserved formatting

I am importing a certain range of data from a master sheet and would like to maintain the formatting for those cells. It seems as though this only works within a sheet: Cell reference with colour ...
1 vote
1 answer
172 views

Google Sheet ImportRange embedded in filter with RegexMatch option

I have a complicated spreadsheet with multiple tabs that filter for various things. The raw data comes from a file that I must download as a .csv file each day. Looking for a way to simplify a bit. ...
6 votes
3 answers
40k views

Query(IMPORTRANGE) function to skip columns

I'm currently using the following function to import data from one spreadsheet to another based on a value in Column K of the source spreadsheet: =QUERY( IMPORTRANGE("URL","Sheet ...
-1 votes
1 answer
91 views

Import a working formula from a different Google Sheet

I want to import a working formula from doc 1 to doc 2. I used importrange but then it importet the data from doc 1 to doc 2 and not the formula. I then used a second spreadsheet in doc 1 to show the ...
2 votes
1 answer
331 views

Does importrange not work on Google Sheets embedded XLSX files?

The ImportRange documentation mentions nothing about not supporting XLSX embedded files. But when I try it, it claims it has no permission (whereas I'm an editor in the file I try to import). Does it ...
2 votes
1 answer
42 views

IMPORTRANGE and INDIRECT combination error

I am trying to dynamically import data from another Google sheet (sheet2), to current Google sheet (sheet 1). In sheet 1, I would like to input the starting cell A2 and ending cell D20 in cells B2 and ...
0 votes
2 answers
950 views

What's the workaround to copy the link for a cell when using IMPORTRANGE?

I want to know what the correct way is to use IMPORTRANGE while it also gets the correct link for another spreadsheet. What ends up happening is that the link directs to the current file instead of ...
2 votes
1 answer
1k views

Reference entire row data or row-by-value from other sheets [closed]

I've a Google Spreadsheet where my first sheet is a Products table. The columns are SKU, Title, Price, Category, Type I've some tasks in front of me where I need to create some bundles of different ...
1 vote
1 answer
860 views

Linking a dynamic inventory price list to another file in Google Sheets [closed]

I've got a master inventory price sheet for all the ingredients we use in our recipes that I want to reference in all our recipe files to dynamically calculate costs. This way if we change suppliers ...
1 vote
1 answer
27 views

Need help filtering entire rows from reference sheet to master sheet where column text meets criteria [closed]

I feel like this should be a relatively simple issue but everything I write is clearly incorrect or leaves me needing to do work manually every time new data is made. Basically I have a series of ...
1 vote
1 answer
69 views

Help Sorting Data

I have a spreadsheet that I'm using to keep track of stats for players in a league. This is the link: https://docs.google.com/spreadsheets/d/193GxNzaX4-bGrNB8eT4vhqAOKhUrChRDgq-HYVU_Txk/edit#gid=...
0 votes
1 answer
5k views

How to reference a Google Sheet by filename?

How to reference a Google Sheet by filename? I would like to use IMPORTRANGE function, but it can only reference a file by URL not by filename. Example filename: 2018-11.xlsx 2018-12.xlsx
11 votes
4 answers
65k views

How can I merge two columns by using QUERY?

I have a master spreadsheet that contains columns like so: FirstName LastName Gender etc, etc, etc I need to import from that master sheet into another sheet that filters by one of the other ...
0 votes
2 answers
319 views

Can you do an importrange on data from multiple sheets if the data itself has an arrayformula with a textjoin?

I'm trying to summarize a bunch of sheets into one via a query([(importrange)(importrange)(etc.)}. I've done this multiple times without issue, but now the data I'm pulling is has a columns that is ...
1 vote
2 answers
90 views

Query+Importrange for multiple sheets based on values in Col26

=QUERY({ importrange("1HGW2VJFyhosCM-5AK7II6CRt19sPMsmGPbxEJvPVnK0","SUN!A3:AB5001"); importrange("1Fjbl3Ndh-thsb9ufNhJ2GgHjjIfvG1e7vUe4dNcwCew","SEA!A3:...

1
2 3 4 5