Excel Keeps Doing Text to Columns? Causes and Fixes

Errors & fixes · Updated November 19, 2026

Excel does not normally rerun Text to Columns on its own. If data keeps splitting, a CSV or text import, pasted tabs or delimiters, a macro, or a Power Query refresh is usually causing it; identify the trigger, then change that source or its import settings.

What Text to Columns does—and what it does not do

Text to Columns is a command that takes selected cells and separates their contents into neighboring columns. In Excel for Microsoft 365 on Windows, select the cells and choose Data > Text to Columns. The wizard asks whether to split at a delimiter, such as a comma or tab, or at fixed character positions. You then choose how the resulting columns should be interpreted and where to put them.

The command is not a background setting that keeps watching a worksheet. Once the wizard finishes, the values are split; Excel does not ordinarily repeat that action every time you edit the sheet. When a split happens again, look for an operation that is repeating the import or paste, or check whether you are seeing data that was already separated in the source.

One important distinction: Excel may separate fields when it opens a CSV file, but that is part of interpreting the file’s delimiter-separated format. It does not necessarily mean that the Text to Columns wizard ran. Knowing whether the problem happens while opening, importing, pasting, or refreshing is the fastest way to choose the right fix.

Find out when the splitting happens

Start with a small, controlled check. Note whether the columns split as soon as you open a file, immediately after pasting, only after refreshing a report, or after running a particular workbook action. If possible, try the same data in a blank workbook. That helps distinguish a workbook-specific process from Excel’s handling of the source file.

  • Only when opening a .csv file: Excel is likely parsing the file’s separators. Check the import method and delimiter.
  • Only after copying from a website, email, or another spreadsheet: the copied content may contain tabs or other separators.
  • After clicking Refresh or opening the workbook: inspect Power Query connections, workbook macros, and other automated import steps.
  • Every time you type or edit a cell: this is not normal Text to Columns behavior. Check for a macro, add-in, or a misunderstanding about how the data is displayed.

Also check whether the source is actually one cell. Click a value and look at the formula bar, then inspect adjacent cells. If the content is already in separate cells there, Excel has not necessarily just split it; the source may have been imported that way, or the columns may have been hidden or formatted in a confusing way.

Stop CSV and text files from splitting unexpectedly

A CSV file stores fields separated by a character, commonly a comma. When you open one directly in Excel, Excel interprets those separators and places fields into separate columns. That is expected for a normal CSV, but it can look wrong if you wanted each complete line to remain in one cell or if the file uses a different separator than Excel expects.

For more control, import the file rather than relying on a direct open. In Excel for Microsoft 365 on Windows, choose Data > From Text/CSV, select the file, and inspect the preview and delimiter before loading it. Choose the delimiter that matches the file—such as comma, semicolon, or tab. If the preview is wrong, do not load it yet; change the delimiter and confirm that fields land in the intended columns.

Excel’s interpretation can also be affected by regional settings. For example, a file created with comma separators may not behave as expected in a setup that commonly uses semicolons as list separators, or vice versa. Do not change Windows regional settings as a first fix: that can affect other programs and files. Instead, use the import preview to select the actual separator used by this particular file.

If you need to inspect each raw CSV line as a single value, use a text-import route that lets you leave delimiter boxes unchecked, where available, rather than opening the .csv directly. Keep an untouched copy of the original file. A CSV is plain text, so a text editor can also help confirm whether the source uses commas, semicolons, tabs, or quoted fields before you import it.

Check tabs and delimiters in pasted data

Copying content from a web page, an email, or another program often puts tab characters between fields. When you paste that content into Excel, Excel can place tab-separated items in adjacent cells. This is normal paste behavior, not a persistent Text to Columns setting. Commas inside ordinary text do not always trigger a split on a basic paste, but the source application or the way the content was copied can change what reaches the clipboard.

To test this, paste the content into a plain-text editor first. If the lines visibly contain tabs or separators between values, the split is already present in the copied material. You can also paste into a single cell using the formula bar, which is useful for a small amount of text, or use Excel’s paste options to choose a different paste type when one is offered. These approaches do not replace a proper import for large datasets.

If you need to keep a tab-delimited line intact, import it as text with no delimiter selected, where the available import workflow allows that, or change the source so it does not place tabs between the values. Simply undoing the paste will remove that paste, but it will not change the source or prevent the same behavior the next time you copy the content.

Review Text to Columns settings and destination

