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 thi...