Contact
12 programs
Explore the site

Zoho Sheet · Data preparation and connections · Intermediate

Import and refresh URL or feed data with explicit source limits

Use Data → Data Connection → Connect URLs for a supported public source, reserve an import area, and verify source freshness separately from formula recalculation.

Editorial standards

Quick answer

Use Data → Data Connection → Connect URLs for a supported public source, reserve an import area, and verify source freshness separately from formula recalculation.

Before you start

Zoho Sheet web editor in an English desktop browser; rolling service, official documentation reviewed 20 October 2026. Not desktop-app or mobile instructions. Use an editable practice file containing only synthetic data. Keep the original unchanged and record the file name and storage location so that you reopen the same copy. These are documentation-based instructions and independently checked examples, not a claim of native application testing.

Define a controlled source

Use a small public CSV or feed that you control and are permitted to import. For a repeatable CSV test, publish a two-column file with headers Item,Units and records Blue,12 and Green,8 at your own stable HTTPS URL. This tutorial does not provide a live endpoint or promise that an arbitrary webpage is a structured data source.

Before connecting, open the URL yourself and confirm it returns the intended content without a login, secret token or personal information in the address. Do not paste a URL containing an API key into a workbook. A source behind authentication needs an appropriate authorized connection, not a public-URL workaround.

In the destination workbook, leave A1:B20 empty. Put Imported stock in D1 and plan a total in D2 outside the import footprint. Reserving extra rows prevents routine growth from colliding immediately with annotations.

Connect the data

  1. Open Data → Data Connection → Connect URLs.
  2. Choose the source type offered for your file or feed. Enter the verified source URL in the corresponding dialog field; if its type is not supported, stop rather than choosing an unrelated parser.
  3. Set the destination to A1 on the intended worksheet. Check the sheet name as well as the cell address.
  4. Choose the displayed refresh setting appropriate to the account. Start with the least frequent option needed for this test; schedule availability and limits depend on the plan.
  5. Confirm with OK and inspect the imported result before building calculations on it.

Expect two data records, distinct Item and Units columns, and numeric values 12 and 8. Enter =SUM(B2:B3) in D2; expect 20. If every record lands in one column, inspect the source format or delimiter rather than manually rearranging a refresh-managed area.

Prove a refresh changes the data

Change Blue’s source value from 12 to 15 while leaving the URL stable. In Zoho Sheet, open Data → Data Connection → Manage Connections → Data Links and refresh the relevant link. Compare the imported rows with the current source: Blue 15, Green 8, total 23.

Do not use F9 as proof that the external source was fetched. Recalculating a formula over old imported values can produce a perfectly correct but outdated total. Keep a visible note recording the source and the time you actually verified the latest records.

Inspect limits and ownership

The connection documentation distinguishes account plan limits, refresh schedules and link ownership. Do not assume another collaborator can edit or refresh a link you created. Test that role explicitly before asking someone else to operate the report.

A successful two-record import does not establish that a larger source is complete. Compare record counts, stable IDs and a control total when using production data. Source-side changes to headers, ordering or access can break the mapping or leave downstream formulas pointing at the wrong field.

Recover safely

If a refresh fails, retain the previous values only with a clear stale-data warning. Do not replace missing records with zeros. Inspect the URL and format first, then the link’s status and account permissions. Keep manual corrections outside the imported area because the next refresh may overwrite it.

Before handing off the workbook, reopen it and repeat the source-to-sheet comparison. If you distribute a static export, label its verification time and do not imply that the downloaded copy has the same live connection.

Continue with csv import preserve leading zeros.

Official sources

Documentation reviewed 20 October 2026.