Salesforce Spreadsheet Formatter

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.

Role and Focus

Built a focused Python CLI to remove spreadsheet cleanup work from Salesforce migration prep and make import failures easier to diagnose.

Tech Stack

Core Tooling

Pythonargparse CLIopenpyxlCSV Processing

Rules Engine

Column Type DetectionRegex Pattern RulesDatetime NormalizationBoolean Parsing

Output

Formatted WorkbooksFormatted CSV FilesIssues ReportsPreview Mode

Quality

unittestTemporary File TestsConfig-Driven Behaviour

Key Highlights

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.

View Code