From messy to ready / Selected work
Salesforce Spreadsheet Formatter
Python CLI for cleaning CSV and XLSX Salesforce exports before migration or Data Loader import.
Production-ready utility01 / The project
Behind the work.
This command-line tool normalizes spreadsheet exports into import-friendly values. It detects common Salesforce fields, preserves IDs as text, standardizes booleans and date formats, writes clean output files, and generates an issues report when values cannot be converted safely. The project is small but highly practical, and it includes automated tests around rule precedence, date handling, and file processing.
Make the next import easier.
Compare messy input with consistent output.
Import preparation
Id,Active,Date 001000000000001AAA,Yes,16/09/2026 001000000000002AAA,No,17/09/2026
Example conversion using day/month/year dates. IDs stay as text; booleans and dates become consistent.
03 / The build
Details that matter.
Normalizes IDs, booleans, dates, datetimes, and numeric values into import-friendly strings.
Uses config-driven rules and preview modes so the tool can adapt to different export structures.
Includes unit tests covering rule matching and workbook or CSV processing behaviour.
Core Tooling
Python / argparse CLI / openpyxl / CSV Processing
Rules Engine
Column Type Detection / Regex Pattern Rules / Datetime Normalization / Boolean Parsing
Output
Formatted Workbooks / Formatted CSV Files / Issues Reports / Preview Mode
Quality
unittest / Temporary File Tests / Config-Driven Behaviour
Have a related challenge?
Let’s talk about your project.
Tell me what you are trying to build, who it is for, and what a useful result would look like.