← All integrations
Import.io + Microsoft Excel

Scrape websites into Excel

Point Power Query at the Import.io extractor’s latest-run CSV endpoint and Excel gets a table you refresh with one click, on open or on a timer.

Connects via
EndpointWebhook
Setup
3 min
Available on
Endpoints: every planWebhooks: every plan
Start free trialTalk to sales
Power Query (M)
let
    Source = Csv.Document(
        Web.Contents("…CSV from latest successful run…"),
        [Delimiter = ",", Encoding = 65001, QuoteStyle = QuoteStyle.Csv]),
    Rows = Table.PromoteHeaders(Source, [PromoteAllScalars = true])
in
    Rows

How it connects.

Source

The web

Any public page, rendered, through managed proxies

Engine

Import.io

Rendering, proxy routing, captcha handling, extraction

Path

Data endpoint

Latest successful run, CSV or JSON

Destination

Microsoft Excel

Power Query pulls the latest run into a refreshable table.

Also connects via webhooks.

What teams do with it.

Pricing models on live inputs

Competitor prices feed straight into the workbook your pricing team already trusts.

Excel files on every run

Each successful run also produces an Excel file, linked in the webhook payload.

Refresh without re-downloading

Data → Refresh All pulls the newest run into the same table and keeps your formulas.

Set it up.

  1. Copy “CSV from latest successful run” from the extractor’s Integrate tab.
  2. In Excel choose Data, Get Data, From Web, and paste the URL.
  3. Load the table, then set Query Properties to refresh on open or every N minutes.

Questions.

Does refreshing use queries?

No. The latest-run endpoint returns data the extractor already collected.

Do endpoint downloads count as queries?

No. The latest-run CSV, JSON and Google Sheets endpoints return data your extractor already collected, so they don’t count toward your plan. Only the Live Query API runs an extraction per request.

How fresh is the data?

As fresh as your schedule. Run the extractor hourly, daily or weekly and the endpoint always serves the latest successful run.

When does the webhook fire?

Every time a crawl run finishes successfully. Import.io POSTs to your URL with the extractor ID, total URL count and links to the run’s JSON, CSV and Excel outputs. You can view a sample payload in the extractor’s settings.

How do I secure the webhook?

Webhooks accept custom headers. Add a shared-secret header in the extractor’s webhook settings and reject any request that doesn’t carry it.

Related integrations.

All 50 integrations

EndpointManaged

Power BI

Web data in Power BI with scheduled refresh, or delivered into your warehouse.

Setup 5 minEndpoint

Google Sheets

One IMPORTDATA formula and the sheet refreshes itself from your extractor.

Setup 1 minEndpointManaged

Tableau

Web data in Tableau through Google Sheets or your warehouse.

Setup 10 minWebhook

Power Automate

Start Microsoft flows from Import.io runs.

Setup 10 min

Fresh web data
in Microsoft Excel.

Start free trialTalk to sales