SimplicityCollect Alert: There was a problem reading the Excel File. ‘Sheet1$’ is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
This error occurs in the Account Importer, as well as the Debtor and Account Updater Tools. This will appear if the file you are attempting to upload and map is in .xlsx format, but the sheet name (located in the lower left of the Excel file) is anything other than “Sheet1”.
To remedy this, you can change the sheet name to Sheet1, by right-clicking on the tab and selecting Rename.
Another option is to re-save the file in csv. format. Doing this will remove the tab name restriction, and will typically default the tab name to match the Excel File name.