---
canonical: https://amplience.com/developers/docs/workforce/integrations/feeds-exports/csv-feed/
title: Workforce CSV product feed
description: Learn how to get a CSV feed integrated in Workforce to be able to browse and select products from external systems, helping to automate your workflows.
audience: Developer
image: https://cdn.media.amplience.net/i/ampproduct/choose-feed-csv-1?w=1200&h=630
image_width: 1200
image_height: 630
date_published: 2024-11-08
date_modified: 2026-04-22
---

# CSV product feed

The following steps outline how to get a CSV feed integrated in Workforce to be able to browse and select products.

## What you'll need

To configure your CSV feed integration in Workforce you'll need the following:

- CSV feed URL
- JSON path to map to the property containing an array of products. Note you must [convert the CSV feed to JSON](#convert-the-xml-feed-to-json) to determine the JSON Path configuration.
- JSON path for individual product properties:
  - ID/SKU
  - Name
  - Description
  - Image(s)

> **Info: CSV feed limitations**
> CSV feed integrations are primarily aimed at small categories, testing and demoing product data and as a result, these types of feed integrations have some limitations.
> 
> - The CSV feed must be a public URL
> - The CSV feed must be less than 2MB in size

## Setting up the Workforce integration

- In the Workforce [integrations page](https://amplience.com/developers/docs/workforce/setup/integrations/) choose the Commerce Repositories icon and click "Add Commerce Repository"
- Choose "CSV Feed" from the dialog options and add the integration.

![Importing a CSV feed](https://cdn.media.amplience.net/i/ampproduct/choose-feed-csv-1?w=1880&fmt=png 'Importing a CSV feed')

- Provide the JSON paths for the list of products in the feed and individual product properties (ID, name, description, images). Default values are available by clicking on each box and selecting the value.

### Convert the CSV feed to JSON

- In order to provide the JSON path parameters for your feed you will need to convert the CSV file to JSON using a tool such as [CSV for Node.js](https://csv.js.org/convert/). You will still import your feed in CSV format, the conversion to JSON is only required to configure the JSON paths required in the "Add Commerce Repository" dialog.

- Use a JSON Path evaluator such as the [JSON Path online evaluator](https://jsonpath.com) to determine the JSON paths for your feed. See [CSV feed example](#csv-feed-example) for an example feed and configuration.

![Configuring a CSV feed](https://cdn.media.amplience.net/i/ampproduct/csv-feed-content-studio-1?w=1880&h=1200&fmt=png 'Configuring a CSV feed')

See [Determining JSON paths](https://amplience.com/developers/docs/workforce/integrations/feeds-exports/determine-json-paths/) for more details.

### Using your feed

Once the integration is set up, your product data is available to browse and add when using Workforce [templates](https://amplience.com/developers/docs/workforce/templates/#templates) such as "Rewrite product description".

![Using the product data from your feed in a Workforce template](https://cdn.media.amplience.net/i/ampproduct/json-feed-content-studio-3?w=1880&fmt=png 'Using the product data from your feed in a Workforce template')

## CSV feed example

An example CSV feed is hosted at the following URL. We recommend downloading the file from this URL and opening it in Microsoft Excel, Apple Numbers or other spreadsheet app.

```
https://amp-product.s3.eu-west-1.amazonaws.com/content-studio/commerce-repository/product-feed-examples/products.csv
```

### Example mappings

The JSON path mappings for the attributes are shown below:

| Attribute   | Mapping                                                                                               |
| ----------- | ----------------------------------------------------------------------------------------------------- |
| Products    | `$.products.product[*]`                                                                               |
| ID/SKU      | `$.id`                                                                                                |
| Name        | `$.name`                                                                                              |
| Description | `$.longdescription`                                                                                   |
| Images      | `$.[variants.0.images.0.url,variants.0.images.1.url,variants.0.images.2.url,variants.0.images.3.url]` |

## Related pages

[Workforce- generating content](https://amplience.com/developers/docs/workforce/templates)