CData Software - Knowledge Base

Use CData Sync for automated, continuous, customizable Excel Online replication to delimited files (CSV/TSV).

Create a Data Source Name in iODBC with the CData ODBC Driver for CSV and work with CSV/TSV Files in Microsoft Excel on Mac OS X.

Use standard PowerShell cmdlets to access Excel Online tables.

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.