The fastest way to move data from Word to Excel
The simplest route depends on what your Word document contains. If it holds a table, you can copy it directly into Excel in seconds. If it holds text arranged in rows and columns but not formatted as a table, you will need to paste it as text and then split the columns. If the document is mostly prose with scattered numbers, manual entry or a more involved conversion method works better.
The direct copy method works only if your Word document already has a table. Select the entire table in Word, copy it, open Excel, click a cell, and paste. Excel will recreate the table structure automatically. This takes under a minute and preserves formatting like bold text and cell colors.
Key Takeaways
- A Word table copies directly into Excel and preserves its structure in one paste operation.
- Text separated by tabs or commas can be pasted into Excel and split into columns using the Text to Columns feature.
- If your Word document has no table or delimiter, you may need to save it as a CSV file first, then open it in Excel.
- Excel's Text to Columns tool (on the Data menu) automatically splits pasted text into separate cells based on spaces, tabs, or commas.
Copying a table directly from Word to Excel
Open your Word document and locate the table. Click anywhere inside the table, then use Ctrl+A (or Cmd+A on Mac) twice — the first press selects the table contents, the second selects the entire table object. You will see the table highlighted with a border.
Press Ctrl+C to copy. Open Excel, click the cell where you want the table to begin (usually A1), and press Ctrl+V. The table appears in Excel with all its rows, columns, and formatting intact. If the table has merged cells or complex formatting, Excel will do its best to recreate it, though some visual styling may not transfer perfectly.
Converting text with tabs or commas into columns
If your Word document contains text that looks like it should be in columns but is not formatted as a table — for example, names and phone numbers separated by tabs — you can still move it to Excel. Select all the text in Word, copy it, and paste it into a single column in Excel (starting at cell A1).
Once the text is in Excel, select the column containing the pasted data. Go to the Data menu and click Text to Columns. A dialog box opens asking how the data is separated. Choose the delimiter that matches your data: Tab, Comma, Space, or Other (if you used a different character). Click Next, review the preview to confirm the split looks correct, and click Finish. Excel will split the text into separate columns automatically.
Saving a Word document as CSV to open in Excel
If your Word document is mostly text without a clear table or delimiter, you can save it as a CSV (comma-separated values) file and then open it in Excel. This method works best if you first format your data in Word so each row is on its own line and fields are separated by commas or tabs.
In Word, go to File, then Save As. In the file type dropdown, scroll down and select CSV (Comma Delimited) or Text (Tab Delimited), depending on how your data is separated. Choose a location and filename, then click Save. Word will warn you that some formatting will be lost — this is normal. Open Excel, go to File > Open, and select your CSV file. Excel will open it directly, with the data already split into columns.
Using copy and paste for unstructured text
If your Word document contains a list of items without any clear structure, you can paste the entire document into a single Excel cell and then manually organize it. This is the slowest method but works when the data is too messy for automated splitting.
Select all text in Word (Ctrl+A), copy it, and paste it into Excel. The text will land in one cell. From there, you can edit the cell content directly, or copy the text into Notepad, clean it up, and paste it back into Excel in a more organized format. This approach is best reserved for small documents or when the other methods do not work.
Handling formatting and special characters
When you move data from Word to Excel, some formatting may not carry over. Bold, italics, and colors usually transfer fine when copying a table directly. However, headers, footers, page breaks, and text boxes do not move to Excel — they exist only in Word.
Special characters like bullets, dashes, and symbols sometimes convert to question marks or other characters when pasted. If this happens, check the pasted data carefully. You may need to retype affected cells or use Find & Replace in Excel to fix the characters. Go to Ctrl+H, enter the broken character in the Find field, type the correct character in the Replace field, and click Replace All.
When to use each method
| Your Word document has | Best method | Time needed |
|---|---|---|
| A formatted table | Copy the table directly and paste into Excel | Under 1 minute |
| Text separated by tabs or commas | Paste into Excel, then use Text to Columns | 2–3 minutes |
| Mostly prose with scattered data | Save as CSV, then open in Excel | 3–5 minutes |
| Unstructured or messy text | Paste into one cell and manually organize | 5+ minutes |
Frequently Asked Questions
Will my formatting stay the same when I copy a Word table to Excel?
Most formatting transfers: bold, italics, colors, and cell borders usually appear in Excel the same way they did in Word. However, some Word-specific formatting like text boxes and page breaks do not move. Test with a small table first to see what carries over.
What if the Text to Columns feature does not split my data correctly?
Make sure you selected the right delimiter in the dialog box. If your data uses a character that is not listed (like a semicolon or pipe), choose Other and type the character. If the preview still looks wrong, cancel and try a different delimiter or paste the data again.
Can I convert a Word document with multiple tables at once?
Yes. Select all content in Word (Ctrl+A), copy it, and paste it into Excel. Each table will paste separately, though they may not land exactly where you want them. You may need to move them around afterward to organize the spreadsheet the way you prefer.
What happens to images and shapes when I paste a Word table into Excel?
Images and shapes do not transfer when you paste a table. Only the text and numbers in the table cells move to Excel. If you need the images, you will have to copy them separately or insert them into Excel by hand.
Is there a way to automate this conversion if I do it regularly?
If you convert Word documents to Excel often, saving as CSV is the most reliable automated method. You can also use Excel's built-in import tools (Data > From Text/CSV) to open Word-exported files with more control over how the data splits into columns.