AI to Excel

When you paste a Word table into Excel, a cell that holds two lines splits into two rows, and the cell next to it comes in merged across both. The fix runs in Word, before the copy: replace the line breaks inside the table with a marker, paste, then turn the marker back into line breaks in Excel.

The numbers here come from a test on September 29, 2026, in Word 16.0.20326 and Excel 16.0 (build 20326) on Windows, run again on October 24, 2026 for the pictures with the same results. One 3-by-4 table was pasted three ways. A plain Ctrl+V produced 6 rows and 6 merged cells. Paste Special with Unicode Text produced 7 rows and no merged cells, but the second lines landed in the wrong column. Replacing the line breaks first produced 4 rows and no merged cells. One installation, one build, one table, two runs.

Keep the rows: swap the line breaks before you copy

To paste a Word table into Excel without the extra rows, the work happens in Word first. These steps come from an accepted answer on Microsoft Q&A, Copying from Word to Excel and retaining Line Breaks, posted June 30, 2021.

1. In Word, select the table. The replacement in this test ran inside the table’s range only.
2. Open Find and Replace. Find ^p, the paragraph mark, and replace it with @@. Run it again with ^l, the manual line break.
3. Copy the table and paste it into Excel.
4. In Excel, open Find and Replace, find @@, click in the Replace with box and press Ctrl+J.

In this test the paste landed in 4 rows with no merged cells, each two-line cell holding one value with @@ in the middle. After the replacement in Excel, cell B2 held two lines again. Excel kept the row heights it had after the paste, though, so in the October 24 run row 4 stayed one line tall and cut its two lines off until AutoFit Row Height (Home, then Format) made it taller.

Two of the steps above were not run by hand in this test. Word’s own Find and Replace dialog may ask whether to search the rest of the document after the table, and Ctrl+J in Excel’s Replace with box was not tested as a key press.

A formula in a spare column is the other route for step 4: =SUBSTITUTE(A1,"@@",CHAR(10)), where CHAR(10) is the line break. This test replaced the markers with Excel’s own Find and Replace, not with the formula.

A 3-by-4 Word table into Excel landed in 6 rows

The test table had 3 columns and 4 rows. Three of its cells held two lines each, and the rest held one line.

Pasting that Word table into Excel with a plain Ctrl+V produced six rows. Each two-line cell split into two rows, and the one-line cells in those rows came in merged to cover the split. The merged ranges were A2:A3, A5:A6 and C5:C6: three ranges, six cells in all.

The merging is what covers the split. A row that only exists because the cell beside it broke in two has nothing of its own to hold, so the one-line cell spans both rows instead. Word’s second row held two of the multiline cells, so only column A was merged there; its fourth row held one, so columns A and C were both merged.

How it was pasted	Rows in Excel	Merged cells
Ctrl+V	6	6
Paste Special, Unicode Text	7	0
Markers in Word first, then Ctrl+V	4	0

What that means on the sheet: one record from the Word table now occupies two rows, and the cell beside it is a single cell covering both of those rows.

Enter and Shift+Enter did the same thing

The two-line cells were not made the same way. Cell B2 held two paragraphs made with Enter, cell C2 held two lines made with Shift+Enter, and cell B4 held two paragraphs again. All three split into two rows in Excel.

So the split does not depend on which line break is in the cell. That is why step 2 above replaces ^p and ^l in two passes. Microsoft’s help page for this task mentions the extra rows in one sentence about extra carriage returns, quoted further down.

Pasting as Unicode Text was worse, not better

Paste Special is the obvious next thing to try, because dropping the formatting sounds like it would drop the merging too. It did. Paste Special with Unicode Text produced 7 rows and no merged cells at all. In Excel that option sits under Home, then Paste, then Paste Special.

The table came apart instead. The second line of each multiline cell moved into column A, at A3, A4 and A7, rather than staying under the column it came from. Losing the merged cells cost the column alignment.

Neither paste route in this test put the Word table into Excel in four rows. What changed the outcome was the text in the Word document, not the paste format.

What the help page promises, and where it stops

Microsoft’s Copy a Word table into Excel page says: “Excel pastes the contents of each Word table cell into a single cell.” In this test the one-line cells did arrive that way, one cell each. The three two-line cells did not.

The page’s one line about rows is a warning before you copy: “Make sure there aren’t any extra carriage returns in the cells of the table, otherwise this may cause extra rows in Excel.” That sentence covers the extra rows.

The word merge does not appear on the page, so the merged cells that come with those rows are not described there. The Applies to list runs from Excel and Word for Microsoft 365 back to Excel and Word 2016, and the page shows no last-updated date; the test here covers one build.

A table copied out of ChatGPT or another AI chat is a different case. It arrives as text rather than as a Word table object, and what breaks there is the values rather than the rows, as in when a ChatGPT table pasted into Excel changes your numbers. The opposite direction, an Excel table that runs past the margin once it is in Word, is its own test: when an Excel table pasted into Word runs off the page.

How this was tested, and what wasn’t

The pastes first ran on September 29, 2026, at 11:32 Korea time, in Word 16.0.20326 and Excel 16.0 (build 20326) for Windows, with a Korean interface and Korean text in the table. They ran again on October 24, 2026, at 23:13 Korea time, for the pictures: the same build and the same Korean installation, but with the display language set to English and the same table written in English words. Both runs gave the same row counts, the same merged ranges and the same cell positions.

For the pictures, columns A to C were widened before each paste so the words fit. A run at the default column width a few minutes earlier gave the same rows, merged ranges and cell positions.

The Ctrl+V result was a real key press into the visible Excel window, with the window in front. The same paste through Excel’s automation interface gave the same six rows and the same merged cells. Paste Special and the Word replacement ran through that interface. In the October 24 run the marker paste was a real Ctrl+V as well, and the replacement in Excel and the row AutoFit ran through the automation interface.

There was one table, 3 columns by 4 rows, pasted into a new workbook at cell A1. It had no merged cells of its own, so a Word table that already contains merged cells may land differently.

Not tested:

• A Word table that already has merged cells
• Excel for Mac, Excel for the web and Google Sheets
• An English-language Office installation
• Find and Replace run by hand in Word’s dialog
• Ctrl+J typed into Excel’s Replace with box
• AutoFit Row Height chosen from the menu by hand
• The SUBSTITUTE formula route
• Pressing Ctrl+M after the paste
• Several tables pasted in one go
• What merged cells do to sorting and filtering

One thing to expect after the markers go back to line breaks: Excel switched line wrapping on for those cells by itself, but it did not change the row heights. These results are one installation, one build, one 3-by-4 table and three pastes, recorded on September 29, 2026 and repeated on October 24, 2026.

To paste multiple lines into one Excel cell, open the cell before you paste: click it, press F2, then press Ctrl+V and Enter. Click the cell once and paste without opening it, and Excel reads every line break as a new row, so the lines land in separate cells going down the column.

On September 28, 2026, the same three lines went into Excel 16.0 (build 20326) on Windows four ways. Two put all three lines in one cell and two split them across three rows, and one of the two that split was Paste Special with Unicode Text. A real ChatGPT answer, pasted into a selected cell, took up 64 rows. The numbers below come from one installation, one build, one day, and one copied answer each from ChatGPT and Gemini.

Two ways to paste multiple lines into one Excel cell

Both ways to paste multiple lines into one Excel cell do the same thing: they put the cell into edit mode before the clipboard arrives.

1. Click the cell once, press F2, then press Ctrl+V and Enter.
2. Click the cell once, click in the formula bar, then press Ctrl+V and Enter.

In this test both pastes put all three lines inside cell A1, one with the text open in the cell and one with it open in the formula bar. Excel also switched the cell’s line wrapping on by itself and set the row height to 49.5, so the three lines were visible without any formatting afterwards.

Here is what the four pastes did with the same clipboard.

How the lines were pasted	Where they landed
Cell selected, then Ctrl+V	Three rows: A1, A2, A3
Paste Special, Unicode Text	Three rows: A1, A2, A3
F2 first, then Ctrl+V	One cell: A1, three wrapped lines
Text open in the formula bar, then Ctrl+V	One cell: A1, three wrapped lines

The first row ran twice, once with LF line breaks on the clipboard and once with CRLF. Both split the same way.

Paste Special did not keep the lines in one cell

Paste Special is the next place to look, because it offers to drop the formatting and bring the clipboard in as plain text. In this test that changed nothing. Paste Special with Unicode Text put the three lines in A1, A2 and A3, the same cells a plain Ctrl+V used. In Excel that option sits under Home, then Paste, then Paste Special.

That result narrows the problem down. The split is not coming from the paste format, so no paste option fixes it. To paste multiple lines into one Excel cell, the thing to change is the cursor, not the format.

There is one other approach, which is to replace every line break in the text with a space before pasting. That does keep the text in one cell, by throwing the line breaks away. This test did not cover it.

Why a selected cell turns each line into a row

A selected cell tells Excel where to start putting rows. An open cell tells Excel where to put characters. With the cell selected, a line break in the clipboard means the next row, the way a tab means the next column. With the cell open, the same line break is one more character going into that cell.

Microsoft’s Edit cell contents page describes three ways into that open state, which it calls Edit mode: “Select the cell that contains the data you want to edit, and then press F2,” double-clicking the cell, or selecting anywhere in the formula bar. Whether the text then opens inside the cell or in the formula bar is set by the Allow editing directly in cells checkbox, under File, Options, Advanced. That page applies to Excel for Microsoft 365, Excel 2024 and Excel 2021.

The page is about editing, not about pasting, and it does not say what a paste into Edit mode does. That part is this test’s own result. To type a line break by hand instead of pasting one, the key is Alt+Enter.

One real ChatGPT answer landed in 64 rows

Three short lines are the easy case. The test also pasted two real AI answers into a selected cell, taken from the copy button in ChatGPT and in Gemini on September 19, 2026.

What was pasted	Rows used	Empty rows
One ChatGPT answer, Ctrl+V	64	25
The same answer, Unicode Text	61	17
One Gemini answer, Ctrl+V	31	2
The same answer, Unicode Text	57	20

Not one cell in those pastes held a line break. Every line went to its own row, and the empty rows are the blank lines between paragraphs in the answer. Changing the paste format changed how many empty rows appeared; it did not gather the lines into a cell either way. This test did not paste an AI answer into an open cell, so what a whole answer does in Edit mode is not measured here.

Pasted as Unicode Text, the Markdown in the answers came through as characters: asterisks around the bold words, hash marks in front of the headings, pipes between the table cells. The Markdown Remover takes those symbols out of copied AI text in the browser. It does not put the lines back into one cell, so for that part the answer is still to open the cell first.

A line break inside a table cell has a related edge. In a separate paste of a small HTML table built for this test, one cell carried its own line break. Excel put that cell’s two lines in two rows, B2 and B3, and left the rest of the table on its own row, so the columns no longer lined up. That did not happen with the two AI answers above, whose cells held no line breaks at all.

If what went wrong is the values rather than the layout, a leading zero gone or a size turned into a date, that is a different problem: see when a ChatGPT table pasted into Excel changes your numbers.

If the lines already landed in separate rows

If the text is still on the clipboard, the short way back is to clear those cells and paste multiple lines into one Excel cell again with F2. The formula below is for when the clipboard has moved on:

=TEXTJOIN(CHAR(10), TRUE, A1:A3)

CHAR(10) is the line break, and TRUE is the ignore_empty argument, which Microsoft’s TEXTJOIN function page describes as “If TRUE, ignores empty cells.” That page applies to Excel for Microsoft 365, Excel 2024 and Excel 2021, each of those also for Mac, plus Excel 2019 and Microsoft365.com. Excel 2016 is not on the list. For that version the same join is =A1&CHAR(10)&A2&CHAR(10)&A3. It produced the same cell contents in this test.

Then comes the part that looks like a broken formula. The join is correct, but the result showed as one long line, because Wrap Text did not switch on by itself the way it did after the F2 paste. The row height stayed at 16.5.

Turn Wrap Text on for that cell and fit the row height, and the three lines appear. Here the row went to 49.5.

The joined cell is a formula, so it empties when the cells it reads are deleted. Copy it and paste it back as values first. In this test the pasted-value copy still held all three lines after A1 to A3 were cleared.

How this was tested, and what wasn’t

The pastes ran on September 28, 2026, in Excel 16.0 (build 20326) for Windows. The installation’s interface is Korean and the test text is Korean too. In the pictures the three lines are a street address, and the point is where the lines landed. The pictures were made on September 30 in the same Excel: the picture of the split rows is an actual paste, and the other three reproduce the cell states the test recorded.