If you are deliberately using Data > Text to Columns, revisit the wizard rather than assuming it has saved a rule for the whole workbook. In the Delimited option, check every selected separator: Tab, Comma, Semicolon, Space, or Other. A selection you did not intend can create extra columns. In the Fixed width option, review the preview’s break lines and remove any unwanted breaks.

The destination matters too. By default, Excel may put the output beside the selected data. If those cells contain information, the operation can overwrite it or produce an error. Choose an empty destination when you need to preserve the original values, or copy the source to a safe area first. Text to Columns changes the selected data; it is not a reversible display setting.

For values such as product codes, postal codes, or identifiers with leading zeros, check the column data format in the final wizard step. Choosing Text can preserve values like 00427 as text instead of converting them to the number 427. This is a data-preservation issue rather than an automatic splitting issue, but it commonly appears during the same workflow.

Look for macros, Power Query, and refreshes

If the split returns after you refresh data or reopen a particular workbook, inspect its automated processes. Power Query can split a column as part of a repeatable transformation. Choose Data > Queries & Connections, open the relevant query, and review its Applied Steps for a split-column operation. If that step is not wanted, edit or remove it in the query editor, then refresh and verify the preview before loading the results.

A VBA macro can also change cells or run data-cleaning actions when a workbook opens or a button is clicked. If the behavior occurs only in a macro-enabled workbook, test a copy with macros disabled and see whether the split stops. Do not delete code or disable security protections indiscriminately; first confirm the workbook’s source and whether the automation is needed. Excel add-ins can also alter data, so a controlled check with the workbook and add-ins isolated may help identify the cause.

Power Query and macros differ from the Text to Columns command: they can repeat an operation because a query is refreshed or code runs again. If an automated split is correct for some files but not others, adjust the transformation or macro to match the incoming data format rather than repeatedly repairing the worksheet by hand.

Repair a split that has already happened

If the split just occurred and no other action has followed it, use Ctrl+Z on Windows to undo. On Mac, use Command+Z. Undo is most useful immediately; after more edits, saves, or refresh operations, it may not restore the exact earlier state. For important data, restore from a backup or reopen an unchanged source instead of guessing how to recombine fields.

If you must rebuild a single text value from adjacent columns, do it in a separate empty column and verify the result before replacing anything. The right method depends on the content: adding a space between first and last names is not appropriate for codes or comma-separated addresses, and values that contain the separator themselves need special care. Keep the original columns until you have checked several rows, including blanks and entries with unusual punctuation.

For recurring work, fix the earliest step that introduces the split. Correcting the import delimiter, removing an unwanted query transformation, or changing the copy source is more reliable than recombining the columns after every run. Save a backup before bulk changes, especially if the data contains identifiers or values that Excel may convert automatically.

Excel for Mac and Excel for the web

The Windows instructions above use Microsoft 365 desktop menus. Excel for Mac also has a Text to Columns command on the Data tab, although import dialogs and some options can differ by version. If you cannot find the same import control, use the Mac app’s Data tab and inspect the available text or CSV import choices before loading the file. A menu name or import preview may not match Windows exactly.

Excel for the web has a smaller set of desktop import and automation controls. If a workbook’s split appears connected to a query, macro, or import option that is unavailable in the browser, open the workbook in the desktop app and investigate there. Workbook formulas and existing data can still display in the browser, so seeing split columns online does not by itself show that the web app performed Text to Columns.

Frequently Asked Questions

Why does Excel split my CSV into columns when I open it?

Excel reads the separator in a CSV and places fields into columns, which is usually the intended behavior. If the result is wrong, import through Data > From Text/CSV and choose the delimiter shown by the file’s format.

Can I turn off Text to Columns permanently?

There is no general background Text to Columns switch to turn off, because the command does not normally run by itself. Find the repeated trigger instead: direct CSV opening, pasted tabs, a query refresh, a macro, or an add-in.

Why does Excel split text when I paste it?

The copied content may contain tab characters between fields, which Excel treats as column boundaries during a paste. Check the content in a plain-text editor or copy a small sample to identify whether the source includes tabs or another structure.

How do I keep a CSV row in one Excel cell?

Do not open the CSV directly if you need its full line as one value. Use a text-import workflow that allows you to leave delimiters unchecked, and confirm the preview before loading. Preserve an original copy so you can retry without changing the source.

Why does the split come back after I refresh?

A Power Query step or other automated process may be splitting the incoming data again on each refresh. Review the query’s Applied Steps or check for workbook macros, then change the repeatable process rather than repairing its output each time.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.