Once it opens, click the Edit on Word button in the upper part of the screen to convert the PDF into an editable document. On the OneDrive, find the uploaded PDF file, right-click on it and open it with Word online.
Method 3: Convert PDF File To Excel Using Microsoft Word OnlineĪnother option is to use Microsoft Word Online but for this, you will also need access to One Drive.įirst, upload the PDF file to OneDrive by either dragging the file from the folder directly to the OneDrive window open in your browser or opening the PDF file and saving it on the OneDrive. This option is only available comes from the new PDF connector feature which is only available for those who have Office 365 subscriptions. Select the file, then you will be prompted with a Navigator where you can select the tables where you want to pull out data from.Īfterward, click on the Load button to instantly put the data into the Excel sheet or choose Transform Data to edit it using the Power Query Editor. A drop-down menu will appear, where you need to choose From File.įile formats will appear on the side and here, you can choose From PDF.Ī dialog box will open for you to choose the PDF file where you will import data from.
How to export pdf to excel for free how to#
Note that this method will only work if the text or table on your PDF can be selected.Īlso: How to merge PDF files Method 2: Importing Data from PDF using Microsoft ExcelĪnother option is to directly import data using Microsoft Excel.įirst, open a new Excel spreadsheet and click on Data from the Menu bar.įrom the toolbar, click on Get Data. The result will be a bit messy, but if the data you’ll be importing will be minimal, then it might be somehow easier to manage and arrange properly on the Excel sheet. Or type in “Ctrl + Alt + V” to show the Paste Special dialog box.įrom the dialog box, choose Text and click on the OK button on the lower-right corner. From its dropdown menu, choose Paste Special. If this does not work, you can try to click on the Paste icon. However, using this method is not always very efficient as the alignment and format of the pasted data can be different. Next, you will need to open Microsoft Excel, and paste the data in there from your clipboard.