Top Row Errors

Cause: Due to empty cells from the template guide at the top of the spreadsheet.
Action:

Remove template guide rows before loading the file to the Data Grid, or
Remove rows in the Data Grid (right-click on the row → “Remove Row”), then re-submit the data.

Final Column Errors

Cause: Responses are case-sensitive and must be “Yes” or “No” format only.
Action:

For a few red errors, use the white drop-down arrows in the Data Grid.
For many red errors, correct them in the Excel template. Clear the Data Grid, then re-load the corrected file.

Gender Column Errors

Cause: Must be “Male” or “Female” (case-sensitive).
Action:

Use the drop-down arrows in the Data Grid for small fixes.
For many errors, fix the Excel file, clear the grid, and re-upload.

Response Column Errors

Cause: Responses must exactly match the current reporting year measure templates and are case-sensitive.
Action:

Use only current reporting year template responses (not older versions).
Fix extra spaces, punctuation, or spelling.
Minor issues: correct in the Data Grid.
Major issues: fix in the Excel template and re-upload.

Date of Service (DOS) and Date of Birth (DOB) Errors

Accepted Formats:

4/15/2025
04/15/2025
2025-04-15

Action:

Correct date formats or future dates.
Use drop-downs for minor corrections; edit the Excel file for bulk fixes.

Measure-Specific Age Requirement Errors

Cause: Patient doesn’t meet age requirements per CMS “denominator” criteria.
Action:

Remove these patients from the file before uploading.

NPI (National Provider Identifier) Errors

Cause: Must be a 10-digit Individual NPI (no dashes or spaces).
Action:

Fix number format or transpositions.
Ensure the NPI is individual, not organizational.
Fix in Data Grid for few issues; Excel template for many.

TIN (Tax Identification Number) Errors

Cause: TIN must be 9 digits, no dashes or spaces.
Action:

Correct transposed or missing digits.
Validate format and accuracy.
Minor errors: fix in the Data Grid.
Major errors: correct the Excel file and re-upload.

Software Freeze/Spin After Measure Selection

Cause: Phantom data from unsubmitted or uncleared uploads.
Action:

Click Clear Grid and then “OK” to reset before trying again.

Header Error – “No Header” Found

Cause: Extra data in columns beyond the template.
Action:

Copy only template headers/data into a clean Excel sheet.
Or drag “No Header” into the drop zone → becomes “Exclude Column” → continue.

Header Error – Header Mismatch

Cause: Column headers don’t match the template.
Action:

Drag incorrect header out → drag correct one in → click “Continue”.
If uploading frequently, update headers directly in the Excel file.

Excel Troubleshooting Resources

How to Split First and Last Name into Separate Columns in Excel

If you have full names in a single column (e.g., "John Smith") and want to separate them into First Name and Last Name columns, follow these simple steps:

🛠️ Method 1: Use Excel's Text to Columns Feature

Select the column containing full names.
Go to the Data tab on the ribbon.
Click Text to Columns.
Choose Delimited, then click Next.
Select Space as the delimiter (you can uncheck other boxes), then click Next.
Choose destination columns if needed, then click Finish.

⚠️ Note: This method works best when each name has exactly one space (i.e., "First Last"). For names with middle names or suffixes, use Method 2 below.

🧪 Method 2: Use Excel Formulas

If names vary in format, use these formulas in new columns:

First Name:
```
=LEFT(A2, FIND(" ", A2) - 1)
```
Last Name:
```
=RIGHT(A2, LEN(A2) - FIND(" ", A2))
```

Replace A2 with the cell that contains the full name.

🧼 Pro Tip: Clean Before You Split

Remove leading/trailing spaces using =TRIM(A2)
Standardize name format before applying any method

🔍 How to Use Find and Replace in Excel

Excel’s Find and Replace feature helps you quickly locate and update specific text, numbers, or formatting across your worksheet or workbook.

✨ Step-by-Step Instructions

✅ To Find a Value:

Open your Excel file.
Press Ctrl + F (or Command + F on Mac) to open the Find tab.
In the Find what box, type the text or number you want to locate.
Click Find Next to go to the first match.
Click Find All to display all instances.

🔁 To Find and Replace a Value:

Press Ctrl + H (or Command + H on Mac) to open the Replace tab.
In the Find what box, enter the value you want to change.
In the Replace with box, enter the new value.
Click:
- Replace – to update just the current match.
- Replace All – to update every instance in the sheet.

⚙️ Optional Settings (Click Options »)

Within: Choose between searching the current Sheet or the entire Workbook.
Search: Choose by Rows or Columns.
Look in: Search within Formulas, Values, or Comments.
Match case: Only find items with the exact uppercase/lowercase.
Match entire cell contents: Find cells that exactly match the search term.

🧠 Tips

You can search and replace partial values (e.g., change all "-2024" to "-2025").
Use * (asterisk) as a wildcard for any characters, and ? (question mark) for a single character.
Always Save your file first before using Replace All, especially on large sheets.