๐ ๏ธ CSV Utility Workspace
Your centralized hub for CSV data manipulation tools
๐ Basic Operations
๐ Add Column
Add a new column with a specified value to all rows in your CSV file
Features
- • Add custom columns to CSV files
- • Set uniform values for all rows
- • Overwrite existing columns
- • Preview before saving
๐ Configuration
โ๏ธ Settings
Configure output filename suffixes and application preferences
Features
- • Customize output filename suffixes
- • Preview output filenames
- • Save configuration changes
- • Reset to defaults
๐ Data Cleaning
๐งน Remove Duplicates
Find and remove duplicate rows from CSV files based on selected columns
Features
- • Select columns to check for duplicates
- • Choose which duplicate to keep (first/last)
- • Preview duplicates before removal
- • View detailed duplicate statistics
- • Export cleaned data
๐ง Handle Missing Data
Fill or remove missing values in your data
Features
- • Multiple fill strategies
- • Remove rows with missing data
- • Statistical filling options
- • Missing data report
๐ Data Consolidation
๐ LinkedIn Profile Consolidator
Merge and consolidate LinkedIn profile data from LN and CRM sources
Features
- • Merge LinkedIn profiles from multiple sources
- • Normalize and deduplicate URLs
- • Handle multiple URLs per cell
- • Tag profiles by source (LN/CRM)
- • Prioritize CRM Person IDs
- • Generate consolidation statistics
๐ Data Extraction
๐๏ธ Column Mapping Tool
Extract and rename columns with reusable mapping schemas
Features
- • Create and save reusable column mapping schemas
- • Load, edit, duplicate, and delete schemas
- • Import/export schemas as JSON
- • Three export modes: mapped only, mapped+original, rename in-place
- • Search and manage schema library
- • Track schema usage statistics
- • Manual one-time mapping option
- • Real-time validation and preview
๐ Column Splitter
Split dict/JSON columns into separate columns or group message paragraphs
Features
- • Auto-detect keys from dict/JSON columns
- • Select specific keys to extract
- • Group message paragraphs into full messages
- • Auto-detect message/email paragraph patterns
- • Custom column name prefixes
- • Support for Python dict and JSON formats
- • Preview before processing
- • Keep or remove original columns
- • Save column selections as defaults
๐ Data Processing
๐ Apollo JSON Processor
Convert Apollo CSV financial data into structured JSON format
Features
- • Extract financial data from Apollo CSV files
- • Convert financial columns to JSON format
- • Preserve original data structure
- • Handle missing financial columns
- • Generate structured JSON output
- • Export with or without original columns
๐ Text Processing
๐ง Message Paragraph Splitter
Split message columns into separate paragraph columns
Features
- • Multi-column message processing
- • Flexible paragraph detection (single/double newline, custom)
- • Dynamic column creation
- • Custom naming patterns
- • Preview before processing
- • Optional preservation of original columns
๐ค Name Splitter
Split full names into first_name and last_name columns
Features
- • Select any column containing full names
- • Smart name parsing with first/last split
- • Handles single-word names gracefully
- • Keeps original column in output
- • Preview results before processing
๐ Address Splitter
Split addresses into city, state, and country columns with optional prefix
Features
- • Select column containing addresses
- • Split 'City, State, Country' format
- • Optional column prefix (e.g., 'contact_')
- • Keeps original address column
- • Preview results before processing
๐งฝ Text Cleaner
Clean and normalize text in CSV columns with granular control
Features
- • Remove invisible characters (zero-width, control chars)
- • Unicode normalization (NFC/NFD/NFKC/NFKD)
- • Smart quote and typography normalization
- • Separate hyphen, em-dash, en-dash handling
- • HTML entity decoding
- • Whitespace cleanup
- • Emoji removal
- • All options OFF by default