Buzz
Are you looking to add a PDF table to your Excel spreadsheet? When copying data from a PDF document and pasting it into an Excel sheet, you might end up with messy and illogical results. PDF and Excel use different formats, making it challenging to transfer information between these file types. Today, Mytour will guide you on how to copy a table from a PDF file to Excel using the import feature in the spreadsheet software.
Steps
Open Excel. You can start a new project or continue with a saved one on Excel.
- You also need to know the location of the PDF file containing the table to easily find it during the import process.
Select the starting cell for the table. This will be the cell at the top-left corner of the table you are about to copy from the PDF.
Click on Data located in the menu above the editing ribbon, near the File and Review options.
- If you're using a Mac, this menu will appear vertically at the top of the screen.
Click on Get Data. On Windows, this is the farthest icon on the left side of the menu.
- For Mac users, this option will appear in the dropdown menu when you click on Data.
Click on From File and select From PDF. Hovering over the first option will expand the menu, allowing you to choose From PDF. Excel will then open the file manager (Finder for Mac and File Explorer for Windows).
Navigate and double-click on the PDF file. Alternatively, you can select the PDF file and click on Import.
Click on the table you want to copy from the PDF into Excel. Knowing the location of the table is helpful as the data will be labeled by its position (the page containing the table).
- When you click on the table on the left, a preview of the table will appear in the right pane.
Click the Load button. This option, located at the bottom-right corner, will enable you to copy the table from the PDF file into your Excel spreadsheet.
- If you wish to make adjustments to the table, you can do so after clicking the Load button.
