Integrations · CSV & Excel

Enrich Product Catalogs from CSV or Excel Files

You do not need a finished API integration to begin working with product data. Many catalogs already move between suppliers, teams and systems as CSV or Excel files.

The handoff is not limited to enriched attributes: the configured output can carry validated technical fields together with SEO keyword targets, unique product copy, meta title, meta description and final content in the target language.

ENRIVAQ can use a structured CSV or Excel catalog as input to the enrichment workflow: map existing columns, research missing information, build structured output and validate the result.

File input is supported. A standalone enriched CSV/XLSX export is not claimed as a generic current capability; approved output moves into the connected catalog/site workflow.

Workbook transit router File intake / column mapper
catalog_source.xlsxINPUT
product_keyAC820825
titleKverneland AC820825 Fan Impeller
attributes.*— MISSING
validation.*— MISSING
ENRIVAQ FILE ROUTER

Map, enrich and validate

Map columnsSCHEMA
Enrich recordsDATA
Validate outputGATE
Shape approved outputEXPORT
connected_catalog_outputOUTPUT
product_keyAC820825
attributes.*accepted structured values
content.*approved content fields
validation.*Accepted / Review / Rejected
The file your team already exchanges is enough for a first batch. REFERENCE FILE EXAMPLE · AC820825
Upload existing catalog

Start with the spreadsheet your team already uses

The source file can contain the product data as it exists today, including incomplete or inconsistent fields.

Cleaning it manually before the pilot can hide the actual work the enrichment workflow is supposed to solve.

Each row carries enough identity and catalog context to map the product to a target output record; required fields follow the product category and deployment.

File intake dock Send it as it is
XLSX supplier_catalog.xlsxOriginal structure preserved USE AS IS
CSV legacy_export.csvIncomplete values are visible ACCEPT
XLSX manual_cleanup.xlsxPre-cleaning hides evaluation evidence AVOID
IDENTITYCan we resolve the row?SKU, MPN, manufacturer or another implemented identifier.
ROW KEYCan we return the result?Every output must map back to the original record.
SCHEMACan columns be mapped?The target structure is defined before enrichment starts.
REALITYKeep the mess visibleInconsistency is evidence for what the workflow must solve.
Required columns · optional fields

Define the minimum fields for reliable processing

Required columns are mapped from the implemented workflow and may differ across product categories and use cases.

Required processing contract

The minimum for reliable processing

product_keyStable value that lets the result return to the correct source row.
identity_signalEnough to resolve the row to one real product.
target_scopeSelects which product category and target schema apply.
category_variationRequirements may differ by category and use case.
Required columnsStable product identifier + matching context
Optional context fields

Keep useful existing data

titleExisting product title or supplier naming pattern.
descriptionMay contain facts worth extracting, but is not ground truth by default.
attributes.*Known values show what is already filled and support validation.
categories + IDsPreserved where relevant to the implemented workflow.
Optional columnsManufacturer/MPN · category · existing attributes · description · EAN
Mapping

Map spreadsheet columns into the target product schema

Supplier files often use their own column names and structures. Before processing, those fields need to be mapped to the product schema expected by the enrichment workflow.

Several supplier columns may describe the same canonical attribute under different labels. Mapping gives the batch a consistent target structure before enrichment begins.

Column switchboard Source columns → canonical target fields
Supplier columnsRoute / typeTarget field
supplier_mpnproduct_code
string
manufacturer_part_numberONE CANONICAL ATTRIBUTE
weight
kg
weightTYPED VALUE
outer_diameterdiameter_unit
number + unit
outer_diameterNORMALIZED UNIT
One canonical field per concept, so the batch shares a target structure. supplier_part_no → manufacturer_ref · product_title → source_title · fitment_text → compatibility
Processing

Process the catalog as a batch, not as separate AI prompts

Once the file is mapped, records can move through the product-data workflow: identification, research, extraction, normalization, validation and content preparation according to the configured scope.

Batch engine One schema · many records
01IdentifyThe row is resolved to one real product.
02ResearchMissing information is collected and traced.
03ExtractFound values become typed attribute fields.
04NormalizeOne unit, name and format across the batch.
05ValidateEach field carries a reviewable state.
06Prepare outputWritten from the structured record, in scope only.
Batch capabilityRun-specific; no public production-volume claim Processing timeMeasured per run; no public generic benchmark Automation coverageMeasured per project/run
Quality report

Return more than a finished spreadsheet

Where the implemented workflow supports it, a quality report can help the customer see which records were completed, which still contain missing data and which require review.

Quality visibility is attached to the workflow so accepted, reviewed and unresolved data remain distinguishable.

Batch quality lens

Record outcome per batch

Uncertainty remains visible instead of being hidden inside the finished file.

STRUCTURE ONLY · NO FIGURES
COMPLETED Records completedAll in-scope fields were filled and validated. Run-specific
INCOMPLETE Records with missing dataSome in-scope fields could not be established. Run-specific
REVIEW Records requiring reviewConflicting or uncertain values were held for a person. Run-specific
Quality report fieldsAccepted / Review / Rejected · provenance · conflicts · blockers
Approved output handoff

Deliver validated structured output into the connected catalog/site workflow

The output contract preserves the relationship between the original product record and the enriched fields. Approved data is then handed to the connected catalog/site workflow; standalone enriched-file export is not presented as a current generic capability.

Output workbook contract Shaped by the destination
Column groupWhy it is in the outputOrigin
identity.*Preserve stable product and row identifiers.SOURCE
attributes.*Return normalized technical fields required by the target schema.ENRICHED
content.*Include approved titles and descriptions only when in scope.IF IN SCOPE
validation.*Expose approval, review or missing-data state where implemented.QUALITY
Column structure defined aroundthe target PIMan ERP-related processthe ecommerce catalog

Not an arbitrary one-size-fits-all export.

Before / after spreadsheet example

Show the exact columns added or improved

Use a real sample with a small number of rows and sensitive data removed.

Spreadsheet delta ledger Same representative product row
FieldBefore.xlsxChangeAfter.xlsx
manufacturer_refAC820825PRESERVEDAC820825
compatibility—ADDEDOptima / Optima HD
supplier_descriptionKverneland AC820825 Fan ImpellerIMPROVEDfact-backed content output
validation_state—ADDEDREVIEW / HOLD for unresolved conflict
Source columns / valuesmanufacturer_ref=AC820825 · title=Fan impeller AC820825 Enriched columns / valuesEAN=8716106986118 · compatibility=Optima / Optima HD · material=Metal Validation / review statusSupported values accepted · weight conflict held
File handoff route

Start with the file you already have

Send a representative CSV or Excel catalog and the target fields you want to improve. That is enough to define a practical enrichment test without overcomplicating the first step.

01Representative file 02Product identifiers 03Target fields 04Destination format Practical test

Talk to ENRIVAQ

Request a catalog assessment

Tell us enough to make the next step useful for your catalog.