# How to export product cards to CSV with names, prices, and URLs

Turn a product listing into a spreadsheet: choose fields, collect a bounded set of pages, check prices and variants, and export the records as CSV.

Source: [How to export product cards to CSV with names, prices, and URLs](https://www.trysidelight.com/blog/export-product-cards-to-csv)

A product listing looks organized until you try to paste it into a spreadsheet. Names, prices, delivery notes, and buttons can land in the same column. Each product may occupy a separate card rather than a row in a conventional table, and the next page contains another batch of items.

To export a product list to CSV, define the fields first, check a small extraction, and then expand the collection. Sidelight AI Assistant can read supported tables and repeated card layouts from the page you have open. You can ask for particular columns and a CSV download instead of transferring each card by hand.

## Choose the comparison before collecting the data

Decide what the spreadsheet needs to answer. A list of potential suppliers needs different fields from a stock check or a shortlist of replacement parts. Start with product name, displayed price, currency, selling unit, availability, and product URL. Add a product code if the listing provides one.

Keep enough context to make prices comparable. A pack price and a single-item price are different measures. A range such as “from $20” should remain a range or qualified price until you identify the relevant variant. Missing shipping information does not establish free shipping. Preserve the original wording when the listing leaves a condition unclear.

## Export the listing in five steps

### 1. Set the category, filters, and sort order

Open the relevant listing in Chrome or Edge. Choose the category, search terms, and filters before starting. If the site provides an official product export containing the fields you need, use that route first.

Keep the same search conditions throughout the collection. Changing a filter halfway through can mix different result sets. Record the collection date and search URL so the spreadsheet remains understandable later.

### 2. Test the current page with specific columns

Open Sidelight AI Assistant on the listing and describe the cards you want. If several groups appear, identify the main results and exclude recommendations or advertising cards where appropriate.

> Extract the main product cards on the current page only. Include product name, displayed price, currency, selling unit, availability, product code if shown, and product URL. Preserve price ranges and discount conditions. Leave unavailable fields blank rather than guessing. Report the number of records found and save them as CSV. Do not open product detail pages yet.

This separates the listing extraction from additional research. A detail page may contain useful specifications, but collecting them is a different task with a larger scope.

[Try Sidelight AI Assistant on the product listing you already have open](https://www.trysidelight.com/signin), then compare the first file with its source before expanding the request.

### 3. Check the relationship between fields

Inspect products from the beginning, middle, and end of the page. Confirm that each price belongs to the correct product and that each URL opens the corresponding item. Look for missing fields, installment amounts mistaken for full prices, and crossed-out prices mistaken for current offers.

Use product codes and URLs to investigate repeated entries. Matching names alone are insufficient: sizes, colors, pack quantities, and sellers can differ. Keep unresolved cases visible for review.

### 4. Expand to a bounded number of result pages

Once the columns are correct, request the first three result pages, including the current page. Ask the assistant to use the same columns and explain where collection stopped if navigation fails.

If the listing loads more products by scrolling, specify a small number of scrolls or loads instead. Some interfaces replace earlier cards as you move through them, so reaching the bottom does not prove that every product was retained. The [website-table export guide](https://www.trysidelight.com/blog/export-website-tables-to-csv) covers scope and result checks in more detail.

### 5. Import the CSV and preserve the source values

In Excel, use the text/CSV import options to inspect the delimiter, encoding, and column types. Keep product identifiers as text when leading zeros matter. Microsoft explains these controls in its [CSV import documentation](https://support.microsoft.com/en-us/excel/get-started/import-or-export-text-txt-or-csv-files).

Before calculating price differences, group comparable currencies and selling units. Keep the original price text beside any numerical column you create. The downloaded CSV records a collection at a particular time; it does not automatically follow future price or stock changes.

## Common questions

**Why are some prices blank?** Check the source card. A price might require selecting a variant or opening the detail page. Keep an unpublished value distinct from a reading error, and do not treat an empty cell as zero.

**Can I get an Excel workbook directly?** This workflow exports CSV. Import it into Excel, review the values, and save an XLSX workbook if you need formulas or formatting.

**Can I use an authenticated supplier listing?** You can test a page you are permitted to access and export. Required page content is sent to a model for the task; review the [privacy policy](https://www.trysidelight.com/privacy) before using confidential supplier information.

[Create an Sidelight AI Assistant account and try one page of product cards](https://www.trysidelight.com/signin). A checked sample gives you a sound starting point for the larger comparison.