Products

Solutions

Connectors

Support

Company

Resources

Search

Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Smartsheet Excel Articles

«
1

Access Live Smartsheet in Excel 365 Online (Excel for the web)

Connect to Smartsheet from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Explore Geographical Relationships in Smartsheet with Power Map

Create data visualizations with Smartsheet in Power Map.

Use the CData ODBC Driver for Smartsheet from SharePoint Excel Services

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

Work with Live Smartsheet in Power Query

Use CData Connect Cloud to connect to Smartsheet and work with live Smartsheet in Microsoft Power Query.

How to update Smartsheet from Excel

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

How to update Smartsheet from Excel

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

Import and Visualize Smartsheet in Power View

Create data visualizations based on Smartsheet in Excel.

Excel Spreadsheet Automation with the QUERY Formula

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

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

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

Author and Share Power BI Reports on Real-Time Smartsheet

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

Use the CData ODBC Driver for Smartsheet in Microsoft Power Query

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

Access Live Smartsheet in Excel (Desktop)

Use CData Connect Cloud to gain access to live Smartsheet from your Excel spreadsheets.

«
1

CData Software is a leading provider of data access and connectivity solutions. Our standards-based connectors streamline data access and insulate customers from the complexities of integrating with on-premise or cloud databases, SaaS, APIs, NoSQL, and Big Data.

Connect With Us

Get Started

Data Connectors

ETL/ ELT Solutions

Cloud & API Connectivity

OEM & Custom Drivers

Connect With Us

Get Started

Data Visualization

Company

Resources