๐Ÿ› ๏ธ 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

Basic Operations Open
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

Configuration Open
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

Data Cleaning Open
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

Data Cleaning ๐Ÿšง Coming Soon
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

Data Consolidation Open
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

Data Extraction Open
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

Data Extraction Open
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

Data Processing Open
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

Text Processing Open
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

Text Processing Open
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

Text Processing Open
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

Text Processing Open
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

Settings