When uploading a spreadsheet, you may receive the message:
“Unable to open file… File may not be a valid Excel workbook.”
Although the file name and visible formatting may appear correct, hidden formatting, often picked up when copying data between sources, can cause Excel to behave unpredictably and prevent Donorfy from processing the file.
Fix the Excel Workbook Error
Follow these steps to remove hidden formatting and create a clean file for upload:
Open the original Excel workbook.
Copy all data from the sheet.
Create a new Excel workbook.
Paste the data using Paste as Values to remove hidden formatting.
Set any date fields to Short Date (dd/mm/yyyy).
Rename the worksheet tab to match the required upload process.
This determines how the File Uploader processes your file.
Choose Save As and save your workbook.
Upload the newly saved file to Donorfy.
The upload should now complete successfully without the error message.