Microsoft Excel

How to integrate Microsoft Excel with Webflow

Excel has no native Webflow integration. Three methods connect the platforms: CSV imports for one-time migrations under 4MB, automation platforms like Zapier and Make for scheduled updates without code, and custom API integration using Microsoft Graph and the Webflow CMS API for bidirectional sync.

Each method suits different technical requirements. CSV works for manual data loads, automation platforms handle recurring syncs, and API development provides full control for complex workflows requiring custom business logic.

CSV import for manual migration

Export Excel as UTF-8 CSV and import through Webflow's CMS import tool. Requirements include 4MB file size limit, headers matching Webflow field names exactly.

The field mapping includes:

• Text fields: Direct column mapping
• Reference fields: Match existing item names/IDs
• Image fields: Complete URLs to hosted images (no embedded images/base64)
• Multi-reference fields: Semicolon-separated values (slug-1;slug-2;slug-3)
• File fields: Manual upload required post-import
• Date format: Convert to W3C format using =TEXT(A2,"YYYY-MM-DD")&"T00:00:00Z"
• Numbers: Remove commas, currency symbols, percentage signs

Note: CSV imports create unpublished items requiring manual publishing.

Automation platforms for scheduled sync

Zapier

Pre-built templates from Zapier's Excel-Webflow hub:

• Add Webflow form submissions to Excel
• Create Webflow items from new Excel rows
• Update Webflow items when Excel rows change
• Add Webflow orders to Excel

Setup: Connect OneDrive for Business + Webflow accounts, configure triggers, map fields, set polling interval.

Make

No pre-built templates are available. Best for complex data transformation, conditional routing, or multi-source workflows.

Custom API integration

Requires REST API experience. Both APIs enforce rate limits — implement exponential backoff for HTTP 429 responses. Review intro to the Webflow's API before starting.

Authentication:

• Microsoft Graph: OAuth 2.0 authorization code flow with Files.ReadWrite scope
• Webflow: OAuth 2.0 or legacy site tokens

The core workflow includes:

1. Authenticate: Redirect to https://login.microsoftonline.com/{tenant}/oauth2/v2.0/authorize
2. Read Excel data: GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='{address}')
3. Transform data: Convert dates to W3C format, remove number formatting, convert rich text to HTML
4. Write to Webflow:

• Create: POST /v2/collections/{collection_id}/items
• Update: PATCH /v2/collections/{collection_id}/items/{item_id}
• Publish: POST /v2/collections/{collection_id}/items/{item_id}/publish

Access tokens expire after 1 hour. Use persistent sessions with POST /me/drive/items/{id}/workbook/createSession. Pagination supports up to 100 items per request. See the list Collection Items for retrieval details.

Bidirectional sync: Configure Webflow webhooks per the Working with Webhooks documentation. For Excel-side changes, implement polling with Microsoft Graph delta queries.

What you can build

Integrating Microsoft Excel with Webflow requires intermediary tools such as automation platforms, spreadsheet alternatives, or custom API implementations. These approaches enable dynamic content management through form response tracking, automated CMS item creation, and scheduled data synchronization.

• Product catalog sync: Maintain product inventory in Excel with pricing, descriptions, and availability, then sync changes to Webflow e-commerce collections automatically
• Form submission database: Export Webflow form responses to Excel for analysis in pivot tables and charts, building summary dashboards from contact forms and lead capture data
• Content publishing workflow: Draft blog posts and portfolio items in Excel with structured fields for title, body, and categories, then bulk import to Webflow CMS collections (note that imports create unpublished items requiring manual publishing or additional automation)
• Dynamic pricing tables: Store subscription pricing and feature comparisons in Excel, displayed as formatted tables on Webflow pages that update when you modify the source spreadsheet