Skip to main content

How to connect Google Sheets to live Medicare data

This is pretty cool. Medicare/CMS posts a lot of their data in two main websites for public consumption:

Data.Medicare.gov
Data.CMS.gov

I don't know why these two are separated, but it does seem like they host two separate datasets of healthcare data.

One can connect Windows Excel to an OData feed from Medicare/CMS, but I can't figure out how to do it with Mac Excel '11 (I don't have a Windows computer). I prefer using Google Sheets anyways, so I wanted to find an easy way to connect Sheets to Medicare/CMS data.

Here's the technique I have found, and please let me know if there is a better way:

1. First, access the table of data you want. For me it was this one:

https://data.cms.gov/Public-Use-Files/Medicare-Provider-Utilization-and-Payment-Data-Phy/ee7f-sh97

2. Because these tables are usually massive, you will probably need to login and create a saved view of a subset of the data.

Here's the subset of data I created, where I did a search for "Mohseni":

https://data.cms.gov/Public-Use-Files/test1/5fxd-ai9f



3. Click on "Export", then "Download",  and then right click and save the link to the CSV file. Let me clarify: don't click the CSV file to download it, rather right click and save the LINK to the CSV file. It should be something like this:

https://data.cms.gov/api/views/5fxd-ai9f/rows.csv?accessType=DOWNLOAD

4. Go to Google Sheets and use the following function:

=IMPORTDATA("url")

... and put your url that you just copied in the url spot.

=IMPORTDATA("https://data.cms.gov/api/views/5fxd-ai9f/rows.csv?accessType=DOWNLOAD")

...

Now, every time the data is updated, your Google Sheet will update as well.

This process will not work if your data set is too large.

Comments

Post a Comment

Popular posts from this blog

IEEPA Tariff Refund Checklist (2026): How U.S. Importers Can Recover Duties Without Missing Deadlines

 If your company paid IEEPA-related import duties in 2025–2026, the biggest risk right now is not “whether refunds exist.” The biggest risk is operational: teams miss filing windows, submit incomplete data, or assume refunds are automatic. They’re not. Recent legal and agency developments created meaningful refund opportunities for many importers. But recovery still depends on entry-level details, liquidation posture, and execution quality. This guide gives you a practical, deadline-first checklist to maximize recoverable dollars while minimizing avoidable errors. Important: This article is informational and not legal advice. Why this matters now Three facts can all be true at once: The Supreme Court changed the legal landscape for IEEPA tariffs. CBP is operationalizing refunds through staged systems and rules. Importers can still lose rights if they wait too long or file the wrong pathway. In plain English: the legal headline helped, but workflow discipline still de...
Post a Comment
Read more

Dr. Alex Mohseni invited to speak at Brault’s Healthcare Leadership Forum about the future of Emergency Medicine services and how ED groups can adapt using telemedicine.

  Dr. Mohseni presented on the topic of how Emergency Medicine groups could expand their scope of practice to the virtual space to and how to do so in a financially viable way.
Post a Comment
Read more

DisabilityProAI: Faster, Defensible Medical Record Summaries for Disability Cases

 If you’ve ever tried to prep a Social Security Disability (SSD/SSI) or long-term disability case with tens of thousands of pages of medical records, you know the grind: clunky PDFs, handwriting, labs and imaging in odd formats, and a mountain of data that must be accurate, complete, and cited to the page. That’s why we built DisabilityProAI . Below is a plain-English overview you can share with your team or clients: what it is, who it’s for, and how it solves the most painful parts of disability case prep—at scale. What is DisabilityProAI? DisabilityProAI is an AI-powered platform purpose-built for disability attorneys, hearing representatives, paralegals, and case managers . It ingests massive medical record sets (well over 500 MB) , performs high-quality OCR that preserves tables, forms, and handwriting structure , and produces accurate, page-specific, citation-rich summaries you can trust. It also lets you chat with the documents —ask follow-up questions, trace where f...
Post a Comment
Read more