You can convert Microsoft Word 2013 files into Microsoft Excel 2013 files by importing and exporting plain-text files. When you are ready to save your Word document, you can change the file save as type to a plain-text file. Excel can open plain-text files you've saved to your computer and convert the content into a worksheet. Use record delimiters in Word to help Excel distinguish between paragraphs and line breaks in your document.
Create Record Delimiters in Word
Step
Open your document in Word. You may need to click the "Enable Editing" button at the top of your document if it is protected.
Step
Show paragraph marks and formatting symbols in your document. Click the "Show / Hide Paragraph Marks" button, which resembles the paragraph symbol of a backwards letter "P," in the Paragraph group of the Home ribbon. Alternatively, you can press "Ctrl-Shift*" to toggle paragraph marks. Paragraph marks appear next to each paragraph in your document.
Video of the Day
Step
Replace your paragraph marks with another character. Click "Replace" in the Editing group of the Home ribbon to open the Find and Replace dialog. Click "More," "Special" and then "Paragraph Mark." Repeat the process to enter another paragraph mark directly after the first in the "Find What" field. Enter a character that is not used throughout your document into the "Replace With" field. For example, enter a ~ tilde symbol. This symbol serves as a record delimiter Excel will use to distinguish paragraphs during the conversion. Click "Replace All" and then "Close" to apply the delimiter to your document.
Convert Plain-Text Files
Step
Save your Word document as a plain-text file. In order for Excel to convert your document into its worksheet, you must change the type of file to a .TXT file. Click "File," "Save As," "Computer" and then "Browse" and locate a directory to save your file to. Select "Plain Text (*.txt)" from the Save As Type drop-down and then click "Save." A copy of your document is saved to your computer as a .TXT file.
Step
Open your .TXT file in Excel. Open Excel and then click "Open Other Workbooks" from the bottom of the Recent backstage view. Click "Computer," "Browse" and then locate the directory you saved your TXT file to. Click the "All Excel Files" drop-down and then select "Text Files (.prn;.txt;*.csv)." Select your .TXT file and then click the "Open" button.
Step
Complete the steps in the Text Import Wizard. Select one of the options in the "Original Data Type" group. For example, if you didn't prepare your document for conversion using record delimiters, select "Fixed Width" and then click the "Finish" button to import your document. If you did prepare your document for conversion using record delimiters, such as the tilde ~, then you should select "delimited" and click "Next." Enter your record delimiter into the field next to "Other" in the Delimiters group. For example, enter a tilde. Click "Finish" to finish importing your text into the document.
