Write a Script to Convert Document content to Spreadsheet csv
Budget: $250 – $750 AUD
I am converting word course workbooks to online courses. I am currently cutting and pasting into a course lms which is really inefficient.
I need a script i can run between Word/google docs and/or excel/google sheets that converts doc content into delimited text to be imported into a spreadsheet.
The text needs to be separated by the documents applied text styles ie Title, heading 1, heading 2, paragraph, para bullet list, para numbered list, figure etc so each style is a seperate field/ column when imported into excel.
The document also contains text boxes, tables, charts and pictures, if possible is there a way to capture those as well.
The content structure / list levels and associated paragraphs/tables/ images etc needs to remain in section group, order/ same row seperate fields. ie
Section a
h1.a
h2.a
paragraph a
bullet list a
h2.a2
paragraph a2
table a
Section b
h1.b
h2.b
paragraph b
table b
caption b
paragraph b
h2 b1
para b1
h3 b2
para b2
I found a script thats trying to do something similar
https://stackoverflow.com/questions/50838029/extract-heading-from-word-to-excel
if that helps with anything
And if possible i would like to run multiple word docs into 1 spreadsheet...a single or bulk processing option
Doc 1: Row 1
Doc 2: Row 2
So docs manually selected when running the script or located in a folder that is accessed by the script)
Errors and exceptions need to be managed as anyone normally would.
I need a script i can run between Word/google docs and/or excel/google sheets that converts doc content into delimited text to be imported into a spreadsheet.
The text needs to be separated by the documents applied text styles ie Title, heading 1, heading 2, paragraph, para bullet list, para numbered list, figure etc so each style is a seperate field/ column when imported into excel.
The document also contains text boxes, tables, charts and pictures, if possible is there a way to capture those as well.
The content structure / list levels and associated paragraphs/tables/ images etc needs to remain in section group, order/ same row seperate fields. ie
Section a
h1.a
h2.a
paragraph a
bullet list a
h2.a2
paragraph a2
table a
Section b
h1.b
h2.b
paragraph b
table b
caption b
paragraph b
h2 b1
para b1
h3 b2
para b2
I found a script thats trying to do something similar
https://stackoverflow.com/questions/50838029/extract-heading-from-word-to-excel
if that helps with anything
And if possible i would like to run multiple word docs into 1 spreadsheet...a single or bulk processing option
Doc 1: Row 1
Doc 2: Row 2
So docs manually selected when running the script or located in a folder that is accessed by the script)
Errors and exceptions need to be managed as anyone normally would.