eOne has a new SmartConnect Excel Template (Again). I like the changes they are making.
The eOne Dynamics GP and CRM Blog: Tech Tuesday – New Excel Template (Again)
Microsoft & the GP EcosystemExcel & Office
Archived post from 2012. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.