Remove the First Seven Rows with Power Query in WPS Office
Question details
The user needs to import a workbook into WPS Office Power Query, remove the first seven rows, select required columns and records, and load the cleaned data for further use.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Preparing an imported workbook for analysis by removing unwanted top rows and keeping only the required columns and records.
- Observed behavior
- The goal is to load cleaned data without the first seven rows into a new worksheet or table for further use.
Make sure the source workbook is accessible from SharePoint or the selected location, and confirm WPS Office Spreadsheets is installed with the Data tab and Power Query commands available.
Remove the First Seven Rows with Power Query in WPS Office
Use this method when you need to clean an Excel workbook by deleting top rows and keeping only the required columns before loading the data.
In WPS Office Spreadsheets, click Data > Get Data > From File > From Excel Workbook, then select the workbook from SharePoint or your local location.
In the Navigator, select the sheet or table that contains the data, then click Transform Data to open Power Query.
In the Power Query editor, go to Home > Remove Rows > Remove Top Rows, enter 7, and click OK.
Select the columns and records you need, right-click a selected column header and choose Remove Other Columns if necessary, and apply any filters.
Click Close & Load to load the result into a new worksheet; create a table from the loaded result if needed.
Clean Excel Data with WPS Office Power Query
Use WPS Office Power Query to import a workbook, remove the first seven rows, select the required columns and records, and load the cleaned data for analysis.
- 1. Download and install WPS Office: Go to the official WPS Office website, download WPS Office Free, and install it on your computer.
- 2. Open your Excel workbook: Launch WPS Office Spreadsheets and open the Excel workbook from SharePoint or your local folder.
- 3. Open Power Query: Click Data > Get Data > From File > From Excel Workbook, select the file and sheet, then choose Transform Data.
- 4. Remove top rows and load: In Power Query, click Home > Remove Rows > Remove Top Rows, enter 7, keep the required columns, and choose Close & Load.
Frequently Asked Questions
Can I remove a different number of top rows instead of seven?
Yes. In Power Query, click Home > Remove Rows > Remove Top Rows and enter the number of rows to skip, then click OK.
Does removing top rows in Power Query delete them from the original workbook?
No. Power Query cleans the imported data only, so the source workbook remains unchanged unless you manually overwrite or save over it.
How do I load the cleaned data as a table in WPS Office?
After choosing Close & Load, select the loaded result and click Insert > Table or press Ctrl+T to create a table for further analysis.
Can I import a workbook from SharePoint with Power Query in WPS Office?
Yes. Use Data > Get Data > From File > From Excel Workbook, choose the SharePoint location or synced folder, select the sheet, and click Transform Data.
