The Office Scripts action recorder can generate code snippets for Excel changes, but some actions still require manual ...
Python has made using Microsoft Excel much easier than it has ever been, and it isn't very hard to start using it yourself.
Learn how Excel IMPORTCSV refreshes linked CSV data, handles locale formats, and switches to IMPORTTEXT for semicolon delimiters.