News WordPress Theme

Extract images & PDFs to Excel (single/multi pages)

Extract images & PDFs to Excel (single/multi pages)

Office 365 brings us some new ways to extract PDF files into Excel, whether it’s a single or multiple sheets or even combining multiple PDF files into one, it gets a little harder but it’s all possible and this could be an eternal timesaver trick. With images, we will look at the built-in method via Office mobile and a…

Read More

Import Text files into Excel [5 Methods]

Import Text files into Excel [5 Methods]

5 different methods to import text files into Excel are explained in this video. Topics discussed – 2 simple methods to open text files in Excel – Import Single as well as Multiple Text files into Excel using Power Query – Import Text file into Excel using Power Pivot – Macro to Import Text file into Excel #ImportTextFileintoExcel #ImportTextFilePowerPivot…(read…

Read More

Import Data from a PDF to Excel

Import Data from a PDF to Excel

Import data from a PDF into Excel using the new Power Query PDF connector. Download the Excel and PDF practice file here: View my comprehensive courses: Connect with me on LinkedIn: …(read more) Convert Word 2 PDF: Word to PDF Converter Convert PowerPoint 2 PDF: PPT to PDF Converter Convert Excel 2 PDF: Excel to PDF Converter Convert an…

Read More

Power Query – Convert Table in PDF to Excel

Power Query – Convert Table in PDF to Excel

Importing or converting a table from a PDF document into Excel can be a difficult process. You might have been doing a copy and paste and editing or deleting our strange characters, spaces or tabs. Whether it was a small table or large one, it’s a time intensive process. If you’ve got the Microsoft 365 subscription (formerly Office 365…

Read More

Quickly Import PDF Data to Excel @Brain Up

Quickly Import PDF Data to Excel @Brain Up

Quickly Import PDF Data to Excel  @BrainUpp   Connect a PDF File to Excel To get started, select the sheet you want to work with in Excel and go to the Data tab. Click the Get Data drop-down arrow on the left side of the ribbon. Move your cursor to From File and pick “From PDF.” Locate your file…

Read More

Convert Table in a PDF File to Excel

Convert Table in a PDF File to Excel

Have you ever wanted to get a data table in from a PDF file into excel so you could do some further analysis or charting? There’s not a PDF to Excel converter capability though some websites have tools to do this for you (but if you have confidential information you’d wouldn’t want to upload it to a 3rd party…

Read More

Properly Convert PDF to Excel

Properly Convert PDF to Excel

Did you know that you now have the option of importing and converting PDF data into Excel? This was one of the top requests of Excel users: How can we convert a PDF file into Excel? Now you can use Power Query’s amazing data functionality to not just convert PDF to Excel, but import the PDF data with a…

Read More