Learn more
 

CData Software - Knowledge Base

Recent FTP Excel Articles

Explore Geographical Relationships in SFTP with Power Map

Create data visualizations with SFTP in Power Map.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

How to connect to FTP from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for FTP and work with FTP Servers in Microsoft Excel on Mac OS X.

Use the CData ODBC Driver for SFTP from SharePoint Excel Services

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

Explore Geographical Relationships in FTP with Power Map

Create data visualizations with FTP Servers in Power Map.

Use the CData ODBC Driver for SFTP in Microsoft Power Query

You can use the CData SFTP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SFTP into Microsoft Power Query.

Author and Share Power BI Reports on Real-Time SFTP

Use the CData ODBC Driver for SFTP to visualize SFTP in Power BI Desktop and then upload to the Power BI service.

Import and Visualize FTP in Power View

Create data visualizations based on FTP Servers in Excel.

Use the CData ODBC Driver for FTP in Microsoft Power Query

You can use the CData FTP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FTP Servers into Microsoft Power Query.

Import and Visualize SFTP in Power View

Create data visualizations based on SFTP in Excel.

Import FTP into Microsoft Power Query

The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access FTP Servers. In this article, you will use the OData format to import FTP Servers into Microsoft Power Query.

How to update FTP from Excel

This article explains how to transfer data from Excel to FTP using the Excel Add-In for FTP.

Author and Share Power BI Reports on Real-Time FTP

Use the CData ODBC Driver for FTP to visualize FTP Servers in Power BI Desktop and then upload to the Power BI service.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

How to update SFTP from Excel

This article explains how to transfer data from Excel to SFTP using the Excel Add-In for SFTP.