Download over 1 million rows from data.cms.gov

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

ParamRay

Well-known Member
Joined
Aug 6, 2014
Messages
1,195
Use the power query from web option and use this URL instead: https://data.cms.gov/resource/h886-e5zp.json

I found this by going to the URL in your original post and clicking: Export > SODA API > API Endpoint.


You'll then need to convert the list of records into a table in power query via Transform > Convert > To Table, and then expand the new column.
 
Last edited:

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,087
.
Download complete txt file : https://www.amazon.com/clouddrive/share/WrQfnjhCjdlokqmYaHMbMuw72naixV9P1EOxOkq44RL

Open with NOTEPAD, copy all, then paste into Excel. It will auto separate into the three columns. Go to last row on sheet, note number / physician name ...
then search for that in NOTEPAD. Copy every AFTER that name .. then paste those into the second sheet of Excel.


Download complete Excel file : https://www.amazon.com/clouddrive/share/Ohx8lIQrSWGOy4PciKoQ5LkyqFZh2xlrKk2Qd8hhLPU


Each of the two files is approx. 30 mb is size.

I downloaded CSV FOR EXCEL from the website for each.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,608
Messages
5,445,443
Members
405,333
Latest member
PapoGator24

This Week's Hot Topics

Top