Skip to main content
Cernel can import product data from CSV and spreadsheet files, and export enriched content back as CSV. Upload a file directly or provide a URL to a hosted file. Cernel analyzes the columns, lets you map them to attributes, and imports your products.

​
How it works

The CSV integration reads product data from a CSV file. You provide the file, Cernel detects the structure, and you map source columns to Cernel attributes. 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

1

Navigate to Integrations

Go to Tools > Integrations and click Add Integration. Select Spreadsheet (CSV).
2

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
Then choose how to provide your file:
  • URL - Enter the URL of a hosted CSV file
  • Upload File - Drag and drop or browse to upload a CSV file
3

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
4

Map columns to Cernel attributes

After uploading, Cernel analyzes your file and shows the Attribute Mapping view. Map your source columns (left) to Cernel attributes (right) to control how data is imported.
Make sure to map at least a product identifier (like SKU or GTIN) and a product title. Without these, products may not be matched correctly across imports.
5

Create the integration

Click Create Integration. Cernel begins importing your products in the background. You can close the modal and products will be available shortly.
Your CSV import is configured. Products appear in your Catalog once the import completes.

​
Exporting enriched data as CSV

You can export product data to CSV in two ways:
  • On-demand from the products table — pick a product set, configure columns once, and download a CSV immediately. Use this for ad-hoc exports, sharing data with a colleague, or sanity-checking attribute coverage.
  • As a saved integration — define a reusable export configuration in Settings > Integrations. Use this when the same export needs to run repeatedly, or when a downstream system pulls the file on a schedule.

​
On-demand export from the products table

1

Open the products table and pick your scope

Navigate to a category in the Products sidebar. Select specific rows with the checkboxes — the export honors your current filters and selection.
2

Open the Export to CSV modal

From the products toolbar, open the burger menu and click Export to CSV. The button label shows the scope, for example Export to CSV (24) for an explicit selection or Export to CSV (All matching - 1,250) when filters are applied.
The Export to CSV modal showing the file name field, language dropdown, CSV format options, and the Attributes tab with category attributes listed in the main pane
3

Set the basics

The top row controls the file metadata and output format:
  • File name - Defaults to a slug of the current category (e.g. cernel_taxonomy). The .csv suffix is added automatically.
  • Export language - Pick one enabled language. The primary language is marked (Primary).
  • CSV Format Options - Choose the Delimiter (comma, semicolon, tab, or pipe) and toggle Include header row.
4

Pick the columns to export

Use the left-hand sidebar to switch between column groups. Each tab shows a count of selected items so you can see your column total at a glance.
  • Attributes - All Cernel attribute values, split into Category attributes and Product attributes. Search to filter, drag the handle to reorder, and edit the exports to name to override the column header. Use Select all / Deselect all at the top of each section.
  • Identifiers - SKU, GTIN, MPN, and any custom product identifier types. Add a one-off custom identifier in the field at the bottom.
  • Product fields - Built-in product properties: Title, Product ID, Parent ID, and Parent Identifier.
  • Product children - Controls how variants are included. Set Min and Max child levels to expand matched products into their hierarchy. Leaving Max empty includes all descendants.
  • Integrations - Per-integration properties (for example Shopify metafields). Each integration appears as a collapsible section with its own search and select-all controls. This tab only shows when at least one integration is connected.
Each row uses the format <column name> exports to → <output header>. If two rows share the same output header, the modal flags them in red — the newest value wins, which usually isn’t what you want. Rename one of them to keep both columns in the file.
5

Download the CSV

Click Export CSV at the bottom of the modal. The button label changes to Exporting… and a live counter on the button shows Exported N products as the file streams — so for large catalogs you can see progress rather than waiting on a spinner. When the export finishes, the CSV downloads directly to your browser. The modal stays open while the export runs so you can keep adjusting columns for a follow-up export.
Your CSV is downloaded with the columns and order you configured. Re-open the modal to run the export again with different settings.

​
Saved CSV export integration

1

Add an export configuration

In Tools > Integrations, click Add Integration and select Export Data. Choose CSV Export as the format.
2

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
3

Trigger an export

Once configured, trigger an export from the integration details. Cernel generates the CSV file in the background. When ready, download it from the integration status view.
Your enriched product data is exported as a CSV file, ready for use in other systems.

​
Frequently asked questions

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).
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).
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.
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.
Use the on-demand export from the products table for one-off exports — sharing a CSV with a colleague, double-checking attribute coverage on a category, or pulling a snapshot for a presentation. Use a saved CSV Export integration when the same export needs to run repeatedly, when a downstream system fetches the file on a schedule, or when you want a single, named export configuration that everyone in the workspace uses.
The export honors the current product filter and your selection mode. Tick specific rows to narrow it down to an explicit selection, or use the Select all matching toggle in the products toolbar to invert the selection.
Open the Product children tab in the export modal. Min and Max control how many variant levels are included relative to the matched products. Setting Min to 0 and Max to empty includes the matched products plus every descendant. Setting Min to 1 exports only children, skipping the matched products themselves.
Two or more rows share the same exports to name. CSV files can’t have duplicate headers in a meaningful way — the last value written wins, so the earlier columns are silently lost. Rename one of the conflicting rows so each column has a unique output header.

​
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.