If you're a little handy with python (or got someone who is) you could read
the contents of a table in the word doc, convert it to a pandas datafromae,
and then it's pretty simple to export a dataframe to and excel spreadsheet
with the pd.to_excel() function.
Take a look at this:
https://stackoverflow.com/questions/47977367/how-to-create-a-dataframe-from-a-table-in-a-word-document-docx-file-using-pan?noredirect=1&lq=1
could be handy to do this in a little script if you're going to be doing it
more than once.
Good luck!
--Ray
On Wed, Sep 16, 2020 at 11:16 AM Tim McMahon <[log in to unmask]> wrote:
> You should be able to highlight and copy from the Word document and
> paste into the Excel document. Or did you want it automated somehow?
>
> On 9/16/20 10:11 AM, Amy Schuler wrote:
> > Hi all,
> > does anyone know of a way to export (or scrape) the contents of a Word
> doc
> > text table into Excel or some other spreadsheet application like Google
> > sheets? I know this is a long shot.
> > thanks!
> >
> --
> Tim McMahon
> West Liberty Public Library
> 319-627-2084
>
--
Ray Voelker
(937) 620-1830
|