IMPORTRANGE Helper
Overview
Generate Google Sheets range and IMPORTRANGE formulas with optional text and number filters
Create Google Sheets formulas without writing them manually. IMPORTRANGE Helper generates ready-to-paste formulas for transferring data between sheets in the same file or importing it from another spreadsheet—with optional text and number filters. Work from a convenient Chrome side panel that stays open while you select cells and configure your formula. FOUR FORMULA MODES • IMPORTRANGE — no filter • IMPORTRANGE — with filter • Same file — no filter • Same file — with filter HOW IT WORKS 1. Select a source range in Google Sheets. 2. Open the extension and click “Use selected range.” 3. Choose a formula mode. 4. For filtered results, type or paste a column header and value, then select a condition. 5. Click “Generate formula,” then “Copy.” 6. Paste the formula into an empty area of the destination sheet. FLEXIBLE FILTERING Text conditions: • Equals (=) • Does not equal (≠) • Contains (= Contains...) • Does not contain (≠ Contains...) Number conditions: • Greater than (>) • Less than (<) • Equals (=) • Does not equal (≠) • Greater than or equal (≥) • Less than or equal (≤) • Between two values, including both boundaries Use negative numbers, zero, positive numbers, and decimals. Add multiple conditions and combine them with AND or OR. FILTER BY COLUMN HEADER Enter the column’s header instead of its letter or position. Generated formulas look up the header when the spreadsheet recalculates, so moving columns within the source range does not break the filter. The first selected row must contain the headers. Each referenced header must be unique and match the spelling and case in the source sheet. Headers are preserved in filtered results. INCLUDE FUTURE ROWS “Include all rows” is enabled by default. A selection such as A1:O300 becomes A1:O, allowing the formula to include new rows. Turn it off to keep the exact selected range. BUILT FOR EVERYDAY USE • Automatically detects the spreadsheet ID, sheet name, and selected range address. • Remembers your source range and filter settings locally. • Accepts typed or pasted headers and values. • No Google Apps Script or separate Google API sign-in required. • Generates linked results that update as the source data changes. IMPORTANT NOTES • The extension generates formulas; Google Sheets processes the data after you paste them. • The first import between spreadsheet files may require you to click “Allow access” in Google Sheets. • Formulas use semicolon argument separators. Your destination spreadsheet must support this format. • Text comparisons ignore case. Numeric conditions apply to numeric cells. • Results contain cell values, not source formatting. • Renaming a referenced header or moving its column outside the source range requires updating the formula. • Chrome 116 or later is required.
0 out of 5No ratings
Details
- Version1.1.4
- UpdatedOctober 31, 2026
- Offered byBorisandmarina
- Size40.73KiB
- LanguagesEnglish
- DeveloperБорис Альянаки
Преображенська 4 15 Киев, місто Київ 03037 UAEmail
borisandmarina@gmail.comPhone
+49 171 2112879 - TraderThis developer has identified itself as a trader per the definition from the European Union and committed to only offer products or services that comply with EU laws.
Privacy
This developer declares that your data is
- Not being sold to third parties, outside of the approved use cases
- Not being used or transferred for purposes that are unrelated to the item's core functionality
- Not being used or transferred to determine creditworthiness or for lending purposes