put big Word table into Excel

[hill0093]

I have a 723 KB MicroSoft Word file containing
only a Table of four columns andabout
23000 rows on 455 pages.
I wanted to sort on column four but MSWORD said
that the table was too big for MSWORD.
I have been told that Excel can manipulate it.
Is that correct? if so, how can I easily get it into excel?
I have windows 10 and word andexcel 2016.

 

[Macropod]

Did you try copy/paste? Pretty basic.

 

[Ruddles]

Have you tried Googling import word table excel?

Maybe this will help: http://www.techrepublic.com/blog/microsoft-office/add-data-to-an-excel-worksheet-from-a-word-table/

 

[hill0093]

I tried copy, but it takes forever to copy, and errors come in.
Can I read the word file into Excel?

 

[mrshl9898]

Can you copy with ctrl+shift+down, click at the top and press these 3 together?

 

[hill0093]

what is down?
I know ctrl and shift, but I don't know down.

 

[mrshl9898]

the down arrow. i don't use word but it selects all in excel.

 

[mrshl9898]

alternatively

https://www.extendoffice.com/documents/word/639-word-select-all-tables.html

 

[hill0093]

Thanks. A click on the little box at the upper left corner selects the whole big table.
ctrl-c then copies the whole table, and ctrl-v pastes it into Excel.
All this is slightly slow with the big file, but actually fast compared to some other ways.
Have to prepare a place for it first, I believe.
I will work and learn and see if it satisfies me.
Good for now. Thanks much.
Still don't know what down arrow is though I may not need to know.

 

[Macropod]

Can you copy with ctrl+shift+down, click at the top and press these 3 together?

That's for Excel, not Word. In any event, Word's table tools already have a Select Table option, so using that then copying the selection is hardly rocket science.

errors come in.
Can I read the word file into Excel?

Since you don't say what these errors are, it's unrealistic to expect help solving them.
Reading the data with a macro may only replicate the same 'errors'.