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.

Description

Excel limits the amount of text stored in a worksheet cell.

Excel limits the amount of text stored in a worksheet cell. Checking character counts before export can expose cells that exceed that capacity, but the caller must choose how its source text is counted.^{[1, 2]}

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.

When to use Excel 32,767-Char Cell Limit Check

Use this tool to 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.

Choose the original CSV text, decoded cell strings, byte values or counts requested by this tool. Use the stated delimiter, encoding, indexing and number/date convention.

How to use Excel 32,767-Char Cell Limit Check and understand its results

Choose the original CSV text, decoded cell strings, byte values or counts requested by this tool. Use the stated delimiter, encoding, indexing and number/date convention.
Enter characterCounts using the field table and calculation rules, then run the tool.
Read fits, limit, overLimitIndices. The explanation below defines the units, signs, ordering and any flags or placeholder values.
If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.

Input field	Meaning	Value type; see rules below	Requirement
characterCounts	Character counts	list of integer; minimum: 0; maximum: 9007199254740991; minimum entries: 0; maximum entries: 10000	Required

Supply nonnegative safe-integer character counts in cell order. The tool flags positions strictly above 32,767 and returns fits true only when no count exceeds the limit. A count equal to the limit passes; an empty list also passes. The result reports zero-based indices and the fixed limit.

overLimitIndices = positions with characterCounts > 32,767

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output field	Meaning	Value type
fits	Fits	boolean
limit	Limit	integer; minimum: 0; maximum: 9007199254740991
overLimitIndices	Over limit indices	list of integer; minimum: 0

json

{
  "input": {
    "characterCounts": [
      12,
      32767,
      32768
    ]
  },
  "output": {
    "fits": false,
    "limit": 32767,
    "overLimitIndices": [
      2
    ]
  }
}

Limitations and assumptions

It receives counts rather than text and does not decide between UTF-16 units, Unicode code points or grapheme clusters. It does not truncate cells or check other import limits. Ensure the counting convention matches the intended export path.

Numeric inputs must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors. A successfully returned false flag is an evaluated outcome; its meaning is explained above.

Alternative or Complementary methods

Use 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. For a complementary task, use 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.

Further background: Excel specifications and limits.

References

Excel 32,767-Char Cell Limit Check — tool.io
Excel specifications and limits — Microsoft

Similar or alternative tools

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.
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.