How to extract date-range records from a dataset too large for Excel with Power Query
Question details
The user needs to import a large dataset, filter the date column to values on or after July 17, 2022, and load only the matching records into a worksheet or analysis tool.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- A source dataset exceeds Excel’s worksheet row limit, so the user wants to extract only the records within a specific date range before loading it.
- Observed behavior
- Loading the full dataset into the Excel worksheet grid is not possible because it exceeds the row limit; filtering must occur before or during import.
Confirm that the source uses a consistent date format and note the file path. If you are using Power Query, open a blank workbook and avoid loading the full source file into the worksheet grid.
Use Power Query to filter the date column before loading
Use this when the source file is too large for the Excel worksheet but you need to extract only records on or after July 17, 2022.
Power Query connects to the source, applies the date filter, and loads only matching rows, so Excel never has to place the full dataset in the worksheet grid.
In Excel, open a blank workbook, click Data > Get Data, choose From File > From Workbook or From Text/CSV as needed, and select the source file.
Click Transform Data instead of Load to open the Power Query Editor and avoid loading the full dataset into the worksheet.
Select the date column, click the filter drop-down arrow, choose Date Filters > After/Equal, enter 7/17/2022, and click OK.
Click Close & Load To, choose Table and a destination worksheet; if you only need a connection, choose Only Create Connection and click OK.

Load and filter the data in the Excel Data Model or Power Pivot
Use this when Power Query is not available or you want to build a PivotTable directly from the filtered large data source.
Query the source with SQL, Python, C#, or another external tool
Use this for very large or recurring extracts when you want to filter outside Excel before exporting the results.
Use WPS Office as a free alternative for editing filtered .xlsx files
If Power Query and Excel Data Model workflows feel complex, WPS Office is a free, lightweight Microsoft Office alternative. WPS Spreadsheets opens .xlsx and .csv files with a familiar ribbon UI, supports standard date filters and pivot tables, and makes it easy to work with the smaller filtered result after you export it from your large dataset.
- 1. Download WPS Office: Go to the WPS Office download page, download the free installer, and complete the installation.
- 2. Open the exported filtered file: Launch WPS Spreadsheets, click Menu > Open, and select the .xlsx or .csv file exported from Power Query, SQL, or Python.
- 3. Verify or reapply the date filter: Select the date column, click Home > Filter, and use a custom Greater Than or Equal To filter with 7/17/2022 if you need to refine the imported result.

Frequently Asked Questions
Can WPS Office handle a dataset larger than Excel’s row limit?
WPS Spreadsheets uses the same 1,048,576-row worksheet limit as Excel. For larger source files, filter before loading with Power Query, a database, or a script, then open the smaller exported result in WPS Office.
How do I filter a date column to records on or after 7/17/2022 in Power Query?
In Power Query Editor, select the date column, click the filter arrow, choose Date Filters > After/Equal, enter 7/17/2022, and then use Close & Load To to load only matching rows.
Where is Power Query in Excel?
On the Data tab, use Get Data or Get & Transform Data. From there choose From File, From Database, or another source, and then click Transform Data to open Power Query Editor.
What should I do if I do not have Power Query or Power Pivot?
Use an external tool such as SQL, Python, or C# to query the source for date_column >= '2022-07-17', export the filtered rows, and open the smaller file in Excel or WPS Office.
Can I use WPS Office to open the filtered results?
Yes. WPS Office supports .xlsx and .csv files, so you can open the exported date-range file and use standard filters, formulas, and pivot tables in WPS Spreadsheets.




