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

Sourcing Sheet Magic ✨

Turn a messy Keepa Product Finder export into a clean, filtered, sourcing-ready Google Sheet in minutes.

  • Filter up to 5,000 Keepa results in seconds
  • Automatically remove excluded brands, sellers you want to avoid, and likely brand-owner listings
  • Generate a clean Google Sheet with max costs, product images, and clickable links
  • Cut out slow-moving listings using sales velocity and customizable category-specific sales-rank cutoffs
  • Calculate your maximum buy cost based on your minimum desired profit and ROI, taking into account exchange rates for cross-border sourcing
  • Customize every filter for Amazon.ca and Amazon.com, and save your settings for next time
Create My Sourcing Sheet Now ↓
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. Optional calculation settings are available below.

Cross-border sourcing
Exchange rate: This tool uses a fixed rate of 1 USD = 1.40 CAD. Your Max Cost in the finished sheet will be shown in the currency of the country where you are buying.
Max Cost calculation

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. Rows removed are based on current BuyBox owner so you still may get some listings with the selected sellers.

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

Choose how your sheet is sorted

View optional sorting settings

When sorting by Bought in past month, rows where that metric is unavailable are sorted by 90-day sales-rank drops in the same direction. Rows missing both values are placed at the bottom.

Step 13

Additional workbook settings

View additional workbook settings

Step 14

Generate your file

Upload a CSV to see a summary of the active rules.
Other export options

Both CSV exports use the same active filters and sorting settings shown above.

Step 15

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 → Browse.
  3. Select the Excel file you just downloaded, then 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.