Importing leads
CSV files, Google Sheets, column mapping and daily sync.
Three ways to add leads
Manual entry, CSV upload, or a Google Sheet link.
Upload a CSV, step by step
From file to leads on your dashboard.
Import from a Google Sheet
Paste a link instead of downloading a file.
Daily sync for sheets that keep growing
Import a sheet once, get new rows every day.
Column mapping reference
Which fields to map, and which Keepa fills in.
Mapping presets
Map a provider once, reuse it every time.
How duplicate skipping works
Upload the same list again without doubling up.
Import history and errors
Read the history table and fix what matters.
Importing bundles
One ASIN made from several source products.
Questions about Importing leads
My import says "Completed with errors". Is something wrong?
Usually not. Click View Errors. If every error is a missing ASIN, those were blank rows, titles or notes in the provider's file, and every real lead came in. Which errors matter.
Some columns are missing from the mapping screen.
The header row is wrong. Set it to the row where the column names are, often 2 to 5 in provider files.
The dates came in with the wrong year.
Check Assumed year. It is used when a date has no year, which happens with tab names like "10/14". Re-import after fixing it.
My Google Sheet will not load.
Share it as Anyone with the link, Viewer. Or use My Google account → Choose spreadsheets to pick a private sheet, or one shared only with you.
Why were rows skipped?
Duplicates are skipped when the ASIN, source and date match a lead you already have. Rows without a valid ASIN are skipped too. Preview Import shows the counts before you import.
Can I change a saved sync's sheet or mapping?
Delete the saved sync and import the sheet again through Add Leads with the new mapping.
Do I need to map brand, title or BSR?
No. Keepa fills them in. Only ASIN is required.
Profit is blank on new leads.
It fills in as Keepa refreshes each ASIN. My Lists shows Keepa: Fully Refreshed when every ASIN has been refreshed.