IMPORTRANGE and Data Import Setup
Pull data from other files safely.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Set up reliable data imports between spreadsheets. App: [SPREADSHEET_APP]. Source file(s) and ranges: [SOURCE_FILES_AND_RANGES]. Destination layout: [DESTINATION_LAYOUT]. Who owns each file and who has access: [OWNERSHIP_AND_ACCESS]. Refresh needs: [REFRESH_NEEDS].
Provide step-by-step instructions and formulas:
1. Google Sheets: =IMPORTRANGE("spreadsheet_url_or_id", "Sheet1!A1:F") with permission approval; combining with QUERY to select columns; named ranges to keep the formula readable.
2. Excel: linking to external workbooks, Power Query (Get Data) from files, folders, and web sources, and refresh settings.
3. Importing from CSV or web tables (IMPORTDATA, IMPORTHTML, or Power Query) and the limits of web sources (terms of use, structure changes, rate limits).
4. Making imports robust: error handling, checking row counts, avoiding whole-column imports where possible, and handling headers.
5. Performance and quotas: too many imports slow the sheet; cache or consolidate.
6. Security and privacy: who can see the imported data, shared links, and removing access.
7. Documentation sheet: purpose, source, owner, last check date.
Add a test plan: modify the source and confirm the destination updates; move the source and see what breaks. Don't import personal data unless necessary and permitted.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.