Paste content into Numbers then export as CSV

> Is there away to increase the number of rows to match the pasted contents. Thanks!

Since the script knows how many paragraphs of data there is, it's easy to use that to extend (or contract) the table as needed.

Just add two lines to the script immediately after 'tell document 1 to tell sheet 1 to tell table 1'

set row count to (count importData)

set column count to 2

This will size the table to accommodate all the import data, and strip off the extra columns.

The problem is that you explicitly set the value of cell A1 to the contents of the clipboard, so it's doing exactly what you ask.

Instead, you likely need to iterate through the contents of the clipboard - which isn't hard to do. This should work - there are some optimizations that might apply if you're dealing with many (hundreds or thousands) of rows, otherwise this quick and dirty script should get you on the right path.

use AppleScript version "2.4" -- Yosemite (10.10) or later

use scripting additions

tell application "Numbers"

activate

set thisDocument to make new document

-- parse the clipboard data into paragraphs

set importData to paragraphs of (get the clipboard as text)

tell document 1 to tell sheet 1 to tell table 1

-- iterate for each paragraph

repeat with i from 1 to (count importData)

-- set the appropriate cell

set value of cell ("a" & i as text) to (item i of importData)

set value of cell ("b" & i as text) to "missing"

end repeat

end tell

end tell

oops - forgot the 'export as CSV' and 'close' elements of your request. Just add:

tell application "Numbers"

export document 1 to file (choose file name) as CSV

close document 1 saving no

end tell

to the end of the script

> I can't mark your post as correct. It only gives me the options for helpful.

Only one post can be marked as solved/correct, and two has 'helpful'. But it's all good - I got the credits overall. Thanks :)