Why Excel Displays Only 100,000 Rows from a Larger File in WPS Spreadsheet
Question details
The user needs to determine why an imported Excel or SQL Server file appears to contain only 100,000 rows when the source file is expected to contain more than 250,000 records.
- Product
- WPS Spreadsheet and Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user opened or imported a large dataset from Excel or SQL Server and expected more than 250,000 rows, but the worksheet shows only 100,000 rows.
- Observed behavior
- The worksheet displays only 100,000 rows even though the source file is expected to contain more than 250,000 records, indicating a possible filter, hidden rows, source truncation, or import limitation.
Before troubleshooting, confirm the actual row count of the source file in its original application or database, and note the file format and import method used.
Verify the source file contains all expected rows before troubleshooting Excel
Use this first to confirm whether the 100,000-row result originates in the source file, database query, or export rather than in the spreadsheet.
Excel worksheets support more than 250,000 rows, so a 100,000-row result usually means the source data was truncated, filtered, or limited during export. Confirming the source count avoids making unnecessary changes in the spreadsheet.
Open the original CSV, text, Excel, or SQL Server source in the program that created it and run a row count or COUNT(*) query to verify whether it contains more than 250,000 records.
In WPS Spreadsheet or Excel, select an empty cell and use the COUNTA or ROWS function over the imported range to count nonblank rows, then compare the number with the source count.
If the source file or query result already contains only 100,000 rows, return to the original application and re-export or re-run the query without row limits, then import the complete file again.
Clear filters, remove hidden rows, and check the used range in the worksheet
Use this when the worksheet itself appears filtered or has hidden rows, which can make a larger dataset look like only 100,000 rows.
Check SQL Server import and export settings for row limits
Use this when the source is SQL Server or an import wizard and a query or tool setting is limiting the returned rows to 100,000.
Import and verify large files in WPS Spreadsheet
Open or import CSV, XLSX, or database exports in WPS Spreadsheet, verify row counts, clear filters, and work with large datasets without being limited by Excel display issues.
- 1. Open WPS Spreadsheet and import the source file: Launch WPS Spreadsheet, click the Data tab, choose Import Data or open the CSV/XLSX file directly, and select the source file to import.
- 2. Verify the imported row count: Use an empty cell to enter =COUNTA(A:A) or select the last imported row and press Ctrl+End to confirm the total number of rows that WPS Spreadsheet imported.
- 3. Remove filters and unhide rows: Go to the Data tab and turn off Filter, then select the visible rows, right-click the row headers, and choose Unhide to display all rows.
- 4. Re-import from the source if rows are still missing: Return to the original database or file, remove any row-limit query settings, re-export the complete data, and import it again into WPS Spreadsheet.

Frequently Asked Questions
Does Excel have a 100,000 row limit?
No. Excel worksheets support more than 250,000 rows. If you see only 100,000 rows, check filters, hidden rows, source truncation, or import settings.
Why does SQL Server import stop at 100,000 rows?
SQL Server import wizards, queries with TOP or LIMIT, or export tool settings can limit returned rows. Check the query and import options for row-count restrictions.
How do I count the actual rows in WPS Spreadsheet?
Use the COUNTA or ROWS function over an imported range, or press Ctrl+End to jump to the last used cell. Compare the result with the source row count.
Can WPS Spreadsheet open large Excel files?
Yes. WPS Spreadsheet supports Excel-compatible formats and can open large files when the source file is complete and import settings do not truncate rows.
What should I do if my CSV only has 100,000 rows?
Open the CSV in a text editor or use a row-count tool to confirm the source row count. If the source itself has only 100,000 rows, regenerate or re-export the complete CSV.




