The fastest way to get Excel data into Word

The simplest method is to copy your data directly from Excel and paste it into Word. Open your Excel file, select the cells you want to move (click and drag to highlight them, or click one cell and use Ctrl+A to select all), then press Ctrl+C to copy. Switch to your Word document, click where you want the data to appear, and press Ctrl+V to paste. Word will automatically format it as a table.

This method works best when you have a small amount of data or a single table. The pasted content becomes a standalone table in Word that you can edit, resize, and format independently of the original Excel file. If you later change the numbers in Excel, the Word table will not update automatically — it becomes a separate copy.

Key Takeaways

  • Copy and paste is the fastest method for moving Excel data into Word, and the data becomes an editable table you can format however you need.
  • If you want Word to automatically update when Excel changes, use the Link & Keep Source Formatting option in the Paste Special menu instead of regular paste.
  • For large spreadsheets or complex layouts, insert the Excel file as an object so Word displays it as a separate embedded file rather than converting it to a table.
  • Word tables created from Excel data can be resized, have rows and columns added or removed, and can be styled using Word's built-in table design options.

Using Paste Special to keep the link to Excel

If you want the Word document to stay connected to your Excel file so updates show up automatically, use Paste Special instead of regular paste. After copying your data from Excel, go to Word and click where you want it. Then press Ctrl+Alt+V (or go to the Home tab, click the arrow under Paste, and select Paste Special).

In the Paste Special dialog, choose "Link & Keep Source Formatting" or "Link & Keep Text Only" depending on whether you want the table styling from Excel to come along. Click OK. Now when you change numbers in the original Excel file and save it, those changes will appear in your Word document too. This is useful when you are working with data that changes regularly and you want one source of truth.

Be aware that if you move or rename the Excel file later, Word may lose the link and show an error. You will need to update the link manually by right-clicking the table in Word and choosing "Update Link" or re-linking to the new file location.

Inserting Excel as an embedded object

If you want to keep the Excel file separate but visible inside your Word document, you can embed it as an object. Go to the Insert tab in Word, click Object (usually in the Text group), and select "Create from File." Browse to your Excel file and click Insert. Word will display the Excel spreadsheet as a clickable object inside the document.

When you double-click the embedded object, Excel opens so you can edit the data directly. The changes stay in the embedded copy only — they do not affect your original Excel file unless you save it from within Word. This method is useful when you want to include a complete spreadsheet in a report but do not want readers to accidentally modify your source data.

Formatting the table after pasting into Word

Once your Excel data is in Word as a table, you can change how it looks. Click anywhere in the table, and the Table Design tab appears at the top. You can choose a pre-made style (the colored templates under Table Styles), adjust column widths by dragging the borders, and add or delete rows and columns by right-clicking and selecting the option you need.

You can also change the text inside the table just like regular Word text — select a cell and type to edit it. If you want to convert the table back to plain text, right-click the table, select Table, and choose Convert to Text. This removes the table structure and leaves just the data separated by tabs or commas, depending on what you choose.

Handling large spreadsheets and complex layouts

If your Excel file has many sheets or complex formulas, copying and pasting may not work well because Word tables do not support all Excel features. In these cases, embedding the file as an object (described above) is usually better because it preserves the original structure and functionality.

Another option is to export specific data from Excel as a CSV file (Comma Separated Values), then open that file in Word. This gives you a clean, straightforward table with just the data you need. To do this in Excel, go to File, select Save As, choose CSV format, and save. Then open that CSV file in Word — it will appear as a formatted table.

Copying charts and graphs from Excel to Word

If you need to move a chart or graph instead of raw data, the process is similar. Click the chart in Excel to select it (you will see a border around it), press Ctrl+C to copy, switch to Word, and press Ctrl+V to paste. The chart will appear as an image in your document.

If you want the chart to update when Excel data changes, use Paste Special and choose "Link & Keep Source Formatting" instead. This keeps the chart connected to the original Excel file. You can resize the pasted chart by dragging its corners, but you cannot edit the data directly in Word — you must go back to Excel to change the numbers.

Frequently Asked Questions

Will the Word table update if I change the Excel file later?

Not with regular copy and paste — the Word table becomes a separate copy. If you want automatic updates, use Paste Special and select "Link & Keep Source Formatting" instead. Then changes in Excel will show up in Word when you open the document.

Can I edit the data after pasting it into Word?

Yes. Once the data is in Word as a table, you can click any cell and type to change the content. You can also add or remove rows and columns by right-clicking the table and selecting the option you need. The table is fully editable in Word.

What if my Excel file has multiple sheets?

Copy and paste only works for one sheet at a time. If you need multiple sheets in Word, copy each one separately and paste them as different tables, or embed the entire Excel file as an object so all sheets are accessible when someone opens it.

How do I remove the table formatting and keep just the text?

Right-click the table in Word, select Table, and choose Convert to Text. Pick whether you want the data separated by tabs, commas, or paragraph marks. The table structure disappears and you are left with plain text.

Can I paste an Excel chart into Word?

Yes. Click the chart in Excel to select it, copy it with Ctrl+C, and paste it into Word with Ctrl+V. It becomes an image you can resize. If you want it to update when Excel changes, use Paste Special with the Link option instead of regular paste.