Excel 365 Save or Open an ODC File

In this article, I will show you how to open an ODC file in Excel, or create one if you need to.

What is an ODC (Office Data Connection) File?

An ODC file contains the information related to an external data query created with Power Query (also known as Get & Transform) in Excel. The ODC file can be used separately from the workbook file to share the query without sharing the rest of the data in a workbook. This way, queries can be shared across different workbooks where you may want to use the query. For instance, you may have a query to get the latest bitcoin prices. By creating (or using) an ODC file, you can set this query up once and use it in one workbook to make price forecasts and another to monitor the value of your personal portfolio.

Continue reading “Excel 365 Save or Open an ODC File”

Excel Import PDF Using Get & Transform Query Connection

Microsoft has introduced a feature in Microsoft Excel 365 that makes it easy to import data from PDFs on your computer or directly from the web. The feature has its quirks but will work for many applications. In this article, I will show you how to check if the feature is available in your version of Excel and import data from a PDF on the web.

Continue reading “Excel Import PDF Using Get & Transform Query Connection”