Thank you for your informative video! I recommend trying the VeryPDF PDF to Excel Converter. This Windows software automatically converts PDF files into Excel spreadsheets and allows you to combine multiple PDFs while maintaining formatting.
@amazon5665 Жыл бұрын
thanks a lot, I have a question, what if a pdf contains 200pages and while uploading on power query the pages are unsorted, how to fix it?
@skillsphere4711 ай бұрын
Hi @amazon5665, Apologies for delay response, i was stuck in some work. Can you please share me screenshort of the the page where you are stuck. I will try to help you to resolve this, or soon i will come up with new video. Meanwhile you can follow below steps: 1. Load table from pdf (Data -> Get Data -> From File -> From PDF) 2. Select all the tables that you want to load. 3. Click on Transform Data 4. Go to Home Tab -> Append Queries -> Append Queries as New 5. Select "Three or more tables. 6. From: Available Tables Box - Add all the tables in sequence in Tables to Append Box and Click OK. A new table will be created Named "Append1" that will contain all the data from all selected tables in same order. If any other query, feel free to write. Thanks...😊
@amazon566511 ай бұрын
@@skillsphere47 gr8 I will share with u as soon as possible
@jonelatendido9836 Жыл бұрын
🎉can we export all tables data only from multiple pdf files using this?