# Connect CSV export to Excel as live data source

**URL:** <https://forums.knack.com/t/connect-csv-export-to-excel-as-live-data-source/7710>\
**Category:** Get Answers\
**Created:** [March 1, 2016, 9:45pm UTC](https://forums.knack.com/t/connect-csv-export-to-excel-as-live-data-source/7710 "2016-03-01T21:45:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![beritrep](https://avatars.discourse-cdn.com/v4/letter/b/ce73a5/32.png) [@beritrep](https://forums.knack.com/u/beritrep)\
**Post date:** [March 1, 2016, 9:45pm UTC](https://forums.knack.com/t/connect-csv-export-to-excel-as-live-data-source/7710/1 "2016-03-01T21:45:50Z")

</div>

Hi!

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?

---

<div class="post-metadata">

**Author:** ![MatthiasHa60852](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@MatthiasHa60852](https://forums.knack.com/u/MatthiasHa60852)\
**Post date:** [May 9, 2016, 1:35pm UTC](https://forums.knack.com/t/connect-csv-export-to-excel-as-live-data-source/7710/2 "2016-05-09T13:35:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![BradStevens](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/bradstevens/32/140_2.png) [@BradStevens](https://forums.knack.com/u/BradStevens)\
**Post date:** [March 28, 2016, 2:40am UTC](https://forums.knack.com/t/connect-csv-export-to-excel-as-live-data-source/7710/3 "2016-03-28T02:40:44Z")

</div>

Berit,

I've built an Excel Addin proof of concept that connects directly with Knack data and considering whether to develop it further - See [http://helpdesk.knackhq.com/support/discussions/topics/5000072262](http://helpdesk.knackhq.com/support/discussions/topics/5000072262)

What do you think?
