How it works
The CSV integration reads product data from a spreadsheet file (CSV, XLSX, or XLS). You provide the file, Cernel detects the structure, and you map source columns to Cernel fields. Products are imported and ready for enrichment. For export, you configure which attributes to include and Cernel generates a downloadable CSV with your enriched product data.Why you would use this
Import from any source
If your product data lives in a spreadsheet - from a supplier, an ERP system, or a manual catalog - you can import it directly without needing a platform integration.
Export enriched data anywhere
Download your AI-enriched product content as a CSV for use in any system that accepts spreadsheet imports.
Importing products from CSV
Navigate to Integrations
Go to Settings > Integrations and click Add Integration. Select Spreadsheet (CSV).
Configure the integration
Fill in the basic settings:
- Integration Name - A descriptive name for this import source
- File Language - The language of the content in your file
- URL - Enter the URL of a hosted CSV file
- Upload File - Drag and drop or browse to upload a CSV, XLSX, or XLS file
Configure advanced settings (optional)
Expand Advanced Settings to configure:
- Sync Mode - Full Sync (replace all products) or Update Only (only update existing products)
- CSV Delimiter - Auto-detect, comma, semicolon, tab, or pipe
- Include All Fields - Import all columns, not just those identified by AI
Map columns to Cernel fields
After uploading, Cernel analyzes your file and shows the Attribute Mapping view. Map your source columns (left) to Cernel fields (right) to control how data is imported.
Exporting enriched data as CSV
Add an export configuration
In Settings > Integrations, click Add Integration and select Export Data. Choose CSV Export as the format.
Configure the export
Set up your export:
- Export Name - A descriptive name
- Export Language - Which language to export
- Base on Existing Integration (optional) - Use field mappings from an existing integration as a starting point
- Export Field Mapping - Configure which Cernel attributes to include and their output column names
Frequently asked questions
What file formats are supported for import?
What file formats are supported for import?
Cernel supports CSV (
.csv) files. The delimiter is auto-detected by default, but you can specify it manually if needed (comma, semicolon, tab, or pipe).Can I re-import an updated file?
Can I re-import an updated file?
Yes. Use the same integration and upload a new file. The sync mode determines whether Cernel replaces all products (Full Sync) or only updates existing ones (Update Only).
What happens if my CSV has columns Cernel doesn't recognize?
What happens if my CSV has columns Cernel doesn't recognize?
By default, Cernel only imports columns that it can map to known fields. Enable Include All Fields in advanced settings to import all columns, even those not automatically identified.
Can I import from a URL that updates automatically?
Can I import from a URL that updates automatically?
Yes. If you provide a URL, Cernel can re-fetch the file to sync updated product data. This is useful for supplier feeds or automated exports from other systems.
What’s next
Cernel Taxonomy
See how Cernel automatically classifies your imported products into categories, ready for enrichment.
Enriching Products
Start generating AI content for your imported products.
