📝Converting data from a PDF📕 file to Excel📗
#excel #exceltutorial #exceltips #exceltraining #excel #exceltips #shorts #short #shortvideo #shortsvideo
Now I'll show you how to quickly transfer data from a PDF to Excel in 1 minute.
How to do it?
⬇️ Open the PDF file, then copy the link from the browser search bar.
⬇️ Go to Excel, select the "Data" tab in the top menu.
⬇️ Click "Get Data." Select "From Other Sources," then select "From the Internet."
⬇️ Paste the copied link and click "OK."
⬇️ This takes you to the Power Query editor.
⬇️ Select our file and double-click to display the information.
⬇️ Select the table we're interested in and click "Table." The table will open in the Power Query editor.
⬇️ Close the Power Query editor and save your changes.
🆗 The table from the PDF appears in the Excel sheet.