How to Combine Multiple PDF Pages into One Power Query Table in WPS Office
Question details
The user wants to import a multi-page PDF report into one Power Query query in WPS Office and combine all detected pages into a single table instead of creating separate worksheets for each page.
- Product
- WPS Office Power Query
- Device & OS
- not provided
- Scenario
- Importing and consolidating a multi-page PDF report for analysis in WPS Office.
- Observed behavior
- The PDF Navigator can list pages or tables as separate items; the user needs one query that contains all detected pages and loads only the final combined table.
Open WPS Office and make sure the PDF file is saved locally and that the Data tab includes the From PDF option. Use a PDF with a consistent table layout where possible, because irregular page structures may need extra transformations.
Import a Multi-Page PDF as One Query from the PDF Navigator
Use this method when you want all detected PDF pages in one Power Query query so you can append, clean, and load a single final table.
In the PDF Navigator, WPS Office can show individual pages or the whole file. Selecting the file name with Select Multiple Items cleared sends all detected objects into one query, so the final append and cleanup happen inside Power Query instead of across multiple worksheets.
Go to the Data tab, click From PDF, and select the multi-page PDF report you want to import.
In the PDF Navigator dialog, clear the Select Multiple Items checkbox so the whole file is treated as one import source.
In the Navigator left pane, select the file name entry instead of individual page or table items.
Click Transform Data to open Power Query Editor. This creates one query containing the tables or pages detected in the PDF.
In Power Query Editor, append or otherwise combine the related pages, remove repeated headings, and then click Close & Load to load only the final query into the worksheet.
Combine Multi-Page PDF Data into One Table with WPS Office Power Query
Use WPS Office Power Query to import a multi-page PDF, combine all detected pages into a single query, remove repeated headings, and load one clean table for analysis.
- 1. Open the PDF from the Data tab: In WPS Office, click the Data tab and choose From PDF to locate and open your multi-page PDF report.
- 2. Select the whole PDF in the Navigator: In the PDF Navigator, clear Select Multiple Items, select the file name, and click Transform Data.
- 3. Combine pages in Power Query Editor: Use Append Queries or related transformation commands to stack the detected page tables into one table.
- 4. Clean repeated and missing headers: Remove repeated heading rows and promote or fill headers as required by the PDF layout.
- 5. Load one final table: Click Close & Load to return only the combined query result to your worksheet.
Frequently Asked Questions
Why does the PDF Navigator show separate pages instead of one table?
WPS Office Power Query lists the elements detected in the PDF individually. Clear Select Multiple Items, select the file name, and choose Transform Data so all detected pages enter one query for combining.
How do I handle repeated column headings when combining PDF pages?
Append the page tables in Power Query Editor first, then filter out repeated heading rows or promote headers from the first table before removing the extras.
Can I load only the combined table without creating a worksheet for each PDF page?
Yes. After combining the tables inside the query, click Close & Load. WPS Office loads only the final query result instead of separate worksheets.
What transformations are useful for multi-page PDF reports?
Append Queries stacks pages into one table, Remove Rows deletes repeated headings, and Promote Headers or Fill Down fixes missing header rows.
