Import Claims - Upload Errors


How to import OHIP claims into

When importing claims using our Excel template, any rows on the spreadsheet that are missing information will be listed on the Upload Claim Error window.

If you notice errors during import, but the cells in the spreadsheet are showing correctly, it may be due to "special hidden" characters in the template (likely from a carriage return or space, from when the rows were copy and pasted from your application).

In the example below, row 15, 19, 101 in the template have service codes populated.  However, during the import, error message was showing with: 'No services found for claim'. billing template

To avoid this issue,  copy and paste the rows from your existing spreadsheet into a new spreadsheet template, using the Paste Special - VALUES feature from MS Excel. This will remove any special hidden characters.
Steps as follows:

1) Select all rows from original spreadsheet -> Right Click --> COPY Excel copy menu


2) Open new spreadsheet template.  Right Click --> PASTE SPECIAL -->  VALUES

 Excel paste special

Excel paste special screen select values


3) Upload new spreadsheet into


Was this article helpful?
0 out of 1 found this helpful