Automate importing .csv file into numbers

A script in AppleScript can do something like this.

But it would be highly dependent on the structure of your document and would only be worth writing if the steps you are now following are not just tedious, but also are very time-consuming.

Six or so copy-pastes every few days may be annoying. But they probably don't take that much time, right?

If they are taking a lot of time then perhaps you could post screenshots with details.

SG

Ok, copy-paste can be surprisingly efficient for task like what you describe, but if you want to learn more about automating Numbers with AppleScript, then one useful resource is this:

https://iworkautomation.com/numbers/index.html

SG

I'll go out on a limb here and say that AppleScript can absolutely do that.

HOWEVER, there are a million and one gotchas, and not enough information to actually make it happen

Importing a CSV? - Simple

Transposing that data across 60 tables, with no idea what the data looks like, how many rows/columns, how it's transposed, what checks and balances exist, what error conditions to check for, what the result should look like? - almost impossible.

If you want to dive into details, I'm happy to chime in, but there really isn't much to go on at the moment.