How to Shorten CSV Cells Over 255 Characters Before a CRM Import

To shorten CSV cells over a limit, find the cells that are too long and cut them at the limit, ideally at a word. The limit CSV cell length tool does it in your browser. Upload a CSV or .xlsx file, look at the longest cell in each column, tick the columns to shorten, set the most characters a cell may hold, such as 255, and download the result.

The file is read on your device and not uploaded.

Why 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 the better fix may be to map the column to it. See HubSpot contact import CSV format for one example.

Doing it by hand

In Excel or Google Sheets, with the text in column A:

• Find the long ones. =LEN(A2) in a helper column, then sort or filter for values over 255. =MAX(B2:B5000) gives the longest.
• Cut them. =IF(LEN(A2)>255,LEFT(A2,252)&"...",A2) keeps 252 characters and adds three dots, so the result is 255.
• Keep the result. Copy the helper column and paste as values over the original.

This cuts in the middle of a word, and every column needs its own helper. The tool does it for several columns at once.

Step 1: load the file

Upload the CSV or .xlsx, or paste the cells with the header row first. Each column is listed with the length of its longest cell before you choose anything.

Step 2: set the limit

Tick the columns to shorten, set the most characters a cell may hold, choose the ending to add and whether to cut at a word.

Step 3: check and download

Check the file and download the shortened CSV.

How a cell is 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, 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 gets imports rejected

Hidden characters, stray line breaks and broken rows cause failures too. Try the whitespace and hidden character cleaner and the broken row fixer, and read fixing broken CSV rows before import.

What this tool cannot do

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

Check the addresses before you import

Cells that fit are only half of a clean import. Upload the list on the verify page: the first 100 email checks are free with a Google sign-in, no card. Each address comes back valid, risky or invalid with a reason, and nothing is sent to anyone on the list. For larger lists, see bulk email verification and pricing.

Shorten your cells now

Open the limit CSV cell length tool.