Google Sheets: Admin has not allowed imports from this URL
Last verified
Admin has not allowed imports from ...What it means
In a Google Workspace organization, administrators can restrict which external URLs spreadsheets may pull data from. When an import function points at a URL outside what the admin allows, Google returns this message and tells you to contact your admin to allow imports from that URL.
This is a policy decision, not a technical failure. The same formula would work in a personal Google account or in another organization with a different policy.
What is not wrong: the URL, the XPath, or the target site. Nothing you change in the formula will clear it.
What it looks like
=IMPORTDATA("https://data.example.org/rates.csv")
Error
Admin has not allowed imports from [the URL in the formula]Why it happens
- Your Workspace admin has limited external data access for Sheets in your organization.
- The domain you are importing from is not on your organization's allowed list.
- You moved a working spreadsheet from a personal account into a managed Workspace account.
- Your organizational unit has a stricter policy than colleagues in other units.
How to fix it
- Note the full URL from the message and the business reason for the import.
- Ask your Workspace administrator to allow imports from that URL or domain.
- While you wait, check whether the same data is available from an internal, already-allowed source.
- Do not work around the policy by copying the file to a personal account; that can breach your organization's data rules.
How to stop it recurring
When a reporting spreadsheet depends on external URLs, list those domains when the sheet is first built and get them approved by IT before rollout. Keeping external sources to a short, documented list makes approvals and audits straightforward, and avoids broken reports when policies tighten.
Official documentation: support.google.com/docs/answer/12188454. See all Google Sheets error messages or the Google Sheets limits and quotas.
Related errors
Definitions
Quick answers
What does "Admin has not allowed imports from this URL" mean in Google Sheets?
In a Google Workspace organization, administrators can restrict which external URLs spreadsheets may pull data from. When an import function points at a URL outside what the admin allows, Google returns this message and tells you to contact your admin to allow imports from that URL. This is a policy decision, not a technical failure.
How do I fix "Admin has not allowed imports from this URL"?
1. Note the full URL from the message and the business reason for the import. 2. Ask your Workspace administrator to allow imports from that URL or domain. 3. While you wait, check whether the same data is available from an internal, already-allowed source. 4. Do not work around the policy by copying the file to a personal account; that can breach your organization's data rules.
When an IMPORT formula cannot read the page
IMPORTXML and IMPORTHTML only see the HTML the server sends. An Autonoly extraction step reads the page in a real browser and writes rows to Google Sheets. Sites that block automated visitors can still block it.
Also see Google Sheets integration.