cancel
Showing results for 
Search instead for 
Did you mean: 

How To Import(.PDF,.Docx,.Txt Files) into Excel?

Anonymous
Not applicable
Can Someone Suggest How to Import (.PDF ,.Docx, .Txt Files) into Excel? Are is there any VBO?
2 REPLIES 2

BastiaanBezemer
Level 5
Hi Palaniappan, Importing a text file into Excel is the easiest. The big question is what the format is of your text file is: different columns seperated by comma (so it's in fact a CSV) or you first need to parse it? WIth the object Utility - File Management with the action Read All Text from File or Get CSV Text As Collection you should be able to handle those cases. And then you can use the Excel VBO to write to the excel file Regarding the word file: The same question applies: What do you want to have from it? Transfer the tables from the word document to an Excel file, or just copy paste the text? PDF files are a bit more tricky, but there is a BluePrism tutorial on how to deal with them. Also the forum contains quite some info and tips & tricks. Good luck 

YogeshAnand
Level 2
Hi bastiaan.bezemer2, Can you please share the link of these videos (extract content from a pdf file)?