Practical guide

Import Amazon product CSV into Google Sheets

Import the downloaded one-row CSV into Google Sheets while preserving nested JSON cells.

Import the one-row CSV

  1. Download CSV from the product-to-CSV tool.
  2. In Google Sheets choose File > Import > Upload and select the file.
  3. Choose comma as the separator and avoid converting text identifiers automatically.
  4. Confirm that all 14 headers remain in the first row and one product remains in the second row.

Keep nested data in one cell

images, category, and product_information are JSON strings inside their cells. This is intentional: a single product stays on one spreadsheet row.

["Electronics","Computers & Accessories","Laptop Accessories"]

Troubleshooting

  • If Arabic or accented text is damaged, re-import the original file as UTF-8.
  • If a row splits at every nested comma, import the file instead of pasting raw CSV text.
  • Keep ASIN and URLs as text.
  • This is a manual import; there is no live Sheets function or synchronization API.

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

Should nested JSON cells be split into columns?

Usually no. Import them as text first; parse or expand them later only if your spreadsheet workflow requires it.