Repeat until clipboard is empty

[rajo]

looks good, I'll try that, thanks!

[tiffle]

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

Subroutine to Read Data From Excel Spreadsheet

Purpose This subroutine extracts the data from an Excel spreadsheet. The data can be either a cell or a range of cells from a specific worksheet or whatever worksheet the spreadsheet opens to by default. Inputs Local__SpreadsheetPathName - the name of the file containing the Excel spreadsheet. The name should be the pathname in full or use the tilde (~) character as a substitute for the user’s home directory. Local__Worksheet - the name of the worksheet containing the cell(s) to be extracted…

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

[rajo]

thank you guys, I'll look into this later today and report back

[rajo]

So that's exactly what I did and it works great, thanks! Solved.