Data Import & Export

Why Excel Displays Only 100,000 Rows from a Larger File in WPS Spreadsheet

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 868 views

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 you start

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.

Solution 1Recommended

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.

1
Open the source file or database query

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.

2
Compare the exported or imported record count

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.

3
Re-export the source if it is truncated

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.

Expected result: The spreadsheet should display all rows from the verified complete source file after re-import.
WPS Spreadsheet data import

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. 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. 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. 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. 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.
Supports large XLSX, CSV, and Excel-compatible files so you can inspect every row.Full Microsoft Excel .xlsx format compatibility for sharing and re-editing.Familiar spreadsheet interface with Data tab filters, unhide, and import tools.Free download with no 100,000-row display restriction when source data is complete.
QA img-9

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.