Two of the four pastes were real key presses into the visible Excel window, the F2 paste and the formula bar paste. The formula bar paste was run by turning off Allow editing directly in cells and pressing F2, which opens the text in the formula bar. Clicking in the formula bar with the mouse was not tested.

The selected-cell paste and Paste Special went through Excel’s automation interface, taken to be the same path a Ctrl+V uses. The AI answers were one copied answer each, so a different answer gives a different number of rows.

Not tested:

• Double-clicking a cell instead of pressing F2, which Microsoft lists as the same Edit mode
• Clicking in the formula bar with the mouse, the third route Microsoft lists
• Excel for Mac, Excel for the web and Google Sheets
• Excel 2016 and Excel 2019
• Pasting a whole AI answer into an open cell
• A key-pressed Ctrl+V into a selected cell
• An English-language Excel installation

The gap worth keeping in mind runs between the two halves of this test: a cell opened with F2 came back with its line wrapping already on, and a cell filled by a formula did not. Both results are from one installation on one day, four pastes, and one copied answer each from ChatGPT and Gemini.

When you ask ChatGPT for an Excel file, the download is only half the job. In this test the answer came back with a file card, and the preview pane that opened before the download showed the employee ID as 7 instead of 007, the phone number without its leading zero, and a 16-digit order number as 1.23457E+15. The file looked broken before it had been saved.

The thing to judge is the downloaded file, not the pane. On October 3, 2026 the same table went to ChatGPT, Claude and Gemini once each, and all three returned an .xlsx on the first request. Opened in Excel, all 24 cells in all three files held what was expected: 007 stayed text, the order numbers kept all 16 digits, the hire dates arrived as date values. That was one table, one request each, three paid or work accounts, and a table written in Korean. The values that did change came from the paths that were not a file.

When you ask ChatGPT for an Excel file, check these five cells

Open the download and read these cells before anything else. They are the cells where the tool had to make a format decision, and they are what this test measured.

1. Cells with a leading zero: employee IDs such as 007 and 0123, and a phone number written as 01098765432.
2. Cells that can be read as a month and a day, such as 1-2 or 3-4. They should still be those characters.
3. Reference numbers of 16 digits. Excel holds numbers to 15 digits, so check the last one.
4. Cells that start with an equals sign. They should be words, not a formula and not an error.
5. Cells that hold two lines. The break belongs inside the one cell.

Then look the other way. Hire dates, salary amounts and percentage rates should be values rather than text, because those are the cells that get sorted and added up.

A file carries the format along with the value, so each cell arrives labeled as text, a date or a number. A table moved off the screen carries only what the screen showed, and the receiving program guesses again. A pane that looks wrong is not a reason to delete the file and ask again.

All 24 cells in the three downloaded files were as expected

The one thing to read from this table: all three files held 007 as text and kept every digit of the order numbers.

Tool	Account tested	24 cells
ChatGPT	Pro	All 24 as expected
Claude	Max	All 24 as expected
Gemini	Google Workspace work account	All 24 as expected

That is one request per service, sent once on October 3, 2026, against one table of three rows and eight columns. The free plans were not tested.

ChatGPT’s answer said it had handled the ID, phone, order number and note columns so they would not be auto-converted, and had given the hire date, salary and performance rate columns an Excel format. Claude’s answer listed the columns it had kept as text and noted that 8% would display as 8.0%. Gemini’s answer added an average row at the bottom that the request had not asked for; the 24 cells were unaffected by it, and that is what Gemini did in this run.

The preview pane showed different values than the file

The pane that opens when you ask ChatGPT for an Excel file and click the file card, before the download, is not the file. In this test it showed the employee IDs as 7 and 123, the phone number as 1098765432 and the order number as 1.23457E+15. The downloaded file held 007, 0123, 01098765432 and all 16 digits, every one of them as text.

Why the pane displayed those values was not tested. It is a viewer, so download the file and read the cells in Excel.

Sending the same table to Google Sheets changed six or seven cells

The two paths below started from a different request. Instead of a file, it asked for the table to be shown as a table on screen, and that table was then moved into Google Sheets. Each path ran once, on October 4, 2026.

