How do I get a loop of repetition action?

Say I want to click and create point on a map, but using data driven method, I would need to create an excel sheet to store X and Y values. How do I do it this way? There would be a while loop for this so as long as there are X and Y data, there would be points to be created.