Every column
- Empty cell
- Extra spaces
- Broken accents (wrong encoding)
THE MAGIC SERVICES · ENVIGADO
Check your list before it moves
An Android app that reads your customer, supplier or product list on the phone, checks it with Colombian rules and lets you send The Magic Services a profile with counts only. The rows never leave the phone.
NIT check digits
60X fixed lines
Email typos
DIVIPOLA places
Dates and amounts
Repeated rows
WHAT IT LOOKS FOR
Common problems, Colombian rules
Each finding says why it matters and how to fix it in your spreadsheet. A clean score is not a guarantee: the checks catch common format problems.
NIT
- NIT check digit does not match
- NIT without its check digit
- Not a NIT
ID numbers
- Letters or symbols in a numeric ID
- ID length outside the usual range
- Unknown ID type
Phones
- Fixed line without its 60X prefix
- Not a Colombian mobile or fixed line
- More than one number in a cell
- Not an email address
- Likely typo in the email domain
Dates
- Not a date
- Date that does not exist
- Day and month could be swapped
- Day and month in a different order from the rest
- Date in the future
Amounts and quantities
- Not an amount
- Different decimal separators in one column
- Negative amount
- Far from the other amounts
- Not a whole number
- Negative quantity
Places
- Department not in DIVIPOLA
- Municipality not in DIVIPOLA
- Municipality not in the row's department
The whole file
- Repeated record
TRY IT IN THE BROWSER
Paste a few rows
The checker on this site runs the same rules on up to 50 pasted rows, in your browser. Nothing is uploaded.
Open the checker
Rows stay in this browser
FOUR STEPS
From file to profile
- 1
Open your CSV
Pick the file from the phone, or try the bundled example. The app reads it; it never edits it.
- 2
Say what each column holds
The app guesses from the headers: name, ID, NIT, phone, email, place, date, amount.
- 3
Read the findings
A score per column, counts per rule, masked examples and the steps to fix each one in your spreadsheet.
- 4
Send a profile, not your data
Counts only: you see the exact text before it goes by email, share or a call.
Questions about the data part of your project?
Call or write to The Magic Services and ask what it can take on. The app and this site check formats; they do not promise any service.