# Import products from a CSV


> Upload a CSV with a Product URL column and retain other columns as product import data.


Canonical URL: https://www.copyhero.app/help/products/import-csv

Import a larger list from a CSV while keeping its non-URL columns with each imported product.

<!-- screenshot: products-import-csv -->

## Prepare the file [#prepare-the-file]

* Use a `.csv` file.
* Include a column named exactly **Product URL**.
* Put an `http://` or `https://` product URL in each row you want to import.
* Additional columns are retained as extra import data.

## Upload and confirm [#upload-and-confirm]

1. In **Products**, select exactly one store and choose **Import to Shopify**.
2. Keep **CSV Upload** selected, then drop a file or choose it from your computer.
3. Check the file card’s row count and continue to **Review Links**.
4. Use **Remove invalid** for failed rows, or **Remove CSV** to replace the file.
5. Finish the import options and select **Confirm Import**.

## Limits and errors [#limits-and-errors]

The import UI marks rows beyond the displayed import limit as **Skipped**; only the first allowed products are imported. If the file has no valid `Product URL` values, CopyHero reports that no valid product URLs were found.

Related: [import product links](/help/products/import-links) and [resolve invalid links or duplicates](/help/products/resolve-invalid-duplicates).