Converting a Word document to an Excel spreadsheet is a practical way to turn text-based lists, tables, or data into a format you can sort, filter, and calculate with. This guide walks you through the main methods—copy-paste, saving as text, and using Word’s built-in table conversion—so you can pick the one that fits your document. Before starting, make sure you have both Microsoft Word and Excel installed on your computer.
What You’ll Need
- A computer with Microsoft Word and Excel installed (any recent version, such as Office 2016 or later, or Microsoft 365).
- The Word document you want to convert, saved on your device.
- Access to the file’s location so you can open it and save new versions.
Step-by-Step
There are three reliable ways to move data from Word to Excel. Choose the method that matches how your document is structured.
Method 1: Copy and Paste (Best for Tables or Lists)
- Open the Word document that contains the data you want to convert.
- Select the content. If it is a table, click anywhere inside it, then click the small cross icon at the top-left corner of the table to select the whole table. If it is a list or paragraphs, highlight the text with your mouse.
- Press Ctrl+C (Windows) or Command+C (Mac) to copy the selection.
- Open Excel and click on the cell where you want the data to start (usually A1).
- Press Ctrl+V (Windows) or Command+V (Mac) to paste.
- If the data does not land in separate columns, click the small paste icon that appears at the bottom-right of the pasted area, then select Use Text Import Wizard or Text to Columns (see Troubleshooting below).
- Adjust column widths by selecting the columns, then double-clicking the boundary between column letters.
Method 2: Save as Plain Text (Best for Large Documents)
- Open the Word document.
- Click File > Save As (or Save a Copy in newer versions).
- Choose a location on your computer.
- In the Save as type drop-down menu, select Plain Text (*.txt).
- Click Save. A dialog box may appear asking about file encoding—choose Windows (Default) and click OK.
- Open Excel, then click Data > From Text/CSV (in the Get & Transform Data group).
- Browse to the .txt file you just saved, select it, and click Import.
- Excel will open the Text Import Wizard (or the modern import dialog). Choose Delimited if your data is separated by tabs, commas, or spaces; choose Fixed width if the data is aligned in columns.
- If you chose Delimited, check the box for the delimiter that matches your document (usually Tab for tables, Comma if you used commas).
- Click Next, then Finish. The data appears in columns in a new worksheet.
Method 3: Convert a Word Table Directly
- Open the Word document with the table.
- Click anywhere inside the table.
- Go to the Layout tab (under Table Tools) and click Convert to Text.
- In the dialog box, choose a separator—Tabs is usually best because Excel will place each table cell in its own column.
- Click OK. The table becomes plain text with tabs.
- Select all the text (Ctrl+A), copy it, and paste it into Excel as described in Method 1.
- Excel will automatically split the data into columns based on the tabs.
Common Mistakes
- Pasting into a single column: If you paste and everything lands in column A, the data is not being split. This usually happens when the source text uses spaces instead of tabs or commas. Re-copy using Method 2 or use Text to Columns.
- Ignoring hidden characters: Word documents often contain invisible formatting like paragraph marks and tabs. They can cause extra blank rows or columns in Excel. Use the Text Import Wizard to control how delimiters are read.
- Copying merged cells: If your Word table has merged cells, Excel will not reproduce them the same way. The data will appear with gaps. Unmerge the cells in Word before copying, or manually adjust after pasting.
- Forgetting to save the .txt file: If you close the text file without saving, the import will fail or use old data. Always confirm the save dialog is completed.
Tips
- Before converting, clean up the Word document: remove extra blank lines, ensure columns are separated consistently (tabs or commas), and delete any headers or footers you do not need.
- If your document has multiple sections, convert them one at a time to keep the data organized.
- Use Excel’s Text to Columns feature (Data tab > Text to Columns) after pasting if the data is already in one column but should be split. Choose Delimited, then pick the separator.
- For recurring conversions, save a blank Excel template with the column headers already set up, then paste data into it.
- If the Word document contains images or charts, they will not convert to Excel. Copy those separately or insert them manually.
Troubleshooting
- Data appears in one column only: Select the column, go to Data > Text to Columns, choose Delimited, and check the correct delimiter (tab, comma, space). Preview the result and click Finish.
- Numbers are stored as text: Excel shows a green triangle in the corner of the cell. Select the column, click the warning icon, and choose Convert to Number. Alternatively, multiply the column by 1 using a blank cell and Paste Special.
- The Text Import Wizard does not appear: In newer Excel versions, the wizard is hidden. Click Data > From Text/CSV, then in the import dialog, click Transform Data instead of Load. That opens the Power Query editor, where you can split columns manually.
- Extra blank rows or columns: After importing, select the empty rows/columns and delete them. Use Ctrl+Shift+End to select all data, then press Ctrl+G > Special > Blanks, and delete rows.
- Date formats change: When importing, Excel may interpret dates incorrectly. In the Text Import Wizard, select the column and choose Date as the column data format, then pick the correct order (e.g., DMY).
- The file is too large to import: Break the Word document into smaller sections and convert each one separately, then copy the results into one Excel sheet.
Frequently Asked Questions
Can I convert a Word document to Excel without losing formatting?
Basic formatting like bold or colors will not carry over. Only the data is transferred. You can reapply formatting in Excel after the conversion.
What if my Word document has multiple tables?
Convert each table separately. Copy one table at a time and paste it into a different area of the Excel sheet, or use Method 3 for each table individually.
Will this work with Word Online or Google Docs?
Word Online does not have a Save As text option. Use the copy-paste method instead. For Google Docs, you can download the file as a .docx first, then follow the steps above.
How do I convert a PDF that came from Word into Excel?
Open the PDF in Word (File > Open > select the PDF), then use Method 1 or 2. The text will be editable after Word converts it.
Can I automate this conversion for many files?
Yes, using Excel’s Power Query or a simple VBA macro. For a one-time batch, the text file method works best—save all Word docs as .txt, then import them one by one.
Why does my data have extra spaces between words?
Word often adds spaces for alignment. After pasting into Excel, use Find & Replace (Ctrl+H) to replace two spaces with one, or use the TRIM function to remove leading/trailing spaces.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- Gmail Notifications Not Working? Fixes That Work
- Fix Thumbnails Not Showing on Network Drives in Windows 11
- Stop Skype Auto-Start in Windows: 5 Fixes
- SQL Injection Prevention: Step-by-Step Guide
- Fix Windows PowerShell Popping Up
- Print iMessage or Text Conversations on iPhone & iPad