Can You Export and Import a Microsoft Word Index to Excel?
Question details
The user wants to export a Word index to Excel, edit it as spreadsheet data, and import it back into Word without losing automatic page-number updates.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Attempting to edit a document's generated index externally in a spreadsheet program like Excel.
- Observed behavior
- Because Word uses dynamic INDEX and XE fields, the index cannot be seamlessly exported to Excel and reimported. Converting it to text for export permanently breaks the automatic page-number updates.
Before modifying your index, save a backup copy of your original Word document. Once an index field is converted to plain text for export, the dynamic connection to your document's page numbers is permanently unlinked.
Convert the Word Index to Plain Text and Export to Excel
Since dynamic index fields cannot be exported directly to a spreadsheet, you must first convert the index to plain text in Word, then copy and paste it into Excel.
Microsoft Word relies on INDEX and XE fields to generate and update index entries. Because Excel does not support these specific word processing fields, you cannot export the index, edit it as data, and import it back while retaining the automatic page-update functionality. You can only export the static text representation of the index.
Open your Microsoft Word document, scroll to the generated index at the end of your document, and highlight the entire index text with your cursor.
Press Ctrl + Shift + F9 on your keyboard. This shortcut instantly unlinks the dynamic fields and converts your index into standard, plain text.
Press Ctrl + C to copy the plain text index, open a blank Excel spreadsheet, and press Ctrl + V to paste the data into the cells for external editing.
After finishing your edits in Excel, you can copy the spreadsheet data and paste it back into Word. Keep in mind that it will remain static text.

Try WPS Office for Your Document Editing Needs
If you frequently work with complex documents and are looking for a reliable, lightweight word processor, WPS Office offers a completely free and highly compatible alternative to Microsoft Office. It fully supports Word's field codes, indexes, and layout settings, ensuring a seamless transition.
- 1. Download and Install: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open Your Document: Launch WPS Writer and open your existing Microsoft Word (.docx) file to view and edit your document.
- 3. Edit with Ease: Use the familiar Ribbon interface to edit text, update table of contents, and manage your indexes seamlessly.

Frequently Asked Questions
Why can't I edit a Word index in Excel and keep the page numbers dynamic?
Word generates indexes using background codes known as INDEX and XE fields. Excel is a spreadsheet application and does not recognize or support these word-processing fields, meaning the dynamic link is broken when the data is transferred.
What is the keyboard shortcut to convert fields to plain text in Word?
You can highlight any field (such as an index, table of contents, or bibliography) and press Ctrl + Shift + F9. This action unlinks the field and instantly turns it into standard, editable text.
How can I update my index if I don't export it to Excel?
Instead of exporting the index, you should edit the actual XE (Index Entry) fields directly within your Word document. Once edited, simply right-click anywhere on the index and select 'Update Field' to automatically refresh the entries and page numbers.
Can I rebuild the index automatically after pasting the text back from Excel?
No. Once the index is converted to plain text and pasted back from Excel, Word treats it as normal typed text. To restore automatic updates, you would need to mark your index entries in the document again and insert a brand new index.




