Pasting multiple columns into Numbers

Hi,

I have a spreadsheet in Numbers where I write down all my purchases from the AppStore. I have already a Scriptable script that fetches the apps name and current price and copies it into the clipboard in the format {name}\t{price} where \t is the tab character. I’ve then pasted it manually into the spreadsheet and it separated it into two columns.

Some long time ago (more than a year probably) the pasting has stopped working. It now pastes the text into one cell. When I select both cells, it does the exact same thing: pasting the whole thing into both cells.

So my question is: Is there any way to paste the data, so that the name is in one column and the price in the other?

have you tried CSV format?

1 Like

Thanks for the suggestion, but sadly it too doesn’t work.

A couple more suggestions:

  1. Import, not paste, csv?
  2. Append to file using Shortcuts?
1 Like
  1. You mean opening a CSV file with numbers? That creates a new file instead of inserting it into the desired spreadsheet.
  2. That apparently does nothing…

Thank you for taking your time to help!

I’ve copied one line from numbers and looked at the format. It is exactly like my first try: {name}\t{price}.

The outlook is less than stellar:

https://discussions.apple.com/thread/8428305

Oh. Well, thanks anyway.

I will experiment with it a bit. I will report back when I find something useful.

Oof. Oh well. Sorry I couldn’t help :slight_smile:

So I’ve found out that plain text doesn’t work, but rich text does. So this works:

The only thing is that it also pastes the format of the text so it will probably look a little odd, but it is separated into columns as it should be!

1 Like

Nice! Glad you finally got this working :slight_smile: