Excel Cell Limit: Character, Row and Column Limits Explained

An Excel cell can hold up to 32,767 characters, and a worksheet can hold 1,048,576 rows by 16,384 columns. Those limits are generous for everyday work, but large data files can still hit them. Long product descriptions, merged text fields and big exports are the usual culprits.

When that happens, Excel doesn’t always warn you clearly. Text can be cut short and rows can go missing, and saving the file makes the loss permanent. Knowing the limits, and how to check your data against them, keeps that from happening.

Excel Cell and Worksheet Limits at a Glance

The table below lists the limits that matter most when you work with large or text-heavy files. They apply to current versions of Excel using the .xlsx format.

Two limits are easy to overlook. A cell can contain at most 253 line feeds, which matters for long text with many line breaks. Numbers keep only 15 digits of precision, so longer numeric codes lose their final digits unless you store them as text.

The older .xls format, used by Excel 97–2003, has much smaller limits of 65,536 rows and 256 columns. If you’re working with a file saved in that format, save it as .xlsx before adding large amounts of data.

What Happens When a Cell Exceeds the Character Limit

A cell simply can’t hold more than 32,767 characters, so any extra text is lost or rejected. If you open or paste a longer value, Excel can’t keep all of it, and other tools may refuse to create an Excel file at all. Some data tools stop an Excel export entirely when they find a value over the limit.

In practice, the long values are usually predictable. Product descriptions written in HTML can grow very long, especially with embedded tables or styling. Fields that combine several values, such as merged notes or structured data stored as text, can also cross the limit.

The real risk is the save. If Excel cut a value short when opening a file, saving that file replaces the original with the shortened version. Check long text fields before saving any file you plan to import elsewhere.

Find cells close to the limit

The LEN function counts the characters in a cell, which makes long values easy to spot. Add a helper column with =LEN(A2), fill it down, and sort or filter it to show the largest values first.

For a visual check, use conditional formatting. Select the column, create a rule that uses a formula such as =LEN(A2)>30000, and choose a highlight color. Any cell approaching the limit then stands out as you scroll.

Work around the character limit

The right workaround depends on whether you need the full text inside Excel. These options cover the common cases:

• Keep the full value outside Excel. A CSV file has no per-cell limit of its own, so keep the original CSV as the source of the complete text. Edit very long fields in a text editor or the system they came from, rather than in Excel.
• Split the text across columns. Use =MID(A2,1,30000) in one column and =MID(A2,30001,30000) in the next to break a long value into parts. You can join them later with the & operator.
• Shorten the content. For product descriptions, removing inline styling or repeated markup often cuts the length dramatically without changing what shoppers see.

Some common suggestions don’t help. Wrap Text and merging cells change how text looks, but neither raises the amount a cell can hold. Splitting data across more sheets helps with row counts, not with the character limit of a single cell.

What Happens When You Exceed the Row Limit

A worksheet stops at 1,048,576 rows, so Excel can’t show the rest of a larger file. If you open a CSV with more rows than that, the data beyond the limit won’t appear in the sheet. Saving the file afterward drops those rows for good.

The simplest fix is to split large files into smaller ones before opening them in Excel, for example by date range or product category. Each part then fits comfortably within a worksheet and is easier to review.

When you need to analyze all the data at once, use Data > From Text/CSV to bring the file in through Power Query. You can filter out rows or columns you don’t need before loading, so the result fits on a sheet. Very large datasets can also be loaded into the Excel Data Model, which is limited by available memory rather than by worksheet rows.

Check Your Store’s Own Field Limits Too

If you prepare product data in Excel for an online store, the store’s limits are often far smaller than Excel’s. A value that fits easily in a cell can still be too long for the field it’s going into, so it helps to check both before importing.

The same LEN helper column works here. For example, filter an SEO description column for values where =LEN(A2) is over 320 to find descriptions that need trimming before import. File limits such as 15 MB or 5,000 rows are another reason to split large catalogs into several smaller import files.

Conclusion

The Excel cell limit of 32,767 characters, along with the worksheet limit of 1,048,576 rows, rarely matters until a large file quietly loses data. Checking text length with LEN, splitting oversized files and keeping long values in their original source protects your data from that silent truncation. We hope this guide helps you work confidently within Excel’s limits. If you prepare product data in spreadsheets for store imports, you can explore Bulkflow.