Transform Excel Data into AI-Ready Vectors with OpenAI and Supabase

Description

This workflow is a practical, “dirty” solution for real-world scenarios where frontline workers keep using Excel in their daily processes.
Instead of forcing change, we take their spreadsheets as-is, clean and normalize the data, generate embeddings, and store everything in Supabase.

The benefit: frontline staff continue with their familiar tools, while data analysts gain clean, structured, and vectorized data ready for analysis or RAG-style AI applications.

How it works

• Frontline workers continue with Excel – no disruption to their daily routines.
• Upload & trigger – The workflow runs when a new Excel sheet is ready.
• Read Excel rows – Data is pulled from the specified workbook and worksheet.
• Clean & normalize – HTML is stripped, Excel dates are fixed, and text fields are standardized.
• Batch & switch – Rows are split and routed into Question/Answer processing paths.
• Generate embeddings – Cleaned Questions and Answers are converted into vectors via OpenAI.
• Merge enriched records – Original business data is combined with embeddings.
• Write into Supabase – Data lands in a structured table (excel_records) with vector and FTS indexes.

Why it’s “dirty but useful”

• No disruption – frontline workers don’t need to change how they work.
• Analyst-ready data – Supabase holds clean, queryable data for dashboards, reporting, or AI pipelines.
• Bridge between old and new – Excel remains the input, but the backend becomes modern and scalable.
• Incremental modernization – paves the way for future workflow upgrades without blocking current work.

Outcome

Frontline workers keep their Excel-based workflows, while data can immediately be structured, searchable, and vectorized in Supabase — enabling AI-powered search, reporting, and retrieval-augmented generation.

Required setup

Supabase account

• Create a project and enable the pgvector extension.

OpenAI API Key

• Required for generating embeddings (text-embedding-3-small).

Microsoft Excel credentials

• Needed to connect to your workbook and worksheet.

• Need Help

🔗 LinkedIn – Wessel Bulte