Introduce a pre-import validation or alert mechanism that automatically scans uploaded Excel files and flags any known unsupported elements—such as:
- Merged cells
- Locked/protected sheets
- Unsupported checkbox or formula fields
- Complex formatting not compatible with export logic
This validation should notify users before import completion, helping them identify and address potential issues proactively.
Value/Impact:
- Prevents data loss or export discrepancies.
- Improves user transparency and trust in the import/export process.
- Reduces support tickets related to formatting issues.
- Enhances the overall usability of Excel-based project imports.