Practical guide

Import Amazon product data into Excel

Download the actual UTF-8 CSV and import its 14 columns into Excel without losing Unicode.

Download the actual CSV

Run one product lookup on the CSV tool and download the result. The file contains 14 columns and one product row, with a UTF-8 BOM at the beginning. If you want to practice first, the fixed output example can download the same exporter format without a lookup.

asin, marketplace, source_url, currency, canonical_url, title, main_image, images, rating, review_count, category, brand, bsr, product_information

Import into Excel

  1. In Excel, use Data > From Text/CSV and choose the downloaded file.
  2. Confirm UTF-8 and a comma delimiter in the preview.
  3. Keep asin, source_url, and canonical_url as text so identifiers and URLs are not reformatted.
  4. Load the one-row table, then inspect nested JSON cells without splitting quoted commas.

Nested cells and common failures

SymptomCauseFix
Accented or Arabic text is garbledWrong character encodingRe-import as UTF-8
One product becomes many columnsQuoted commas were ignoredUse Excel's CSV importer, not manual paste
ASIN is reformattedAutomatic numeric/type detectionSet identifier columns to Text
images or category looks like JSONNested arrays are intentionally encoded in one cellKeep the cell as text or parse it later

Results may be cached and optional source fields can be absent. See the data methodology for collection and field boundaries. Read the data methodology.

Frequently asked questions

Why do some CSV cells contain brackets and braces?

Arrays and grouped product information are stored as JSON text inside quoted CSV cells so one product remains one row.