The Salesforce long text area character limit is 131,072, with 32,768 as the default; a Text field holds 255 characters and standard Description fields 32,000. Type a length, paste the text itself, or paste the STRING_TOO_LONG error, and the tool above names the smallest field type that holds it.
How to read the result
The verdict names the smallest field type that holds your length, and the one just below it that doesn't. The rows under it show the other field types and the standard fields, such as Description, Account Name or Lead Title, your value would or wouldn't fit.
Paste the text rather than typing a length when it has line breaks or accents. Salesforce counts line breaks too, and through the API it can count bytes instead of characters, so the tool counts the way Salesforce does and tells you when the two differ.
A long text area has costs. Reports show only the start of a custom long text field, formulas can't use it, field history records that it changed but not the old and new values, and all long and rich text fields on one object share a single character budget. Pick it when the text needs it, not by default.
When text won't fit
Raise the field's length first, up to the type's maximum. If the text is longer than any field holds, keep it as a file or note and store a summary in the field. Clean values before the load too: phone numbers in E.164 stay well inside the Phone field, and plain text takes less room than pasted HTML in a rich text field.
Check Data Loader before a big load. Its Allow field truncation setting is on by default while the Bulk API is off, and it cuts too-long Text, Email, Phone and picklist values without an error, so a load can look clean and still lose the end of every long value. With the Bulk API on, the row fails instead; the Bulk API limits apply to that load as well.
An error from an API load names the field and its max length. Paste it whole and the tool reads both, counts the value without showing it, and names the field type that would hold it.
