Csv Tools

Browse all available csv tools.

Available tools

A1 Range Cell Count Expander Expand an ordered rectangular A1 range in row-major order into relative addresses, rejecting reversed corners and limiting materialization to 5,000 cells.
Accounting Dash-for-Zero Normalizer Replace cells consisting of a trimmed ASCII accounting dash with the exact string 0, preserving all other cell text including numeric signs and Unicode dashes.
BOM Remover First Bytes Remove an initial UTF-8 EF BB BF signature from byte values and preserve every remaining byte, including interior signatures and other encoding BOMs.
BOM Trim From First Cell Remove exactly one initial U+FEFF from the first decoded cell only, preserving interior marks and all subsequent cells.
Boolean Token Normalizer Normalize trimmed case-insensitive yes/no, true/false, and 1/0 column cells into booleans, returning a cell-specific error for unknown tokens.
Cell Coordinate A1 Parser Parse one A1 address with optional absolute row and column markers, returning one-based safe indices and a canonical uppercase address; sheet names and ranges are excluded.
Cell Length Min/Max Per Column Measure minimum and maximum Unicode code-point lengths of decoded data cells per column, including empty strings and excluding an explicit header; zero observations return count zero.
Checksum Total Row Appender Append one CSV total row for explicitly selected dot-decimal columns, ignoring blanks and placing a supplied label in a separate column; all totals remain exact strings.
Chunk Size Rows-Per-File Split Calculator Calculate file count and final-file data rows from a total data-row count and positive per-file capacity using exact integer division; header rows are excluded from both counts.
Column Drop By Index Drop selected zero-based columns from a rectangular CSV, preserving all remaining cells and rejecting removal of every column.
Column Index to Letter (A1 Style) Convert a one-based safe integer column index to ASCII A1 column letters without imposing Excel worksheet width limits.
Column Letter to Index (A=1) Convert ASCII A1 column letters to a one-based safe integer using bijective base 26; generalized columns are accepted beyond Excel worksheet limits.
Column Select By Indices Select and reorder zero-based columns from a rectangular CSV, allowing repeated selections while requiring at least one output column.
Column Type Inference From Sample Infer empty, integer, decimal, or string from a column sample using ASCII decimal token syntax; blanks are ignored and leading-zero identifiers remain strings.
Comment Line #-Prefix Skipper Remove physical lines starting with # outside quoted CSV fields, preserving such lines inside multiline fields; # comments are an explicit non-RFC extension.
Constant Column Detector Identify columns with one exact decoded value across all data records, excluding an explicit header; empty strings may be constant but zero observations are not evidence.
Control Character Finder In Fields Locate C0 and C1 control characters, including DEL, in cell strings and report cell index, UTF-16 offset, and code point; tabs and line breaks are included.
CRLF Inside Quotes Preserver Normalize only CSV record endings to LF or CRLF while preserving quoted cell bytes and whether the document had a terminal record ending.
CSV Pivot Table Tool Aggregate CSV rows into a deterministic grouped pivot table.
CSV Row Counter Count CSV records including blank records and quoted multiline fields, with an explicit header flag; physical lines are not records.
Currency Symbol Strip to Number Remove at most one leading or trailing Unicode currency symbol and parse an exact decimal using explicit decimal and grouping separators; embedded symbols are rejected.
Date Format Detection From Column Sample List Gregorian ISO YYYY-MM-DD, MM/DD/YYYY, and DD/MM/YYYY formats compatible with every nonblank sampled cell; ambiguous day/month order is retained.
Date+Number Autocolumn Classifier Strict observed ISO date/canonical decimal column classifier; no locale guesses, spreadsheet coercion or identifier inference.
Decimal Separator Dot vs Comma Detector List decimal separator profiles compatible with all nonblank cells, allowing opposite-character thousands grouping; ambiguous values such as 1,234 keep both interpretations.
Delimiter Sniffer (Comma/Semicolon/Tab) Compare comma, semicolon, and tab dialects by the fraction of records having their modal field count; ties and one-column samples remain ambiguous.
Double-Quote All Fields Writer Style Rewrite every decoded CSV field with double quotes and doubled interior quotes, retaining empty records and using LF record endings without a terminal newline.
Doubled-Quote Escape Validator Validate one double-quoted CSV field token, accepting interior quotes only in doubled pairs; this does not validate an entire CSV document.
Drop Empty Columns Detector Identify zero-based columns whose every data cell is exactly empty, excluding an explicit header; no columns are inferred empty when there are no data records.
Duplicate Header Detector Find exact case-sensitive duplicate header names with all zero-based positions, without trimming or changing header text.
Duplicate Rows Extractor Extract every CSV data record whose exact decoded row occurs more than once, retaining all members of duplicate groups in original order and preserving an optional header.
Email Format Quick Check Per Cell Check each cell against the WHATWG HTML single-email ASCII syntax after trimming boundaries; this checks format rather than mailbox existence or all RFC email forms.
Emoji/Non-ASCII Headers Flagger Find headers containing any non-ASCII UTF-16 unit, including accented characters and emoji, without claiming to identify emoji or reject Unicode names.
European Semicolon→Comma Delimiter Swap Convert semicolon-delimited CSV with double-quote escaping into comma-delimited CSV, preserving decoded cell values and quoted embedded delimiters.
Excel 1,048,576-Row Limit Check Check a total row count, including headers, against the 1,048,576-row limit of modern Excel worksheets and report remaining capacity or excess rows.
Excel 32,767-Char Cell Limit Check Compare supplied nonnegative cell character counts with Excel’s 32,767-character limit and report zero-based offending indices; the caller selects the character-count convention.
Excel Serial Date to ISO Converter Convert integer Excel dates in an explicit 1900 or 1904 system to Gregorian ISO dates; reject the fictitious 1900-system day 60 and fractional time values.
Excel XFD 16,384-Column Limit Check Check a worksheet column count against Excel’s XFD boundary of 16,384 columns, returning remaining capacity and a generalized A1 name for the last column.
Field Whitespace Trimmer Trim ECMAScript boundary whitespace from every decoded CSV cell and re-encode with minimal quoting and LF record endings; interior whitespace is preserved.
Field-With-Linebreaks Flagger Find zero-based cell indices containing CR or LF characters, treating both individual line endings and CRLF as line-break presence.
Filepath Basename Extract Per Cell Extract the last literal path component using explicit POSIX or Windows separators, ignoring trailing separators and returning empty for roots; no filesystem access or path resolution occurs.
Fill Missing Cells Default Value Pad short CSV records to an explicit width with a default string, preserving present empty fields and rejecting longer records; output materialization is bounded.
Filter Rows Column Equals Value Keep CSV data records whose selected zero-based column exactly equals a supplied decoded string, preserving an explicit header and original record order.
Filter Rows Numeric > Threshold Keep CSV data rows whose selected column is strictly greater than an exact dot-decimal threshold; malformed numeric cells fail instead of being rounded or ignored.
First-N Distinct Values Per Column Sample the first N distinct decoded data values per column in encounter order, counting empty strings as values and reporting the full distinct count.
Fixed-Width to CSV Offset-Spec Parser Slice physical text lines at strictly increasing zero-based UTF-16 offsets beginning at zero, keeping padding and taking the last field to line end; emit comma CSV with bounded materialization.
Foreign-Key Pair Match Rate Measure the fraction of child key occurrences present in an exact parent-key set, counting repeated children individually and treating empty strings literally; no children returns hasChildren false and rate zero.
Header Casing Mixed-Styles Check Classify ASCII header spelling as lowercase, uppercase, camel, Pascal, snake, kebab, title, or unknown, reporting distinct styles and whether more than one recognized style occurs.
Header Dedupe Suffix Counter Make exact duplicate headers unique with _2, _3, and later suffixes, reserving all original names so generated names never steal a later header.
Header Offset Record Index Map a zero-based data record index to a zero-based CSV record index by adding one when a header exists; record indices do not count embedded physical lines.
Header Row Detection Heuristic Flag a possible header when its labels are unique and nonempty and at least half of columns have text labels above consistently numeric values; this is an explicit heuristic.
High-Cardinality Column Flagger Flag columns whose distinct-to-observed ratio exceeds an explicit threshold, counting exact nonempty data cells and excluding an explicit header; zero observations never flag.
ID Column Uniqueness Check Check exact string ID uniqueness in a supplied column, treating empty strings and leading zeros literally; report indices of occurrences after each first occurrence.
ISO Date to Excel Serial Export Convert a valid Gregorian YYYY-MM-DD date to an integer Excel serial in an explicit 1900 or 1904 system, including Excel’s inserted 1900 leap-bug offset.
Latin-1 Export Compatibility Warning Report cells containing characters outside ISO-8859-1’s U+0000–U+00FF repertoire; Windows-1252 substitutions such as the euro sign are not accepted as Latin-1.
Latin-1 Mojibake Sequence Detector Flag a narrow mojibake heuristic: Latin-1 characters corresponding to UTF-8 C2/C3 lead bytes followed by an 80–BF continuation byte; this is evidence rather than encoding identification.
Leading-Zero ZIP Code Loss Warner Flag original five-digit or ZIP+4-shaped cells beginning with zero as susceptible to numeric-import loss; this is a spelling warning rather than postal-code assignment validation.
Line Count vs Record Count Reconciler Compare physical CSV line count with logical record count, treating CRLF as one break and a terminal ending as no extra line; embedded quoted breaks explain the excess physical lines.
Low-Cardinality Category Lister List first-encounter distinct nonempty values for data columns whose observed category count is at most an explicit maximum, excluding an explicit header.
Mean Aggregate Per Numeric Column Compute exact means for explicit dot-decimal CSV columns as reduced numerator/denominator strings, ignoring blanks; count zero and hasValues false identify absent means.
Minimal Quoting Only-When-Needed Style Rewrite CSV using quotes only for a delimiter, double quote, or line break, additionally quoting a one-cell empty record to preserve it; use LF without a terminal newline.
Mixed Header Case Conflict Check Find header groups that collide after locale-independent lowercase conversion; preserve original spelling and report zero-based indices.
Mixed-Type Column Detector Samples Report observed nonblank ASCII token classes per CSV data column and whether more than one occurs; integer and decimal spellings are distinct classes even when inference can promote both to decimal.
Multiline Quoted Cell Line Counter Find decoded CSV cells containing CR or LF and report their one-based line counts, counting CRLF as one break; positions are zero-based record and column indices.
Negative Parentheses Accounting Parser Convert one parenthesized unsigned accounting decimal with optional boundary currency symbol into an exact negative decimal, using explicit decimal and grouping separators.
Non-Empty Count Per Column Count data cells that are not exactly empty per CSV column, excluding an explicit header; whitespace-only strings count as present.
Non-Printable Char Stripper Cells Remove C0/C1 control characters and DEL from cell strings, optionally preserving tab, LF, and CR; other Unicode format characters are left intact.
Null Token Normalizer (N/A, NULL, -) Explicit case-insensitive trimmed null-token policy N/A,NULL,-,empty; preserves other cells byte-for-byte, may erase literal tokens by policy.
Numeric Range Min/Max Per Column Find exact dot-decimal minima and maxima per data column, skipping and counting nonnumeric cells; columns with no numeric values return hasValues false and empty bounds.
Numeric Sort EU Decimal-Aware Stably sort rectangular CSV rows by exact numbers using comma decimals and optional dot groups of three, preserving original cell spelling and an explicit header.
Orphan Rows Missing Parent Key Finder Extract CSV data records whose selected exact string key is absent from a supplied parent-key set, preserving an explicit header and reporting original zero-based record indices.
Percent String to Numeric Value Convert a decimal cell ending in percent to an exact decimal fraction, using a dot decimal separator and no grouping; one percent equals one hundredth.
Phone Digits Normalizer E.164-Lite Strip ASCII phone punctuation and prepend an explicit country code when + is absent, requiring a nonzero-leading maximum of 15 digits; no allocation or national trunk-prefix validation is performed.
Quote Char Variant Detector Detect single- or double-quote conventions in isolated field-token samples, requiring complete paired delimiters and doubled interior quotes; single quotes are a dialect hint rather than RFC CSV.
Quoted Multiline Safe Splitter Split CSV into raw record fragments without outer record endings, preserving quote spelling, embedded line endings, blank records, and escaped quote pairs.
Ragged Rows Wrong-Field-Count Finder Report CSV records whose decoded field count differs from an explicit expected width, including header and blank records; indices are zero-based records, not lines.
Reserved Word Column Name Flagger Exact case-insensitive caller SQL-dialect reserved-token flags; quoting rules and full SQL validity omitted.
RFC 4180 Quoted Field Parser Check Check RFC 4180 field quoting with explicit Unicode and CR/LF extensions; blank records are retained, and field-width consistency is checked separately.
Row Hash Digest Dedupe Key Fingerprint one decoded row using legacy MD5 over UTF-8 JSON array text, preserving cell boundaries; confirm row equality before deduplication because MD5 is not collision resistant.
Row Head/Tail Slice N Take the first or last N CSV data records in their original order, retaining an explicitly declared header and treating quoted multiline cells as one record.
RTL Override U+202E Hidden Char Detector Locate every RIGHT-TO-LEFT OVERRIDE U+202E in cell strings with zero-based cell indices and UTF-16 offsets, without changing text or inferring visual order.
Scientific-Notation Gene-Name Date Guard Flag legacy MARCH#, MARC1/2, SEPT#, or DEC1 symbols and ASCII scientific-notation-shaped cells as spreadsheet import risks; the rule is a heuristic, not a gene registry lookup.
Sheet Name Invalid Chars Validator Check Excel sheet-name spelling for empty text, more than 31 UTF-16 units, forbidden characters, boundary apostrophes, and reserved History; existing workbook name collisions are outside this check.
Smart Quotes Typographic Replacer Replace U+2018/U+2019 with ASCII apostrophes and U+201C/U+201D with ASCII double quotes inside cell strings; CSV escaping belongs to the subsequent writer.
Sort Rows Column Lexicographic Stably sort CSV data records by a selected column using deterministic UTF-16 code-unit ordering, with an explicit direction and header flag.
Space-In-Column-Name Flagger Find header indices containing ASCII space U+0020 without changing the names; tabs and other Unicode whitespace are separate characters.
Sum Aggregate Per Numeric Column Sum explicit CSV numeric columns with exact decimal arithmetic, ignoring blank cells and rejecting other nonnumeric values; report observation counts and preserve an explicit header interpretation.
Thousands Separator Detector List comma, dot, or ASCII-space grouping profiles observed in a numeric column sample, requiring groups of three digits; report when the same sample also permits a decimal-only interpretation.
Trailing Comma Extra Field Flagger Find zero-based CSV record indices ending in an unquoted delimiter, indicating an empty final field; delimiters inside quoted cells are excluded.
TSV Tab-to-Comma Converter Convert tab-delimited records using CSV double-quote rules into comma CSV with LF record endings; unquoted multiline or arbitrary TSV escape conventions are outside this profile.
Two-Digit Year Century Window Rule Lookup Resolve a two-digit year into a caller-specified inclusive 100-year window, returning the unique year with matching final digits; no operating-system date setting is assumed.
Unbalanced Quote Per Row Detector Double-quote parity diagnostics over ordered physical lines, preserving multiline quoted fields; not full CSV syntax validation or proof each odd line malformed.
Unique Rows Dedupe First Occurrence Remove exact duplicate decoded CSV records after an optional header, retaining first occurrences and their original order; cell boundaries remain significant.
Unix Timestamp Column to ISO Datetime Convert integer Unix timestamp cells in explicit seconds or milliseconds to UTC ISO datetimes with millisecond precision, limited to years 0001 through 9999.
URL Domain Extract Per Cell Extract normalized hostnames from absolute HTTP or HTTPS URL cells using the URL Standard; hostnames include subdomains and are not registrable-domain guesses.
UTF-16 BOM Encoding Check Match initial UTF-16 and UTF-32 BOM byte prefixes as encoding hints, preferring the longest signature; FF FE 00 00 remains ambiguous with UTF-16 LE followed by NUL.
UTF-8 BOM Detector Detect only an initial EF BB BF byte sequence; the rest of the input is not decoded or validated as UTF-8.
UTF-8 No-BOM Export Standard Check Check a chosen export profile of well-formed RFC 3629 UTF-8 without an initial BOM, reporting UTF-8 validity separately from profile conformance; UTF-8 itself permits a BOM.
Zero-Width Char In Cells Detector Locate the explicit format-character set U+200B, U+200C, U+200D, U+2060, and U+FEFF in cells, reporting UTF-16 offsets and code points; this is not a universal glyph-width test.