Connecting Avature CRM to Excel

Can someone please help walk me through how you connect Avature CRM to excel, I want to connect a people list to excel so our clients can simple open excel and refresh the table at their own leisure. This would help us eliminate the need to constantly email out this list.

Did you ever solve this with publick URL's?