Exporting Gemini’s table with Export to Sheets changed 7 of the 24 cells. The leading zeros went first: 007 became 7, 0123 became 123, and the phone number lost its leading zero. Then 1-2 and 3-4 became date values, the note starting with an equals sign turned into an error, and the two lines in one cell were joined into one. That error reads #ERROR! on the Sheets screen; download the same sheet as .xlsx, open it in Excel, and the cell reads #NAME? instead.

Copying the ChatGPT answer with the button under it and pasting into a new Google Sheet changed 6 of the 24 cells, the same ones. Two things survived that path: the two lines stayed inside one cell, and the columns split correctly instead of landing in a single column.

When you ask ChatGPT for an Excel file, the format travels with the value; both paths above started from a table on the screen instead.

If you are copying an answer’s text instead, the Markdown Remover has a Copy table for Excel button that turns Markdown table rows into tab-separated cells. It does not stop a spreadsheet’s conversions, so the five cells above still need a look.

How this was tested, and what was not

The three requests went out between 10:04 and 10:06 p.m. Korea time on October 3, 2026, in Chrome on one Windows PC. The accounts were ChatGPT Pro, Claude Max and a Gemini Google Workspace work account. ChatGPT showed no model name and the reasoning setting in its composer read High, left at the default; Claude ran Opus 5.5; Gemini’s model selector was on its thinking model, also left at the default. Claude’s code execution and file creation setting was already on and was not changed. Each service got a new conversation with the same request pasted once, and no follow-up.

The three files were 5,213, 5,600 and 5,800 bytes, each with a Korean file name. They were read with Excel 16.0 build 20326 on a Korean (ko-KR) installation, and each of the 24 cells was compared against its stored value, its displayed value and its number format.

The evidence is Korean. The request, the header row, the names and the notes in the test table are Korean, the Excel install is Korean, and all four pictures show Korean text. The cells being checked do not depend on the language, but the test was not repeated with an English table or an English installation of Excel.

Two official pages sit next to this test without being part of it. Anthropic’s Create and edit files with Claude page says code execution and file creation is available to all Claude users, Free through Enterprise, and lists .xlsx among the formats Claude can create; the page is marked Last Updated August 6, 2026, and it was checked again on October 9, 2026. Google’s file generation announcement for the Gemini app, dated April 29, 2026, lists XLSX among the formats and says the feature is available to all Gemini app users globally.

Those are statements of availability, not results. For ChatGPT, no official page on downloads by plan was checked, so the only claim made about it here is that the account used was Pro.

Not tested:

• What a free account returns when you ask ChatGPT for an Excel file
• Failed downloads and broken file links
• The same request sent again, or a different table
• An English table, or an English installation of Excel
• Excel for Mac, Excel for the web, Numbers, and opening the files in Google Sheets
• Pasting an answer’s text straight into Excel
• Why the preview pane displayed different values

One run is not a general advantage. The request used here said nothing about formatting; it asked for the table as an .xlsx that could be downloaded. Each of the three answers still said which columns it had protected from auto-conversion and which ones it had given an Excel format. The next time you ask ChatGPT for an Excel file, that list is the short version of which cells the tool decided something about. These results are one table, one request, three paid or work accounts, October 3, 2026.

You paste a ChatGPT table into Excel and some values are no longer what ChatGPT wrote. Employee ID 007 becomes 7, a ZIP code loses its leading zero, a size like 3-4 turns into a date, and a 16-digit order number shows up as 1.23457E+15.

The fix is to set the columns to Text before you paste the ChatGPT table into Excel. If you’ve already pasted, changing the format afterwards won’t bring the values back, so paste again into the Text columns. ChatGPT didn’t change anything. The copied text still had every value exactly as it appeared in the chat; Excel converted them as it read the paste.

Before you paste a ChatGPT table into Excel, set the columns to Text

1. Select the columns you’re about to paste into by clicking their letters, for example A to F.
2. On the Home tab, open the number format list (it usually says General) and choose Text.
3. Click the first cell and paste.

With the columns set to Text, every value in this test came through unchanged: 007, 02134, 3-4, all 16 digits of 1234567812345678, and =manager pick as plain words. Microsoft’s Stop automatically changing numbers to dates page gives the same advice: preformat the cells as Text.

