Excel/CSV ingestion with AI-assisted normalization

Automated vendor CSV/Excel ingestion with SKU normalization, AI gap fills, and before/after proof bundles.

Author

Aria Cole

Example Profile - Content Strategy & Technical Writing

Challenges

Solved

Part of

Links

Website LinkedIn

Impact & Results

Cut file prep from hours to minutes; 80% of files needed zero manual edits.

The Story

How this challenge was approached and solved

Built a mapper that detects columns across vendor templates, normalizes SKU casing, and fills gaps with prompt-tuned AI while preserving the original layout. Pipeline:

Schema detector aligned messy tabs, then normalized SKUs with casing + trim rules.
AI assists (prompt-tuned) filled missing attributes; risky rows were flagged for review.
Exported proof bundles (raw + cleaned + audit log) so finance trusted the outputs.

Links: used OpenAI API for gap fills and Black-style formatting for audit logs.

Focus Areas

AutomationData

Tools & Technologies

NodeOpenAIExcel

Screenshots

A closer look at the work

Videos

Demos and walkthroughs