Excel worksheets are limited to 1,048,576 rows and 16,384 columns, and a single cell can hold up to 32,767 characters. CSV has no single universal row or file-size limit; its practical limits depend on the program and system handling it. When Excel opens a CSV, however, the data must fit Excel’s worksheet limits.
What “Excel and CSV limits” means
Excel and CSV are not two versions of the same thing. Excel is an application that works with workbook files, such as .xlsx, while CSV is a plain-text format for storing rows of separated values. A CSV file can contain far more data than one Excel sheet can display, but opening it in Excel does not remove Excel’s boundaries.
It helps to separate three questions: how much data the format can represent, how much the application can handle, and how much fits in a worksheet. CSV itself does not prescribe a maximum number of records or a maximum file size. Excel does specify worksheet dimensions and cell limits. Your computer’s memory, the file’s structure, and the software used to import it also affect what works in practice.
Excel worksheet row and column limits
In current Excel for Microsoft 365 on Windows, one worksheet can contain at most 1,048,576 rows and 16,384 columns. The last column is XFD. These limits apply to each sheet in a workbook, not to the entire workbook as a single combined table. A workbook can have multiple sheets, although available memory and system resources constrain how much it can contain overall.
For example, a table with a header in row 1 has room for 1,048,575 data rows on that sheet. A file with 1,100,000 records cannot all appear on one worksheet. Splitting it across sheets might make it viewable, but can make analysis and maintenance awkward; importing it into a database or another tool designed for larger datasets may be more suitable.
Excel’s row and column boundaries also apply when you open a CSV directly. If the file has more records or fields than the worksheet can accommodate, Excel cannot display the excess as ordinary worksheet cells. Do not assume that a file appearing to open successfully means every row was loaded. Check the record count against the source, particularly when working with large exports.
Cell, text, and number limits
A cell can contain up to 32,767 characters. This matters when a CSV includes long descriptions, notes, web content, or other text fields. A CSV may store a longer field, but Excel cannot place more than its cell limit into a worksheet cell. Excel also has a limit of 253 line feeds in a cell, which can affect pasted or imported text containing many line breaks.
Numbers have a different constraint: Excel retains 15 significant digits of numeric precision. A long identifier such as 123456789012345678 may therefore be changed if Excel treats it as a number. Account codes, tracking numbers, and other identifiers usually need to remain text, even if they contain only digits. Formatting a cell as Text after a number has already been converted will not restore digits that were lost.
When importing a CSV, use the import preview or Power Query to assign identifier columns the Text data type before loading. In Excel for Microsoft 365 on Windows, start with Data > From Text/CSV and choose Transform Data if you need to inspect or change column types. The available import experience can vary by platform and update; on Mac, check the Data tab for the text or CSV import options available in your Excel version.
Does CSV have a maximum size?
CSV does not have a universal maximum file size or a universal maximum number of rows. It is a text convention: records are represented as lines of values separated by a delimiter, commonly a comma. A field containing a comma, quotation mark, or line break can be enclosed in quotation marks, with quotation marks inside the field represented by doubled quotation marks. As a result, one logical record can span multiple physical lines.
That flexibility does not mean every program can handle an arbitrarily large CSV. An editor may be unable to load a huge file into memory; an import service may impose its own upload cap; a database may set limits on field sizes; and a file system or storage device may limit file size. These are tool- and environment-specific constraints, not one shared CSV standard limit.
CSV also does not reliably carry spreadsheet features such as multiple worksheets, cell formatting, formulas as formulas, charts, or data validation. It stores text values in a tabular arrangement. A formula-like string may be interpreted as a formula by spreadsheet software when opened, but CSV itself does not define a calculation engine or preserve a workbook’s formula behavior.
What happens when Excel opens a CSV
Opening a CSV in Excel is convenient, but Excel has to interpret plain text as spreadsheet data. It may infer whether each value is a date, number, or text. That can be useful for ordinary reports, but it can also change information unexpectedly: a code with leading zeroes may lose them, a date-like value may be reformatted, or a long digit string may be rounded to Excel’s numeric precision.
Regional settings can affect which character Excel expects as the separator. Although the extension is .csv, files may use semicolons or another delimiter in some locales or exports. If values appear in one column instead of several, the delimiter may not match what Excel inferred. Use Data > From Text/CSV to review the delimiter and preview the columns before loading, rather than relying on a double-click to interpret every file correctly.
When saving a workbook as CSV, Excel saves only the active worksheet to the text file. Formatting, other sheets, charts, and many workbook features are not included. Excel may show a warning about features that cannot be saved in CSV; take it seriously and keep an .xlsx copy if you need to preserve the full workbook. CSV is appropriate when a receiving system needs plain tabular data, not as a complete backup of an Excel workbook.
Working with CSV files larger than a sheet
If a CSV exceeds a worksheet’s row limit, do not open it and assume Excel will provide a complete view. First establish the source’s record count and decide what task you need to perform. A dataset can be too large to display on one sheet yet still be usable in a workflow that filters, aggregates, or loads data into a model without putting every row on a worksheet.
For larger files, Excel’s Power Query can be useful for importing and transforming data, and the Excel Data Model can hold more data than a worksheet grid in suitable cases. Neither is an unlimited storage system: actual capacity depends on available memory, data shape, compression, and the destination. If the final step loads the complete result to a worksheet, the worksheet row limit still applies. For routine storage and querying of very large tables, a database or dedicated data-analysis tool may be a better fit.
- Count rows and inspect the file size before choosing an import method.
- Preserve sensitive columns as text during import, especially IDs, postal codes, and long digit strings.
- For an analysis that needs only totals or filtered results, transform or aggregate the data before loading it onto a sheet.
- Keep the original CSV unchanged so you can compare results or repeat the import if settings were wrong.
Choosing CSV or an Excel workbook
Choose CSV when the goal is to exchange a simple table with another system, create a lightweight export, or inspect data using tools that accept delimited text. It is readable in a basic text editor and is not tied to a particular spreadsheet brand. Be explicit about the delimiter and character encoding when sharing it, especially if the file contains accented characters or symbols.
Choose .xlsx when you need multiple worksheets, formatting, formulas, charts, tables, or other Excel workbook features. An .xlsx file still has the same worksheet row and column limits, but it can preserve workbook structure that CSV cannot. If a recipient asks for CSV, provide that file for compatibility and retain the workbook separately when its additional features matter.
Common limit-related problems
A file that appears truncated may have hit Excel’s row boundary, but it could also have been cut off during export or import. Compare the number of source records with the number loaded, and check for an import warning. If the worksheet has the right row count but the columns are wrong, investigate the delimiter, quotation marks, and embedded line breaks; a line break inside a quoted CSV field is not necessarily a new record.
Another common surprise is a number or date changing during import. That is usually a data-type interpretation issue, not a CSV row limit. Importing through the preview and assigning columns deliberately can prevent many such changes. For sensitive or business-critical data, validate representative records at the beginning, middle, and end of the file, and reconcile totals or counts with the source system.
Finally, file size alone does not predict whether Excel can handle a dataset. A modest file with wide rows, long text, or complicated transformations can be demanding, while a larger file of repetitive values may compress well in a model. The relevant limits are the worksheet dimensions, per-cell constraints, Excel’s available resources, and the needs of the task.
Frequently Asked Questions
How many rows can Excel have?
One Excel worksheet can have 1,048,576 rows. If row 1 contains a header, that leaves 1,048,575 rows for data on that sheet.
How many columns can Excel have?
A worksheet supports 16,384 columns, ending at column XFD. This is a per-sheet limit.
Is there a maximum number of rows in a CSV?
There is no universal CSV row-count limit. The program importing the file may impose a limit, and Excel can display only up to its worksheet maximum on one sheet.
Can a CSV file be larger than Excel can open?
Yes. A CSV may exceed Excel’s worksheet capacity or practical memory limits. A data-import workflow, database, or other large-data tool may be needed, depending on the task and the file.
How many characters fit in an Excel cell?
A cell can contain up to 32,767 characters. A longer CSV field cannot be fully represented in one Excel cell.
Does saving as CSV keep all my Excel sheets?
No. Excel saves the active worksheet as CSV. Use .xlsx to retain multiple sheets, formatting, formulas, and other workbook features.
Related
- Excel Conditional Formatting With Dates: A Practical Guide
- Excel Conditional Formatting for Date Ranges Explained
- Excel Conditional Formatting for Upcoming Dates
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel RANK vs RANK.EQ: Differences, Ties, and ExamplesRANK and RANK.EQ return the same result in current Excel: each gives a number’s position in a list,…
- Fixing Broken Links in Excel: Find and Repair ThemTo fix broken links in Excel, first identify whether the problem is an external-workbook link in a formula…
- Can You Add Search to an Excel Slicer? How It WorksYes. In Excel for Microsoft 365 on Windows, click the magnifying-glass icon in a slicer’s header, type part…
- Outlook View Changed? Restore Your LayoutYes—Outlook’s view can change after you switch between new and classic Outlook, choose a different message-list view, adjust…
- How to Build a Schedule in Excel: A Practical GuideTo build a schedule in Excel, choose a time period, put dates or time slots in row and…
- Google Sheets ARRAYFORMULA with VLOOKUP: How It WorksIn Google Sheets, combine ARRAYFORMULA with VLOOKUP to look up many values at once and return the results…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.