Connect CSV export to Excel as live data source


I've made a macro-enabled file in Excel that takes three different tables exported to CSV from predefined Knack views and combines them into an automatic "print all" system. At the moment, I'm downloading updated csv files manually and using them as "from text" data sources in Excel. Although this system works OK with manual downloads and manual reconnections to the source files, I was wondering if there wasn't a simpler solution.

Is there any way of obtaining a well-defined link to the exported CSV file from a given view?

Would need to do the same... Brad - your plugin would be very much appreciated... any progress on this ?


I've built an Excel Addin proof of concept that connects directly with Knack data and considering whether to develop it further - See

What do you think?