View MIPS Measures in Excel

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).

Download Measures

To select Quality measures, CMS instructs you to:

What is Macra

  1. Go to Quality Measures page on the qpp.cms.gov website.
  2. Review and select the measures that best fit your practice.
  3. 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.
  4. If an outcome measure is not available that is applicable to your specialty or practice, chose another high priority measure.
  5. Download a CSV file of the measures you have selected for your records.

To select Advancing Care Information measures, CMS instructs you to:

  1. Review and select the measures available.
  2. Download a CSV file of the selected measures for your records.

To select Improvement Activities, CMS instructs you to:

  1. 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.
  2. 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:

  1. Open the CSV file in Microsoft Excel
  2. Select Column A
  3. Choose Data > Text to Columns
  4. In the Covert Text to Columns Wizard, select the Deliminated button, and click Next.
  5. Select the Comma check box, and click Next.
  6. Click Finish.
  7. 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.
  8. Save the file in XLS format, renaming it accordingly.

The end result should look something like that shown in Figure A.

Figure-A

Renee Dustman

Renee Dustman

Executive Editor at AAPC
Renee Dustman, BS, MACRA Proficient, is an executive editor at AAPC. She holds a Bachelor of Science degree in Media Communications - Journalism. She has more than 20 years experience in print production and content management, and has worked in a variety of capacities for several publications.
Renee Dustman

Latest posts by Renee Dustman (see all)

About Has 515 Posts

Renee Dustman, BS, MACRA Proficient, is an executive editor at AAPC. She holds a Bachelor of Science degree in Media Communications - Journalism. She has more than 20 years experience in print production and content management, and has worked in a variety of capacities for several publications.

Leave a Reply

Your email address will not be published. Required fields are marked *