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_informationImport into Excel
- In Excel, use Data > From Text/CSV and choose the downloaded file.
- Confirm UTF-8 and a comma delimiter in the preview.
- Keep asin, source_url, and canonical_url as text so identifiers and URLs are not reformatted.
- Load the one-row table, then inspect nested JSON cells without splitting quoted commas.
Nested cells and common failures
| Symptom | Cause | Fix |
|---|---|---|
| Accented or Arabic text is garbled | Wrong character encoding | Re-import as UTF-8 |
| One product becomes many columns | Quoted commas were ignored | Use Excel's CSV importer, not manual paste |
| ASIN is reformatted | Automatic numeric/type detection | Set identifier columns to Text |
| images or category looks like JSON | Nested arrays are intentionally encoded in one cell | Keep the cell as text or parse it later |