Split cell values into multiple columns by comma, hyphen, or space

Spreadsheet exports frequently bundle multiple distinct data attributes into a single text cell: - Dimensions stored as "30x20x15" (Length x Width x Height) - Geographic coordinates stored as "-1.286389, 36.817223" (Latitude, Longitude) - Product codes stored as "DEPT-CAT-ITEM-2026" - Dates and times bundled together as "2026-03-15 14:30:00" To calculate shipping volumes, map geographic coordinates, or filter by product sub-category, these bundled values must be split into dedicated columns. While Excel provides a "Text to Columns" wizard, it can overwrite adjacent columns if there is insufficient empty space and struggles with irregular delimiter counts. This tool splits any selected column by your chosen delimiter (comma, hyphen, space, slash, pipe, or custom text character). It dynamically creates new columns with custom names (e.g. length, width, height), trims whitespace from the split values, and handles rows with varying delimiter counts without shifting unrelated columns. All operations execute client-side in your browser via local Web Workers. Your data remains strictly private on your device. From a data normalization standpoint, splitting composite cell values into dedicated atomic columns is essential for relational database compliance (First Normal Form) and analytical reporting. When dimensions are stored as "30x20x15" or coordinates as "Lat, Long", splitting them enables mathematical calculations and geographic mapping. DataFix normalizes column counts across all rows, inserts new columns without overwriting adjacent data, and trims whitespace from split values. From an enterprise security perspective, proprietary inventory specifications, geographical coordinates, and customer data must be protected. Transmitting spreadsheets to external cloud converters introduces critical privacy vulnerabilities. DataFix processes all column splitting locally in your browser memory via Web Workers, ensuring complete data security, zero latency, and continuous offline availability. From a database normalization and dimensional modeling perspective, atomic data storage is a fundamental design rule. When attributes like dimensions ("30x20x15"), geo-coordinates, or compound SKU codes are bundled in a single cell, analytical tools cannot perform range filters (such as finding all items where length exceeds 25cm) or compute spatial distances. Splitting composite fields into dedicated columns unlocks granular SQL queries, enables automated pivot aggregations, and establishes clean relational database structures. Additionally, our parser supports regex-based delimiters, allowing users to split columns on varying patterns such as multiple spaces, mixed slashes and dashes, or complex alphanumeric boundary markers with complete mathematical precision.

Can I split by multiple characters like " // " or " - "?

Yes! You can enter any custom string as the delimiter.

What happens if a row has fewer parts than the rest?

Empty cells are inserted in the trailing columns for that row, keeping all columns aligned.

Can I choose names for the new columns?

Yes. You can assign custom names to each new column before downloading.

Is my data private?

Completely. All processing occurs locally within your browser sandbox via Web Workers.

Clean

Merge Columns

Concatenate multiple columns into a single unified column using custom delimiters (space, comma, hyphen, slash).

Open Tool →

Clean

Split Full Name into First and Last

Separate full name columns into dedicated first_name and last_name columns in CSV and Excel spreadsheets.

Open Tool →

Clean

Trim Whitespace

Clean up accidental leading, trailing, and duplicate spaces across all columns in your spreadsheet.

Open Tool →