Conversational AI mapping
The AI proposes mappings and explains its reasoning. Ask it to remap a column, skip fields, or create custom attributes — all through natural conversation.
AI Import Engine
Import any spreadsheet. AI handles the rest.
Stop reformatting data to fit rigid templates. Upload your Excel or CSV file and let AI map columns, clean data, and validate everything — so you can get back to running your business.
No template required
Use your existing spreadsheet as-is
AI column mapping
Automatic field detection with confidence scores
Industry-aware
Understands restaurants, retail, healthcare, and more
Smart data cleaning
Strips symbols, normalizes formats, flags issues
inventory_q4_2025.xlsx
847 rows · 12 columns
Column Mapping
Product Namename
98%Item Codesku
95%Storebranch
92%Unit PricesellPrice
90%Skipped: Internal Notes, Row ID
I noticed ‘Unit Price’ contains currency symbols ($). I'll strip those automatically during import.
inventory_q4_2025.xlsx
847 rows · 12 columns
Column Mapping
| Source Column | Maps To | Confidence |
|---|---|---|
| Product Name | name | 98% |
| Item Code | sku | 95% |
| Store | branch | 92% |
| Unit Price | sellPrice | 90% |
| Shelf Location | zone | 88% |
| Color | Custom: Color | 78% |
Skipped: Internal Notes, Row ID
I noticed ‘Unit Price’ contains currency symbols ($). I'll strip those automatically during import.
How it works
1
Upload your file
Drop any Excel or CSV file — no reformatting, no template downloads.
2
AI analyzes your data
The AI reads column names, sample values, and data patterns to build a mapping proposal.
3
Review mappings
See every column mapping with confidence scores. Adjust, skip, or approve with one click.
4
Validate and import
Data is validated against your workspace rules. Errors are flagged before anything is written.
What the AI import engine can do
Confidence scoring
Every mapping includes a confidence percentage. High-confidence mappings (85%+) are auto-approved. Lower scores are flagged for your review.
Smart data transforms
Currency symbols stripped from price fields, dates normalized across formats, units converted, and whitespace cleaned — automatically.
Multi-entity detection
The AI detects when your spreadsheet contains branches, zones, bundles, or custom fields — and maps them to the right Stocklyst entities.
Validation and auto-correction
Before import, every row is validated against your workspace rules. Duplicate SKUs, missing required fields, and out-of-range values are caught and reported.
Workspace reconciliation
Existing items are matched by SKU or name. The AI shows what will be created vs. updated, so you have full control before committing.
Works for any industry
The AI understands industry-specific terminology and maps it to the right Stocklyst entities.
Restaurant
“Walk-in Fridge” → Zone
Storage areas become zones for temperature-sensitive tracking
Retail
“Store Location” → Branch
Each store location maps to a branch with its own inventory
Hospital
“Wing” → Branch
Hospital wings and departments become separate branches
Construction
“Job Site” → Branch
Active job sites are tracked as branches with material zones
Manufacturing
“Assembly” → Bundle
Assembled products become bundles with component tracking
Hospitality
“Room Setup Kit” → Bundle
Room kits bundle linens, amenities, and supplies together
Two import modes
Choose the speed that matches your comfort level.
Quick Mode
2 AI rounds. Best for experienced users who trust the AI and want speed.
- AI proposes all mappings at once
- Single review step before import
- Fastest path from file to inventory
Guided Mode
3-4 AI rounds. Best for new users or complex spreadsheets with ambiguous columns.
- AI asks clarifying questions about ambiguous columns
- Step-by-step mapping review with explanations
- Full control over every mapping decision
FAQ
Do I need to reformat my spreadsheet before importing?
No. Stocklyst's AI reads your file as-is and maps columns to inventory fields automatically. You can use any column names, any order, and any language — the AI understands context, not just exact headers.
What file formats are supported?
Excel (.xlsx, .xls) and CSV files are supported. The AI handles multi-sheet workbooks by letting you choose which sheet to import.
How does the AI know which columns to map?
The AI analyzes column names, sample data values, and data patterns to determine the best mapping. It uses confidence scores to show how certain it is about each mapping, so you can review and adjust before importing.
Can the AI handle different industries?
Yes. The AI is industry-aware — it understands that "Walk-in Fridge" maps to a zone in restaurants, "Wing" maps to a branch in hospitals, and "Job Site" maps to a branch in construction. It adapts its mapping logic to your business context.
What about messy data — currency symbols, mixed formats, empty rows?
The AI detects and handles common data issues automatically. It strips currency symbols from price fields, normalizes date formats, handles empty or duplicate rows, and flags anything it cannot resolve for your review.
Is there a cost for AI import?
AI import is included in all paid plans. Each import uses AI tokens from your plan's monthly allocation. Usage is shown in real time during the import process.
Stop reformatting spreadsheets
Upload your file. Let AI do the mapping. Get your inventory imported in minutes, not hours.
Create accountExplore more
Multi-workspace inventory managementInventory software for growing businessMulti-location inventory managementZone-based inventory trackingBundle inventory managementVariant inventory managementRelated items inventory managementInventory barcode scanning appOffline inventory appAI inventory management appAutomatic reorder point calculatorInventory for retail chainsEnterprise inventory management