Skip to content

stu-bell/PowerQueryDocx

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 

Repository files navigation

PowerQueryDocx

Open Microsoft Word Docx files in Power Query

Copy and paste the code from the file DocxToListpq into a new blank query in the power query editor. Then in another blank query, use the function something like this:

let 
  FilePath = "C:/path/to/file.docx",
  Source = DocxToList(File.Contents(FilePath))
in Source

Microsoft Docs on custom Power Query functions: https://learn.microsoft.com/en-us/power-query/custom-function

This version is very basic and only picks out text and new lines. If there are specific elements in your word doc you want to extract, you'll need to figure out the element names and attributes from the Open XML docs and modify the extract text function.

Thanks to Mark White for the zip extraction function

About

Open Microsoft Word Docx files in Power Query

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published