POAP Detective : How to check if your #Event was farmed

If you want to check if your poap event was farmed:

  1. Go to poap/gallery, enter your event number, click on ‘Download CSV’


  1. Open the csv file and delete columns A, D, E and F, leaving just two columns (Collection and ENS address).


  1. Follow this 2-minute youtube video on how to count duplicates by entering a simple ‘=COUNTIF’ formula and what you will get is this:


4 Perform the following sort to list the worst farmers at the top:


  1. As you can see, this event was farmed :woman_farmer: :man_farmer: :man_detective:


1 Like