How to Convert or Save a Word DOCX File as an Excel XLSX
Question details
The user needs to convert a Word document into an Excel workbook in order to use it as a data source for a mail merge.
- Product
- Word, Excel
- Device & OS
- not provided
- Scenario
- Using a DOCX file containing tabular data as a source for an Excel mail merge operation.
- Observed behavior
- Word does not offer a direct Save As option to export a DOCX document into an Excel XLSX workbook.
Ensure that the data in your Word document is organized in a clear, structured table format with explicit column headers before attempting to transfer it to Excel.
Copy Tabular Data from Word and Paste into Excel
Since Word cannot save directly to an Excel format, the most reliable method is to manually copy your table data from the DOCX file into a new Excel workbook.
This method ensures that your data transitions smoothly from a text document format into a spreadsheet format, which is required for using the data as a mail-merge source.
Open your DOCX file in Word. Hover over the table containing your data and click the crosshair icon in the top-left corner of the table to select the entire table.
Right-click the selected table and choose 'Copy' from the context menu, or simply press Ctrl+C on your keyboard.
Open Microsoft Excel and create a Blank Workbook. Click on cell A1, right-click, and select 'Paste' (or press Ctrl+V). Adjust the column widths if necessary to ensure all data is visible.
Go to File > Save As, choose your preferred destination, enter a file name, ensure the file type is set to 'Excel Workbook (*.xlsx)', and click Save.
Transfer Word Data to Excel Seamlessly with WPS Office
WPS Office provides a highly compatible suite including WPS Writer and WPS Spreadsheet. You can effortlessly copy structured tables from your documents and paste them into spreadsheets while retaining formatting, then save them as XLSX for mail merge.
- 1. Copy data in WPS Writer: Open your DOCX file in WPS Writer, select the table data, and press Ctrl+C to copy.
- 2. Paste in WPS Spreadsheet: Switch to a new tab with WPS Spreadsheet, select cell A1, and press Ctrl+V to paste the data.
- 3. Save as XLSX: Click Menu > Save As, select 'Microsoft Excel Workbook (*.xlsx)', and click Save to use it for your mail merge.
Frequently Asked Questions
Can I export a Word document directly to Excel?
No, Microsoft Word and WPS Writer do not have a built-in 'Save As Excel' option. You must copy the tabular data manually or convert the document to a PDF first, then use a PDF-to-Excel converter to extract the tables.
Why is my copied Word table formatting incorrectly in Excel?
This usually happens if the Word table contains merged cells, nested tables, or hidden paragraph marks. Clean up the Word table layout to ensure it is a simple grid before copying it into Excel.
How do I use the new Excel file for a mail merge?
Open your main document in Word, navigate to the Mailings tab, click 'Select Recipients', choose 'Use an Existing List', and browse to select the new XLSX file you just saved.