Excel marks the number-like cells with a small green triangle, its flag for a number stored as text. Here that’s the point: employee IDs and ZIP codes are labels, not amounts.

Already pasted? Changing the format won’t bring zeros back

Once a value has been converted, the original text is gone from the cell. In this test, switching the pasted columns to Text afterwards left 7, 2134 and 1.23457E+15 exactly as they were. The sizes turned into plain numbers like 46085, which is how Excel stores the date March 4, 2026.

What did work: leave those columns as Text and paste the same copied table again over the top. Every value came back as ChatGPT wrote it. If the table isn’t on your clipboard anymore, copy it from the chat again first.

For one or two cells, typing an apostrophe before the value also keeps it as text. In an earlier test on the same PC, that worked for a value entered into a cell, but an apostrophe inside the pasted text stayed visible in the cell.

What happens when you paste a ChatGPT table into Excel

Here is the test table after a normal paste into a new workbook, where every column starts as General.

In the ChatGPT table	After a normal paste	What Excel did
007, 0123, 0456	7, 123, 456	Read them as numbers, dropped the leading zeros
ZIP codes 02134, 07030	2134, 7030	Same
Sizes 3-4, 6-8, 10-12	Dates: March 4, June 8, October 12	Read them as month and day
1234567812345678	1.23457E+15, stored as 1234567812345670	Kept 15 digits
=manager pick	#NAME?	Read it as a formula
+1 call back, -50% off	Unchanged	Left them as text

The order numbers are the change people miss. Excel keeps numbers to 15 digits, so the 16th digit of each order number became 0. Microsoft explains this limit on its Keeping leading zeros and large numbers page. A widened column doesn’t help, because the digit is already gone.

The sizes became dates in the current year. On US English Excel, Microsoft’s own examples show how such entries look: 12/2 becomes 2-Dec, and 3/4 becomes 4-Mar.

Only one note turned into an error. A note starting with = was read as a formula, while the ones starting with + and – stayed as text in this test.

Where the copied table comes from

ChatGPT showed two copy buttons in this test: one at the top right of the table and one under the answer. Both put the same tab-separated text on the clipboard, one value per cell, exactly as shown in the chat. The changes happened inside Excel. A separate test asked for an .xlsx file instead of a copy and checked all 24 cells in the downloaded files.

Copied text doesn’t always arrive like this. In a separate session signed in to ChatGPT in Chrome, the copy button under an answer also carried a formatted version of the table. That copy wasn’t tested in Excel.

If copying a ChatGPT table into Excel gives you lines of | characters in a single column, it was copied as Markdown. The Markdown Remover has a Copy table for Excel button that turns those lines into the same tab-separated rows. It doesn’t stop Excel’s conversions, so set the columns to Text first either way.

Excel’s Automatic Data Conversion options

Microsoft documents options in Excel that change some of these defaults: removing leading zeros, cutting long numbers to 15 digits, and turning some runs of letters and numbers into dates. They’re described on the same Keeping leading zeros and large numbers page. This test didn’t change them, so the results above are Excel’s default behavior.

How this was tested, and what wasn’t

The test ran on October 5, 2026, with Excel 16.0 (build 20326) for Windows. The Windows regional format was set to English (United States) for the test. The table came from ChatGPT used without signing in, in a Chromium-based browser. The copied text was pasted into a new workbook at cell A1 by automation, the same text a Ctrl+V pastes; no key was pressed.

This Office installation is Korean, with an English interface. Under the US format Excel stored 3-4 as March 4, but it displayed converted dates in Korean, so the Size column is hidden in the default-paste picture. The pictures are renders of the cells, not screenshots of the Excel window.

Not tested:

• Excel for Mac and Excel for the web
• Google Sheets (a separate test on October 4 with a different table showed the same kinds of changes)
• The signed-in ChatGPT copy that includes formatting
• Excel’s Automatic Data Conversion options

These results come from one table on one PC. Before you paste a ChatGPT table into Excel next time, look for columns of IDs, ZIP codes or long reference numbers. Those are the ones to set to Text.

Pasting several lines of text into one cell instead? Excel can split the lines across rows; one test recorded what four ways of pasting did.