'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Where to Legally Buy Microsoft Office 2010, 2016, or 2019
Question details
The user is looking for legitimate sources to purchase older perpetual licenses of Microsoft Office, specifically versions 2010, 2016, or 2019, and needs access to the Power Query feature.
- Product
- Microsoft Office
- Device & OS
- not provided
- Scenario
- Purchasing a reliable, non-subscription version of Microsoft Office to use advanced data features like Power Query.
- Observed behavior
- Older perpetual versions of Office are no longer available on the Microsoft Store, and the free web version of Microsoft 365 does not support Power Query.
Before attempting to purchase older versions of Office, note that Microsoft has officially ended support for Office 2010 and Office 2016, meaning they no longer receive security updates or bug fixes.
Purchase Office 2019 from Verified Authorized Retailers
Since Microsoft no longer sells older non-subscription licenses directly, purchasing from trusted, authorized third-party retailers is the safest way to obtain a legal copy of Office 2019.
Finding legitimate older versions of Microsoft Office requires caution. Many websites offer steeply discounted product keys, but these are often volume licenses sold illegally that Microsoft may deactivate at any time.
Search for Office 2019 box copies or digital downloads at major, established retailers such as Amazon, Best Buy, Staples, or Office Depot.
When shopping on platforms like Amazon, ensure the product states "Ships from and sold by Amazon" rather than a third-party marketplace seller to avoid counterfeit software.
Read the product description carefully to ensure you are buying a full retail license (not an OEM key) that can be permanently tied to your Microsoft account.
Upgrade to a Paid Microsoft 365 Plan for Power Query
If your primary goal is to use Power Query, upgrading to a paid Microsoft 365 subscription is the most reliable way to access the fully featured desktop applications.
Try WPS Office as a Free, Lightweight Alternative
If you are struggling to find a legitimate copy of older Microsoft Office versions or prefer not to pay for a recurring Microsoft 365 subscription, WPS Office provides a powerful, free alternative. It offers robust spreadsheet capabilities and is highly compatible with Microsoft formats.
- 1. Visit the WPS Office website: Go to the official WPS website to download the latest free version for your operating system.
- 2. Install the application: Run the downloaded installer and follow the on-screen instructions to set up WPS Office.
- 3. Open and edit your files: Launch WPS Spreadsheet to open your existing .xlsx files and enjoy seamless document editing.
Frequently Asked Questions
Why is Power Query missing from my free version of Microsoft 365?
Power Query is an advanced data analysis feature that requires the desktop version of Excel. The free Microsoft 365 web version only provides basic spreadsheet functionalities and does not support Power Query. You must upgrade to a paid plan to use desktop apps.
Is it safe to buy cheap Microsoft Office product keys online?
No, it is highly risky. Unusually cheap product keys are often illicit volume licenses intended for large organizations. Purchasing these violates Microsoft's terms of service, and Microsoft regularly audits and deactivates these keys without offering a refund.
Does Microsoft still support Office 2010 and Office 2016?
No. Office 2010 reached its end of support on October 13, 2020, and Office 2016 reached its end of mainstream support on October 13, 2020 (with extended support ending in 2025). They no longer receive feature updates or regular security patches.
