- Fully-installed versions of Outlook, Word, Excel, PowerPoint, OneNote for Windows or Mac
- Web versions of Word, Excel, PowerPoint, and OneNote
- Real-time co-authoring so multiple users can work in the same document, simultaneously
- Fully-installed and always up-to-date versions of Outlook, Word, Excel, PowerPoint, OneNote for iOS, Android or Windows mobile devices
- Each user can install the Office apps on up to 5 phones and 5 tablets
- 1 TB of OneDrive storage for file storage and sharing
- Work on a file and save it directly to OneDrive or SharePoint; your changes are updated across your sync’d devices.
- Share files with external contacts by providing access or guest links
- Securely share documents and send emails so only those with the right permissions can access the information
- Access and sync files on PC or Mac and mobile devices
- Meets key international, regional, and industry-specific standards and terms, with more than 1,000 security and privacy controls
- Control who and when someone has access to your business information with security groups and custom permissions
- Create password policies that require users to reset their passwords after a specified number of days.
- Use your own custom domain name (e.g. [email protected])
- Business-class email on phones, tablets, desktops, and the web with Exchange
- Manage your calendar, share available meeting times, schedule meetings, and get reminders
- Schedule meetings and respond to invitations with ease using shared calendars
- Host online meetings and video calls for up to 250 people with Microsoft Teams
- Chat with your team from your desktop or on the go with Microsoft Teams
- Bring together all your team’s chats, meetings, files, and apps so you can easily connect and collaborate from one place with Microsoft Teams
- Create team sites to share information, content, and files throughout your intranet using SharePoint
- Plan schedules and daily tasks with Microsoft Teams
- Make it easier for your customers to schedule and manage appointments with Microsoft Bookings
- Get a lightweight CRM solution to nurture customer relationships with Outlook Customer Manager
- Have real-time, accurate mileage tracking and reporting in the palm of your hand with MileIQ
Office 365 Business
(annual commitment)Office 365 Business
- Fully-installed versions of Outlook, Word, Excel, PowerPoint, OneNote for Windows or MacPlus Access and Publisher (for PC only)
- Web versions of Word, Excel, PowerPoint, and OneNote
- Real-time co-authoring so multiple users can work in the same document, simultaneously
- Fully-installed and always up-to-date versions of Outlook, Word, Excel, PowerPoint, OneNote for iOS, Android or Windows mobile devices
- Each user can install the Office apps on up to 5 phones and 5 tablets
- 1 TB of OneDrive storage for file storage and sharing
- Work on a file and save it directly to OneDrive or SharePoint; your changes are updated across your sync’d devices.
- Share files with external contacts by providing access or guest links
- Securely share documents and send emails so only those with the right permissions can access the information
- Access and sync files on PC or Mac and mobile devices
- Meets key international, regional, and industry-specific standards and terms, with more than 1,000 security and privacy controls
- Control who and when someone has access to your business information with security groups and custom permissions
- Create password policies that require users to reset their passwords after a specified number of days.
- Use your own custom domain name (e.g. [email protected])
- Business-class email on phones, tablets, desktops, and the web with Exchange
- Manage your calendar, share available meeting times, schedule meetings, and get reminders
- Schedule meetings and respond to invitations with ease using shared calendars
- Host online meetings and video calls for up to 250 people with Microsoft Teams
- Chat with your team from your desktop or on the go with Microsoft Teams
- Bring together all your team’s chats, meetings, files, and apps so you can easily connect and collaborate from one place with Microsoft Teams
- Create team sites to share information, content, and files throughout your intranet using SharePoint
- Plan schedules and daily tasks with Microsoft Teams
- Make it easier for your customers to schedule and manage appointments with Microsoft Bookings
- Get a lightweight CRM solution to nurture customer relationships with Outlook Customer Manager
- Have real-time, accurate mileage tracking and reporting in the palm of your hand with MileIQ
- Fully-installed versions of Outlook, Word, Excel, PowerPoint, OneNote for Windows or MacPlus Access and Publisher (for PC only)
- Web versions of Word, Excel, PowerPoint, and OneNotePlus a web version of Outlook
- Real-time co-authoring so multiple users can work in the same document, simultaneously
- Fully-installed and always up-to-date versions of Outlook, Word, Excel, PowerPoint, OneNote for iOS, Android or Windows mobile devices
- Each user can install the Office apps on up to 5 phones and 5 tablets
- 1 TB of OneDrive storage for file storage and sharing
- Work on a file and save it directly to OneDrive or SharePoint; your changes are updated across your sync’d devices.
- Share files with external contacts by providing access or guest links
- Securely share documents and send emails so only those with the right permissions can access the information
- Access and sync files on PC or Mac and mobile devices
- Meets key international, regional, and industry-specific standards and terms, with more than 1,000 security and privacy controls
- Control who and when someone has access to your business information with security groups and custom permissions
- Create password policies that require users to reset their passwords after a specified number of days.
- Use your own custom domain name (e.g. [email protected])
- Business-class email on phones, tablets, desktops, and the web with Exchange
- Manage your calendar, share available meeting times, schedule meetings, and get reminders
- Schedule meetings and respond to invitations with ease using shared calendars
- Host online meetings and video calls for up to 250 people with Microsoft Teams
- Chat with your team from your desktop or on the go with Microsoft Teams
- Bring together all your team’s chats, meetings, files, and apps so you can easily connect and collaborate from one place with Microsoft Teams
- Create team sites to share information, content, and files throughout your intranet using SharePoint
- Plan schedules and daily tasks with Microsoft Teams
- Make it easier for your customers to schedule and manage appointments with Microsoft Bookings
- Get a lightweight CRM solution to nurture customer relationships with Outlook Customer Manager
- Have real-time, accurate mileage tracking and reporting in the palm of your hand with MileIQ
The following list details which versions of Excel include the Get & Transform (Power Query) experience.
Always have the most up-to-date Office 365 apps, features, and security, along with access to your files anywhere you go. Best for businesses that need Office apps plus cloud file storage and sharing on PC, Mac, or mobile. Business email not included. Best for businesses that need business email. Office 365 Business provides all the familiar, installable apps you've come to depend on like Microsoft Word, Excel, PowerPoint and Outlook, on the devices you use most—like your laptop, tablet.
Excel 2019 and Excel 2016 for Windows
The Get & Transform (Power Query) experience is available in all Excel 2019 and 2016 for Windows plans on the Data tab under the Get & Transform section. The following table shows basic and advanced features available by version.
Connector Name | Office 2016 Home & Student Home & Business Standard Professional | Office 2016 Professional Plus Standalone | Office 2019 Home & Student Home & Business Standard Professional | Office 2019 Professional Plus Standalone | Office 365 Home Personal Business Business Premium | Office 365 ProPlus |
|---|---|---|---|---|---|---|
Excel workbook | ||||||
Text & CSV | ||||||
XML | ||||||
JSON | ||||||
Local folder | ||||||
SharePoint Folder | ||||||
SQL Server | ||||||
Microsoft Access | ||||||
Analysis Services | ||||||
SQL Server Analysis Services (Import) | ||||||
Oracle | ||||||
IBM Db2 | ||||||
MySQL | ||||||
PostgreSQL | ||||||
Sybase | ||||||
Teradata | ||||||
SAP HANA | ||||||
Azure SQL Database | ||||||
Azure SQL Data Warehouse | ||||||
Azure HDInsight (HDFS) | ||||||
Azure Blob Storage | ||||||
Azure Table Storage | ||||||
Azure Data Lake Storage | ||||||
Azure Data Explorer | ||||||
SharePoint Online List | ||||||
Microsoft Exchange Online | ||||||
Dynamics 365 (online) | ||||||
Facebook | ||||||
Salesforce Objects | ||||||
Salesforce Reports | ||||||
Table/Range | ||||||
Web | ||||||
Microsoft Query | ||||||
SharePoint List | ||||||
OData Feed | ||||||
Hadoop File (HDFS) | ||||||
Active Directory Bobby mac deluxe car seat owners manual. | ||||||
Microsoft Exchange | ||||||
ODBC | ||||||
OLEDB | ||||||
Blank Query |
Basic business analytics features
- Available with any Office 365 subscription, Office 2019 or Office 2016.
- Import data from private files, databases and websites:
- CSV & Text, Table/Range, Excel workbook, XML, JSON, Folder, Access, SQL Server, Web, OData feed, Analysis Services, Facebook, ODBC, OLEDB, and Microsoft Query.
Mac Numbers
Advanced business analytics features
- Available with Office 365 ProPlus, Office 2016 Professional, Office 2016 Professional Plus, and Excel 2016 standalone.
- In addition to basic business analytics features, you can also import data from corporate, big-data, and cloud data sources.
- Databases:
- Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, and SAP Hana.
- Azure:
- Azure SQL Server, Azure SQL Data Warehouse, Azure HDInsight (HDFS), Azure Blob Storage, Azure Table, and Azure Data Lake Store.
- Other sources:
- SharePoint, Active Directory, Hadoop, Exchange, Dynamics CRM, and Salesforce.
Excel 2010 and Excel 2013 for Windows
Power Query is a free add-in that can be downloaded here: Download the Power Query add-in. Once enabled, Power Query functionality is available from the Power Query tab on the ribbon.
Excel for Office 365 for Mac
If you're an Office 365 subscriber, and have signed up for the Insiders Program, then you can refresh existing Power Query queries on your Mac for connections to Text, CSV, XLSX, XML and JSON files. The refresh functionality is live for all Office Insiders Fast customers in Excel for Mac, version 16.26 (19052200) and later.
Excel 2011 and Excel 2016 for Mac
Mac Excel Trial
Get & Transform (Power Query) is not supported.
Excel for Android, iOS and Online
Get & Transform (Power Query) is not supported.
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.
