View MIPS Measures in Excel
To participate in the Medicare Incentive Payment System (MIPS), you will need to select the Quality, Improvement Activities, and/or Advancing Care Information measures on which you will report this year. The Centers for Medicare & Medicaid Services (CMS) offers an online tool that allows you review and download the various measures for informational and estimation purposes (You cannot use this tool to submit or attest to measures or activities).
To select Quality measures, CMS instructs you to:
- Go to Quality Measures page on the qpp.cms.gov website.
- Review and select the measures that best fit your practice.
- Add up to six measures from the list, including one outcome measure. You can use the search and filters to help find the measures that meet your needs or specialty.
- If an outcome measure is not available that is applicable to your specialty or practice, chose another high priority measure.
- Download a CSV file of the measures you have selected for your records.
To select Advancing Care Information measures, CMS instructs you to:
- Review and select the measures available.
- Download a CSV file of the selected measures for your records.
To select Improvement Activities, CMS instructs you to:
- Review and select activities that best fit your practice.
- Most participants: Attest that you completed up to 4 improvement activities for a minimum of 90 days.
- Groups with fewer than 15 participants, or if you are in a rural or health professional shortage area: Attest that you completed up to two activities for a minimum of 90 days.
- Download a CSV file of the activities you have selected for your records.
Format the Files
The resulting files are CSV (comma-separated value) text files that require a bit of formatting to be of any use, especially if you downloaded all the measures for review. Here’s how to turn a CSV file into a workable Excel sheet:
- Open the CSV file in Microsoft Excel
- Select Column A
- Choose Data > Text to Columns
- In the Covert Text to Columns Wizard, select the Deliminated button, and click Next.
- Select the Comma check box, and click Next.
- Click Finish.
- In the resulting spreadsheet, expand the width of the populated columns to see all the content; or select the cells and choose Format > Cells. In the resulting dialog box, on the Alignment tab, select the Wrap Text check box. Click OK.
- Save the file in XLS format, renaming it accordingly.
The end result should look something like that shown in Figure A.
Latest posts by Renee Dustman (see all)
- Stakeholders Rebuke Hospital Price Transparency Final Rule - December 6, 2019
- New G Codes Bundle Opioid Use Disorder Treatment - November 25, 2019
- Hospitals Ordered to Offer Patients Price Transparency - November 15, 2019