Use the CData ODBC Driver for CSV from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CSV to connect to CSV/TSV Files from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CSV/TSV Files in Excel.