What is the row limit in Excel?

A single Excel worksheet holds at most 1,048,576 rows and 16,384 columns. That cap is fixed because it is the size of the grid. When a CSV or text file exceeds the grid, Excel warns that some data was not loaded.

Why does Excel cut off my rows at 1,048,576?

The 1,048,576-row ceiling is the limit of an Excel worksheet. Excel for PC can load a larger data set through Power Query for analysis in a PivotTable. For a quick check, the viewer above displays every parsed row from a CSV or TSV file up to 50 MB.

How do I open a file that's bigger than Excel's limit?

The viewer above accepts CSV and TSV files up to 50 MB. It parses the file contents in your browser and shows every parsed row with sorting and filtering. Your file contents are not uploaded to Loam.

Why is my Excel file so large?

A high row count is one cause of a large Excel workbook. Formatting, hidden sheets, images, and embedded objects can also increase its size. If the data is in a CSV or TSV file up to 50 MB, use the viewer above to inspect every parsed row without loading it into a worksheet.

Does Loam replace Excel?

No. Excel remains useful for formulas and spreadsheet work. Loam connects your business data to your AI so it can answer from real numbers. For a quick local check, the viewer above opens CSV and TSV files up to 50 MB.

Hit Excel's row limit? View every parsed row.

Excel worksheets stop at 1,048,576 rows. Drop a CSV or TSV file up to 50 MB here to sort, filter, and inspect every parsed row. Your file contents are parsed in your browser and are not uploaded to Loam.

Drop a CSV or TSV file up to 50 MB to see every row

Your file contents are parsed in your browser and are not uploaded to Loam.

See every rowPast Excel's 1,048,576-row capSort and filterDetected column types

Excel's row limit is 1,048,576, and it is fixed

A single Excel worksheet holds at most 1,048,576 rows (and 16,384 columns). That number is the size of the grid itself, not a setting you can raise. When a CSV or text file exceeds the grid, Excel warns that some data was not loaded. The viewer above accepts CSV and TSV files up to 50 MB and displays every parsed row without loading it into a worksheet.

Inspect the rows before choosing your next step

Sort and filter every parsed row in the browser viewer. To keep this data available to your AI, start with Loam and upload a supported file in the product. The browser viewer does not transfer this file automatically. If you are working with a CSV file, you can also use the dedicated viewer.

Loam complements your spreadsheet work

Keep using Excel for formulas and worksheet tasks. Use the browser viewer when you want to inspect a CSV or TSV without loading it into a worksheet. Start with Loam when you want to keep your business data connected to your AI.

Frequently asked questions

Ready to ground your AI in your data?

Start with Loam to upload a supported file and connect your AI to real business data. The file in this browser viewer is not transferred automatically.

Start with Loam Chat with a CSV or TSV