Even if there is some text around the table, you won’t be able to convert it to Excel through Google Drive. Moreover, you can only convert a PDF file that has a single table only. You’ll have to follow a dedicated approach to get the job done. There’s no direct way to import a PDF document and instantly convert it to Excel. It’s worth noting that converting PDF to Google Sheets or Excel using Google Drive is not a straightforward process. How to Coverter PDF to Excel Using Google Drive In the end, we’ll also share some convenient alternatives to convert PDF documents to an Excel sheet. So, in this article, we’re going to share the step-by-step procedure on how to convert PDF to Excel Google Drive. To do this, you’ll just need an active Google Drive account. So, if you have a PDF file with a table, you can simply convert it to Google Sheets and start the editing process. Google Docs and Google Sheets are two different Google Suite tools that can be used to manage “.docx” and ”.XLS” files. So, what would you do when you have a PDF document that requires some editing? One of the most convenient solutions to edit a PDF file is to convert it into their corresponding Google Docs or Google Sheets files.

You change according to your Data structure.While PDF files are great for portability, it’s impossible to edit them. NB: The Data I've used to TEST the code has 3 Column(RED Colour Value), so that with For Loop Step & Resize value is 3. XOutRg.Offset(xNRow, 0).PasteSpecial Paste:=xlPasteAll, Transpose:=True Set xOutRg = Application.InputBox('Select output range(specify one cell):', 'Transpose to Excel', xTxt,, ,, , 8) MsgBox 'Used range only contain one column',, 'Transpose to Excel'

Set xRg = Application.InputBox('Select Data Range(only one column):', 'Transpose to Excel', xTxt,, ,, , 8) I would like to suggest you VBA Code, this will Transpose the Copied Data Table from PDF to Excel.

Transfer data from pdf to excel