Live link to csv from Numbers

risingtiger42 wrote:

This is basic stuff in software,

Could you give us specifics on which software does this "basic stuff" for you?

SG

And you think that is automatically importing a csv "file" as you wrote above?

Once you have more specific suggestions then you might try going to Numbers > Provide Numbers Feedback and making a suggestion to Apple (we're your fellow users here).

I wouldn't expect a response but I understand they do review the feedback as one input in formulating priorities for future development.

As you've discovered by now Numbers is not intended to be a clone of Excel or Google Sheets. It's got its strengths and they've got theirs.

SG

You can do simple stuff like this

set csvData to (do shell script "curl https://www.cps.gov.uk/sites/default/files/documents/data/case_outcomes/18-19-Q4/POC-18-19-q4.csv -o ~/desktop/data.csv")
set dataFilePath to (path to desktop from user domain as string) & "Data.csv"
tell application "Numbers"
	activate
	open file dataFilePath
end tell

From there on in you can make things as complicated as you like.

You can build scripts into Automator actions and run them with keyboard shortcuts, or you could run any number of scripts from Numbers' AppleScript menu. But as I'm sure you know, there is no way of maintaining a dynamic link between the .csv and the Numbers document.