Page 1 of 1

The Data Janitor - Secure Intake

Name

Email (Delivery Address)

File Upload

Please restrict file types to csv, xlsx, xls

Accepts .csv, .xls, .xlsx files

Size limit: 10 MB

How would you like your cleaned data delivered?

Option 1: Standard CSV only ($250)

Option 2: Standard CSV + Formatted PDF ($299)

Destination System (Schema Mapping)

Premium Add-ons

Verify Email (+$99)

Mobile Detection (+$49)

Timezone (+$49)

Default Standardardization Settings

- TEMPORAL (Dates/Times): Re-format all dates to ISO 8601 standard (YYYY-MM-DD). - CONTACT (Phones/Emails): Standardize phones to international E.164 (+1-XXX-XXX-XXXX). Convert emails to strictly lowercase, fixing obvious typos ('.con' to '.com') and stripping trailing spaces. - FINANCIAL (Currency/Numbers): Strip currency symbols ($, €, £) and formatting commas. Convert to a pure numeric decimal format (e.g., "$1,234.56" becomes "1234.56"). - CATEGORICAL (Booleans): Standardize mixed positive/negative indicators (1/0, Y/N, Yes/No, T/F) into strict uppercase boolean values: "TRUE" or "FALSE". - LOCATIONAL (Addresses): Correct Cities to Proper Case. Convert US States and Countries to standard 2-letter ISO abbreviations. - NOMENCLATURAL (Names): Trim all leading/trailing whitespace. Correct names and company titles to Proper Case. - IDENTIFIERS (SKUs, IDs, Codes): STRICT PRESERVATION. NEVER strip letters, symbols, hyphens, or leading zeros from identifiers. Preserve exact formatting to prevent corrupting business logic. - FREE-TEXT (Notes/Descriptions): Remove unescaped quotation marks and rogue newline characters (\r or \n) inside individual text cells to protect the CSV row structure.