How to Paste Multiple Rows into a Word Table on Mac
Question details
The user needs to paste several lines of delimited text (such as text separated by an equals sign) into an existing Word table so that the data correctly populates into separate rows and columns.

- Product
- Word
- Device & OS
- Mac
- Scenario
- Pasting raw delimited text from an external source or plain text document into a Microsoft Word table.
- Observed behavior
- When pasting the delimited text directly into Word, all the content is placed into a single cell or row instead of automatically splitting into separate columns and rows based on the delimiter.
Ensure you have both a word processor and a spreadsheet application (such as Excel or WPS Spreadsheet) installed on your Mac, as the easiest way to parse the delimited text is by using spreadsheet tools before pasting.
Use a Spreadsheet to Split Text to Columns Before Pasting
Using a spreadsheet application's Text to Columns feature is the most reliable way to separate delimited text into distinct columns and rows before pasting it into a Word table.
Word processors often struggle to automatically distribute plain text into table cells during a standard paste action. By leveraging a spreadsheet as an intermediary, you can perfectly format the data using delimiters (like commas, tabs, or equals signs).
Open Excel on your Mac and paste the raw, delimited text into the first column of a blank worksheet.
Highlight the column containing your pasted data, navigate to the Data tab on the ribbon, and click on 'Text to Columns'.
Choose the 'Delimited' option and click Next. Check the box for 'Other', enter the equals sign (=) or your specific delimiter character into the text field, and click Finish.
Highlight the newly created columns and rows in the spreadsheet that contain your split data, and copy them to your clipboard.
Open your Word document, select the exact number of corresponding destination cells in your table (e.g., select seven cells in a column if pasting seven rows), and paste the copied data.

Easily Format and Paste Table Data with WPS Office
WPS Office provides seamless integration between WPS Writer and WPS Spreadsheet. You can easily paste, delimit, and transfer tabular data across applications natively without losing your table formatting.
- 1. Paste text into WPS Spreadsheet: Open a new worksheet in WPS Spreadsheet and paste your delimited text into a single column.
- 2. Split text into columns: Select the pasted data, navigate to the Data tab, and click 'Text to Columns'. Choose 'Delimited' and specify your delimiter character.
- 3. Copy the formatted data: Highlight the newly separated rows and columns in the spreadsheet and copy them.
- 4. Paste into WPS Writer: Open your document in WPS Writer, highlight the destination cells within your table, and paste the data directly.

Frequently Asked Questions
Why does all my text paste into a single cell in a Word table?
This happens because the word processor interprets the copied text block as a single paragraph or unbroken string. Without converting the text to a table or formatting it in a spreadsheet first, Word doesn't know how to distribute it across different cells.
Can I convert text to a table directly in Word without using a spreadsheet?
Yes. You can paste the plain text directly into Word, select it, go to the Insert tab, click 'Table', and choose 'Convert Text to Table'. You can then specify your custom delimiter, such as an equals sign, under the 'Separate text at' option.
How do I ensure the data pastes into the exact columns I want?
Before pasting your spreadsheet data into Word, make sure to select the exact block of destination cells in your Word table. For example, if you are pasting two columns of data, click and drag to highlight those two columns in Word before executing the paste command.




