Cross-platform Excel VBA toolkit for customer data validation, issue reporting, and CSV export.
Designed for both Windows and macOS, with platform-specific export workflows for maximum reliability.
✓ Required Field Validation
✓ Email Format Validation
✓ Duplicate Detection
✓ Validation Summary Report
✓ CSV Validation Report Export
✓ Windows / macOS Support
✓ English + Japanese Source Code Comments
✓ Modular VBA Design
| Platform | Status |
|---|---|
| Windows | ✅ Fully Supported |
| macOS | ✅ Supported |
The CSV validation report is automatically exported as UTF-8 to the same folder as the workbook.
Example:
validation_report_20260719_073000.csv
Due to Excel for macOS sandbox and file-access restrictions, the native Save As dialog is used.
Recommended workflow:
- Save the file in your Downloads folder.
- Select:
CSV UTF-8 (Comma delimited) (.csv)
- After saving, open your Downloads folder to locate the exported report.
This design provides the most reliable experience across different versions of Excel for macOS.
Excel-Data-Validator
│
├── modules
│ ├── Validation.bas
│ ├── Dashboard.bas
│ ├── ProductValidation.bas
│ ├── ResearchValidation.bas
│ ├── InventoryValidation.bas
│ └── CsvExport.bas
│
├── images
│ └── architecture.svg
│
├── examples
│ ├── sample_customer_data.csv
│ ├── sample_product_data.csv
│ ├── sample_research_data.csv
│ └── sample_inventory_data.csv
│
├── Excel-Data-Validator.xlsm
│
├── LICENSE
└── README.md
| Row | Issue Type | Column | Value |
|---|---|---|---|
| 3 | Missing | Name | |
| 4 | Missing | ||
| 5 | Invalid | invalid-email |
- Architecture First
- Cross-platform compatibility
- English naming conventions
- English + Japanese comments
- Modular VBA design
- Excel Table friendly
- GitHub portfolio ready
- Stable cross-platform release
- Improved Dashboard
- Validation performance improvements
- Multi-sheet validation
- Custom validation rules
- Localization
- HTML validation report
- PDF export
- Power Query integration
MIT License