How to validate construction Excel data before an ERP import
Use a small import and control totals to find unit, date and duplicate errors.
By ENRO team
Validate an import by comparing the resulting records with a known source total and checking the actual workflow status. A successful upload message does not prove that quantities, permissions or financial totals are correct.
Test a small set first
Illustrative sample: ten supplier bills total ₹2,40,000. After import, count the ten intended records and compare the amount with the same tax basis and currency. If the dashboard shows zero, inspect whether those bills are drafts or require approval before assuming they were lost.
Do not force a status solely to make a dashboard number agree. Confirm the product's supported import columns and allowed statuses first.
Prepare the source sheet
- Keep a stable source reference for each row.
- Map company and project names to the correct existing records.
- Use explicit dates and preserve identifiers with leading zeros.
- Normalize units; bags, kilograms and tonnes must remain distinct.
- Separate amount, currency and tax-related fields as the template requires.
- Remove unintended formulas or merged cells from the upload copy.
- Mark possible duplicates for review instead of deleting similar rows blindly.
If the product accepts only CSV for that workflow, export the workbook to its required CSV format. Native spreadsheet support should be tested, not assumed from a general marketing description.
Verify after import
Inspect representative records, including one unusual date, one large amount and one row with optional fields blank. Check role access and project assignment. Export a supported view and reconcile counts and totals back to the original source.
Keep rejected rows, correction notes and the import time. Before retrying, establish whether the importer updates existing rows or creates new ones. Re-uploading the entire file without that answer can duplicate valid records.
Use sample data for the pilot. Retain an independent original file so a correction does not depend on the imported copy alone.