Import from Google Sheet, Excel or CSV

Your catalog is already in a spreadsheet? Import it as is. JAWEBNI recognises the columns, and a row without a valid price is never imported.

4 min · Updated October 7, 2026

Prepare your table

Download the template with Download the template (CSV), or keep your own table: one row per product (or per variant).

ColumnExample
nom (name, required)Vitamin C serum
prix (price, required, in DT)35 · 35,5 · 35.500 · 35 DT
tailles (sizes)40, 41, 42 · S M L · 40-45
couleurs (colours)Black, White
stockempty (not tracked) · 12 · yes / no · sold out
photo, lien (link)https://…
catégorie, descriptionSkin care

Headers in French, English or Arabic are recognised. Three decimals = millimes: 1.200 = 1.2 DT. 5,000 rows max.

Google Sheet

  1. In Google Sheets: Share › General access › Anyone with the link › Viewer. For another tab, open it before copying the link.
  2. In JAWEBNI, Google Sheet / Excel card, Google Sheet tab: paste your Google Sheet link and click Show preview.
  3. Columns step: check the column of each field (“name” and “price” are required).
  4. Read the summary “N rows ready · N to fix”, then Import N products.

Changed your Sheet? Click Resync. If the Sheet turns private, empty or loses its columns, your catalog is never wiped: the error is shown.

Excel or CSV file

  1. Excel / CSV file tab: Choose a file (.xlsx or .csv, from your phone or computer).
  2. Same preview, same columns, then Import N products.

The old .xls format is not read: save it as .xlsx or .csv. A file does not resync: upload it again after your changes.

A price is never made up

A row without a valid price (empty, 0, text, a range like “30-40”…) stays out with its row number. Fix it in your table, then resync or upload the file again.

A Shopify or WooCommerce store is connected? Disconnect it first: one source at a time.

Still stuck?

Email us at [email protected] and describe what you see on screen. Support is by email.

Ready to try it?

14 days free, no credit card. Your assistant is ready in 5 minutes.