From the few others that I tested, yes, they work.
If I put a URL into the box, the results show
Url Ahrefs Rank
Besides the fact they all say 0, my second question is: It seems the tool is designed to enter a single url at a time, at least when I look at your exmaple:
however, I wanted to just put in a cell reference. E.g. A2
But when I do that, it doesnt seem to be designed for that.