Repeat until clipboard is empty

If you stick with Excel you can make the most of its support for AppleScript to read data from a spreadsheet.

I have previously created a KM subroutine to do this and you can read about it here

That topic includes a demo and a full explanation of how to use it.

2 Likes