Word to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3011806%22%20slang%3D%22en-US%22%3EWord%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3011806%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20convert%20word%20files%20to%20excel%20files%3F%20Yes%20or%20no.%20If%20yes%20how.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3011806%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3011828%22%20slang%3D%22en-US%22%3ERe%3A%20Word%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3011828%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1231584%22%20target%3D%22_blank%22%3E%40steve67fairlane%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20depends%20on%20the%20contents%20of%20the%20Word%20document.%3C%2FP%3E%0A%3CP%3EA%20table%20in%20a%20Word%20document%20can%20be%20copied%20into%20an%20Excel%20worksheet%2C%20but%20it%20makes%20little%20sense%20to%20convert%20a%20novel%20written%20in%20Word%20to%20Excel...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3011851%22%20slang%3D%22en-US%22%3ERe%3A%20Word%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3011851%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20would%20make%20most%20sense%20if%20you%20can%20describe%20the%20particular%20task%20you're%20trying%20to%20achieve.%20in%20Excel%20you%20can%20import%20text%20in%20a%20word%20file%20by%20using%20Data%20-%26gt%3B%20Get%20data%20-%26gt%3B%20from%20Text%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3012098%22%20slang%3D%22en-US%22%3ERe%3A%20Word%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3012098%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1227592%22%20target%3D%22_blank%22%3E%40Mike_Vu_Ngo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20word%20file%20is%20all%20text%20data.%20Name%2C%20address%2C%20phone%20number%2C%20date%2C%20no%20formulas.%20This%20is%20a%20list%20of%20approximately%201600%20customers%20for%20our%20small%20business.%20I%20would%20like%20to%20copy%20and%20paste%20the%20word%20files%20into%20the%20excel%20file.%26nbsp%3B%20Typing%20all%20the%20names%20into%20the%20excel%20file%2C%20is%20what%20I'm%20trying%20avoid.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3012099%22%20slang%3D%22en-US%22%3ERe%3A%20Word%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3012099%22%20slang%3D%22en-US%22%3EThe%20word%20file%20is%20all%20text%20data.%20Name%2C%20address%2C%20phone%20number%2C%20date%2C%20no%20formulas.%20This%20is%20a%20list%20of%20approximately%201600%20customers%20for%20our%20small%20business.%20I%20would%20like%20to%20copy%20and%20paste%20the%20word%20files%20into%20the%20excel%20file.%20Typing%20all%20the%20names%20into%20the%20excel%20file%2C%20is%20what%20I'm%20trying%20avoid.%3C%2FLINGO-BODY%3E
New Contributor

Can you convert word files to excel files? Yes or no. If yes how. Thanks

7 Replies

@steve67fairlane 

It depends on the contents of the Word document.

A table in a Word document can be copied into an Excel worksheet, but it makes little sense to convert a novel written in Word to Excel...

It would make most sense if you can describe the particular task you're trying to achieve. in Excel you can import text in a word file by using Data -> Get data -> from Text

@Mike_Vu_Ngo 

The word file is all text data. Name, address, phone number, date, no formulas. This is a list of approximately 1600 customers for our small business. I would like to copy and paste the word files into the excel file.  Typing all the names into the excel file, is what I'm trying avoid.

The word file is all text data. Name, address, phone number, date, no formulas. This is a list of approximately 1600 customers for our small business. I would like to copy and paste the word files into the excel file. Typing all the names into the excel file, is what I'm trying avoid.

@steve67fairlane 

Are the data in a table?

If not are name, address etc. separated by commas, or by tab characters, or by line breaks or paragraph marks?

You can either try:
1. Copy all words from Word to Excel by using simple Ctrl + C => Ctrl + V. Then use Excel Text to Column function and exploring from there. (Data -> Text to Column)
2. Make a table in Word, clean all your data in Word (each value to corresponding place), then copy whole table to Excel.
Feel free to ask if you're still stuck.
Thanks, I will try your idea. I will let you know the outcome.
Steve