Limit CSV cell length: find and shorten cells over a character limit before an import
In short: Upload a list, tick the columns, set the limit and see the longest cell in each column; long cells are cut at a word with an ending you choose. Limit: Shortening removes text for good; keep the original file.
Upload a CSV or .xlsx file, or paste it with a header row. The tool shows the longest cell in every column. Tick the columns to shorten and set the most characters a cell may hold, such as 255. Longer cells are cut at the limit, or at the last space before it, with an ending such as three dots counted inside the limit.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Three example rows with a 60 character limit shorten 2 notes, cut at a word and ending in three dots; the 97 character note was the longest.
- Cells shortened
- 2
- Rows changed
- 2
- Limit
- 60
What this means for you
Shorter cells do not show which addresses exist; a check does.
- Longest cell per column
- Your character limit
- Cut at a word
- Ending counted inside
- Cell length
- CSV
- Import
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Cells fit? Check the addresses before you import.
- Download the file, or use the check button under the result, which carries its addresses across.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I truncate long cells in a CSV?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Look at the longest cell in each column and tick the columns to shorten.
- Set the most characters a cell may hold, the ending to add and whether to cut at a word.
- Check the file and download the shortened CSV.
Example
- You enter
- Three rows with a Notes column (the longest cell 97 characters and one short note), a limit of 60 characters, cut at a word, with three dots at the end.
- You get
- 2 cells shortened in 2 rows, each to 60 characters or fewer and ending in three dots; the short note is untouched. The longest cell before was 97 characters.
- Limits
- Runs in your browser; nothing is uploaded. Shortening removes text for good, and it counts characters where some tools count bytes.
Why do imports reject long cells?
Many CRMs and email platforms give a single-line text field a fixed length, often 255 characters, and either reject the whole row or silently cut the text when a value is longer. A notes column pasted from a scraped profile or a form answer is the usual cause.
Check the limit in the tool you are importing into: a notes or description field often allows far more than a single-line text field, and a better fix may be to map the column to it.
How is a cell shortened?
A cell at or under the limit is not touched. A longer one is cut to the limit, less the length of the ending you chose, so a limit of 60 with three dots keeps 57 characters and the dots. With cut at a space on, the cut moves back to the last space when that space falls in the second half of the kept text, so words are not split in the middle. Trailing spaces, commas and semicolons are removed before the ending is added.
Characters are counted as a person sees them: an emoji or a letter with a mark counts as one.
What else can get in the way of an import?
Hidden characters, stray line breaks and broken rows cause rejected imports too: try the whitespace and hidden character cleaner and the broken row fixer. To match a platform's required columns, use the CSV import formatter.
Who uses this tool, and for what?
- Sales operations
- Trim a scraped notes column to fit a CRM text field before an import.
- Marketers
- Shorten a form answer column that an email platform rejects as too long.
- Agencies
- Apply one field limit to the lead files of several clients before loading them.
What can’t this tool tell you?
- Shortening removes text for good; keep the original file.
- It counts characters, while some tools count bytes, which can be more for accents and emoji.
- It does not know the limit of your importing tool.
- Only the first sheet of a workbook is read.
Common questions
- What limit should I use?
- The one in your importing tool's help page. 255 characters is common for single-line text fields.
- Does it cut words in half?
- Not when cut at a space is on and a space falls in the second half of the kept text. Otherwise it cuts at the limit.
- Is the ending counted in the limit?
- Yes. With a limit of 60 and three dots, a shortened cell is at most 60 characters including the dots.
- Can I see which columns have long cells?
- Yes. Each column is listed with the length of its longest cell before you choose anything.
- Does it change cells that fit?
- No. Only cells over the limit, in the columns you tick, are shortened.
- Is my file uploaded?
- No. It is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.