Connect PowerPoint to Your Data: Guides by Source

Connect Microsoft PowerPoint to your data.

INSYNCR links PowerPoint to 22 data sources, from Excel and SharePoint to SQL Server and Salesforce. Pick the guide for the source your report already uses. It shows the steps and the plan you need.

The plan follows the source. Starter reads Excel and Excel Online. Business adds SharePoint, Access, Google Sheets and more. Professional adds SQL Server, Salesforce and other databases.

Videos in this topic

9 short videos, each under two minutes.

How to link Excel to PowerPoint so your numbers update
How to connect SQL Server to PowerPoint
Which data sources can INSYNCR connect to PowerPoint?
How to connect Microsoft Access to PowerPoint
How to build a board pack in PowerPoint straight from SQL Server
How to make a PowerPoint report from a CSV or text file
How to connect JSON data to PowerPoint
How to build a PowerPoint report from a custom SQL query
How to build a statistics release in PowerPoint from SQL Server

Every video, in every topic, is on the videos page.

Guides by data source

Excel: link a local workbook to text, tables and charts. Starter.
SharePoint and Excel Online: lists, libraries and cloud workbooks. Starter or Business.
Microsoft Access: tables, saved queries or your own SQL. Business.
SQL Server: tables, views or custom SQL, read straight from the database. Professional.
Salesforce: pipeline and account data on your slides. Professional.
Microsoft Dynamics: accounts, opportunities and cases. Professional.
Power BI: what works, what doesn't, and how to reach the same tables.
Google Sheets: from manual updates to a report that refreshes.

Your first connection

Your first data connection: what a connection and a query are, with fixes for common errors.
PowerPoint from Excel, automatically: the full guide, start to finish.
Relative and absolute paths: when to use a full path and when just the file name.
Excel macros and INSYNCR: run a macro as part of the data step.

Background reading

How to link PowerPoint to Excel data: the enterprise guide to linking that lasts.
The best tools to link Excel to PowerPoint: an honest comparison.
PowerPoint and SQL for executive reporting: patterns and governance.
Real time data integration: a guide for automated reporting.
APIs for live data presentations: what to connect and how.
Live data and financial decisions: why current numbers matter.
Live data and the financial close: fewer late nights at month end.

Which plan reads which source

Pricing: every source and plan, line by line.
Starter: Excel and Excel Online.
Business: SharePoint, Access, Google Sheets, MySQL, JSON and XML.
Professional: SQL Server, Oracle, PostgreSQL, Salesforce, Dynamics, ODBC and OData.
Power BI vs INSYNCR: the dashboard and the deck.