← Back to Pacific VA Training
← Back to Pacific VA Training

Sourcing Sheet Magic ✨

Upload your Keepa export, sprinkle in some filters, and get a sourcing-ready Google sheet.

Inside Keepa Product Finder

Step 1

Put in your desired Keepa Product Finder filters

Step 2

View your query results

Step 3

Check your column configuration

We highly recommend you configure your Keepa Product Finder and Product Viewer columns as shown below. The column order doesn't matter, but if any columns are missing, the spreadsheet may not function as designed — for example, Max Cost can't be calculated if the Buy Box 90 days avg, FBA Fee or Referral Fee % are missing.

View required Keepa column setup ↗

Step 4

Export your CSV file

From Keepa, click Export, then choose All active columns and CSV, then click EXPORT.

Step 5

Upload your CSV file here

Find the CSV file in your Downloads folder and upload it below.

No file selected.

Step 6

Profit / ROI

These values are used to calculate the Max Cost column.

Step 7

Which brands do you want excluded?

Type a brand and press Enter. Matching ignores capitalization and extra spaces.

Step 8

Remove rows where the Buy Box seller is the same as the brand

The filter compares the Brand and Buy Box Seller names and removes likely matches.

Step 9

Remove sellers you do not want to compete with

Add seller IDs separately for Canada and the US. Store names are detected from the uploaded CSV when possible.

Step 10

Remove low sales velocity listings

Step 11

Apply sales rank cutoffs

Listings without sales ranks or categories are kept.

View or edit Canada and US sales rank cutoffs

Step 12

Advanced workbook settings

View optional workbook settings

Step 13

Generate your Excel file

Upload a CSV to see a summary of the active rules.

Step 14

Open your file in Google Sheets

This file is designed to be opened in Google Sheets. Some things — like the product images — will not display correctly if you open it directly in Excel.

  1. Type sheets.new into your browser's address bar.
  2. Click File → Import → Upload → Browsethen .
  3. Select the Excel file you just downloaded. Click Open → Import data
  4. If prompted, click Allow access
  5. Add checkboxes to Column B if desired
  6. Now you are ready to start sourcing!
Privacy note: Your CSV is processed in this browser and is not uploaded to Pacific VA Training. Your settings are saved on this device.