Text to Excel Converter: Import Text Into Columns

How-to basics · Updated November 18, 2026

A text to Excel converter turns a plain-text file or pasted text into worksheet cells. In Excel for Microsoft 365 on Windows, use Data > From Text/CSV to import a file, or select pasted text and choose Data > Text to Columns to split it; pick the correct delimiter and set sensitive columns, such as codes with leading zeros, to Text.

What a text to Excel converter does

“Text to Excel converter” can mean a feature that imports a .txt or .csv file, a tool that separates text already in a worksheet, or a website that changes a text file into an Excel workbook. The common goal is to turn a stream of characters into a table: each record becomes a row, and separators or fixed positions determine where one column ends and another begins.

For example, this line contains three fields separated by tabs: 1042[TAB]Mina Patel[TAB]North. A successful conversion puts 1042, Mina Patel, and North in separate cells on one row. A comma-separated file might instead contain 1042,Mina Patel,North. The right method depends on whether the text is in a file or already on the clipboard, and whether its structure is consistent.

Excel does not simply convert every text file into a well-organized table automatically. It has to infer or be told how fields are divided, how characters are encoded, and whether values should be treated as numbers, dates, or text. Checking those choices is the difference between a usable import and a spreadsheet that looks right but has silently changed important data.

Import a text or CSV file in Excel

For a saved file, importing through Excel’s data tools gives you more control than double-clicking a CSV. In Excel for Microsoft 365 on Windows, go to Data > Get & Transform Data > From Text/CSV, select the .txt or .csv file, and inspect the preview. Excel usually detects a delimiter, but verify that the preview shows the expected fields in separate columns before loading.

  1. Open the workbook where the imported data should go, then choose Data > Get & Transform Data > From Text/CSV.
  2. Select the source file. In the preview, check the delimiter, file origin or encoding, and the appearance of rows and columns.
  3. If the preview is correct and no special type handling is needed, choose Load. To review or change data types first, choose Transform Data.
  4. In the Power Query Editor, select columns that need special treatment and set their data type, such as Text. Then use Home > Close & Load to bring the result into Excel.

The exact dialog layout can vary with updates and file type. If a file uses tabs, semicolons, or another separator instead of commas, change the delimiter rather than accepting a misleading preview. A file saved with UTF-8 encoding may need the matching file origin selected so accented letters and other characters display correctly. If the preview shows replacement symbols or scrambled characters, check encoding before loading.

Excel for Mac also provides text and CSV import options on the Data tab, though the dialog and available controls can differ from Windows. Excel for the web has a different feature set and does not present every desktop import control in the same way. When exact encoding, type, or delimiter control matters, use the desktop version and inspect the imported result.

Split text already in a worksheet

If you have pasted a list into one column, use Text to Columns rather than importing a file again. Suppose column A contains 1042|Mina Patel|North in A2, with the same pipe character between fields in each row. Select the cells to split, choose Data > Text to Columns, choose Delimited, and select Other with the pipe character as the delimiter. Review the preview, choose a destination if you do not want to overwrite the source column, and finish the wizard.

For comma-, tab-, semicolon-, or space-separated data, select the corresponding delimiter in the wizard. The Text qualifier setting is useful for data such as 1042,"Patel, Mina",North: the comma inside the quoted name should not split that name into two fields. Check the preview carefully, because a delimiter that appears inside ordinary values can otherwise create extra columns. A space delimiter can be especially risky for names or addresses that contain spaces.

Choose Fixed width instead of Delimited when fields line up at consistent character positions rather than being separated by a symbol. In the wizard’s preview, add or move break lines to mark where each field ends. Fixed-width splitting works for consistently formatted reports, but is unreliable when names or descriptions vary in length and shift the later fields.

Text to Columns changes the selected worksheet cells; it is not the same as loading a source file through Power Query. Keep a copy of the original column, or set a separate destination, when the source must be preserved. On Mac, the command is also available through the Data tab in Excel, although the wizard’s appearance may differ by version.

Choose the right delimiter and data types

A delimiter is the character or character sequence that separates fields. Common choices include commas, tabs, semicolons, pipes, and sometimes spaces. The file’s extension does not guarantee its delimiter: a .txt file may be tab-separated, while a .csv file may use semicolons depending on how it was produced. Use the preview and, when necessary, open a copy in a plain-text editor to identify the actual separator.

Data type choices matter because Excel interprets values rather than merely storing their visible characters. A value such as 00127 may be treated as the number 127, losing its leading zeros. A code such as 3-4 might be interpreted as a date, and long digit strings may be displayed in scientific notation or lose precision if treated as numbers. These outcomes can damage identifiers even when the cells look tidy.

  • Keep identifiers as Text: account numbers, postal codes, product codes, and values with leading zeros are usually labels, not quantities.
  • Use numeric types for calculations: quantities and amounts that must be summed should be genuine numbers, not text that only looks numeric.
  • Check dates: dates can be ambiguous across regional conventions. For example, 04/05/2026 may mean April 5 or May 4, depending on the format used.
  • Check long numbers: Excel’s numeric precision is limited to 15 significant digits, so long identifiers should be imported as text.

For a one-time import, Text to Columns lets you choose a column format in the wizard before finishing. For a file import, use Transform Data and set the relevant column to Text before loading. If Excel has already converted a value and discarded leading zeros, applying a Text number format afterward cannot restore information that is no longer present; reimport the original source with the correct type.

CSV, TXT, and XLSX are not the same

A CSV file is plain text with fields separated by a delimiter, commonly commas. A TXT file is also plain text but can use tabs, fixed-width fields, or another layout. Neither format stores Excel features such as formulas, formatting, multiple worksheets, or column widths in the way an .xlsx workbook does. Once imported and checked, save a working copy as an Excel workbook with File > Save As and choose Excel Workbook (.xlsx) if you need those workbook features.

CSV conventions include quoting fields that contain delimiters or line breaks. A standards-aware importer can use quotation marks as text qualifiers so a comma inside a quoted field remains part of that field. Do not assume that replacing commas with tabs or splitting at every comma is safe: it can break quoted addresses, product descriptions, or other fields containing punctuation. If a source file is malformed or uses unusual quoting, correct the source or use an import process that handles its structure rather than forcing a simple split.

Also distinguish a file’s data from its presentation. A CSV does not preserve leading zeros as a display format, and it cannot retain an Excel formula as a formula in the same way an .xlsx file can. Excel may display a CSV using automatic type detection when it opens the file directly. Importing through the data tools gives you a chance to control interpretation, but the source text still determines what information is available.

Common conversion problems and fixes

When all text lands in one column, Excel probably selected the wrong delimiter or treated the file as a single field. Reopen the import preview or use Text to Columns, then select the separator shown in the source. When fields split too often, inspect whether the delimiter also occurs inside values and whether those values are quoted. Using a text qualifier or a more suitable import method can prevent unwanted splits.

Other frequent problems include garbled characters, dates that change order, leading zeros disappearing, blank rows, and unexpected spaces. Check encoding for character problems; check regional date conventions for dates; and import identifiers as text. If blank rows appear, inspect the original file for empty records. If values have extra spaces, you can clean them after import, but first determine whether the spaces are meaningful, such as part of a fixed-width field.

Large files have practical worksheet limits. A worksheet supports up to 1,048,576 rows and 16,384 columns, so a file exceeding those limits cannot fit on one sheet. Power Query can help shape and filter data before loading, but loading the full result to a worksheet still encounters worksheet capacity. For very large datasets, consider keeping the data in a database or another suitable data tool rather than trying to place every record in one sheet.

Built-in Excel tools, online converters, and costs

For ordinary delimited files, Excel’s built-in import and Text to Columns features are usually the simplest choices. They avoid uploading business or personal records to another service, and they let you check how fields are interpreted. Power Query is useful when the same cleanup must be repeated: it records transformation steps that can be refreshed against updated source data. This can save time for recurring reports, but it takes more setup than a one-off split.

Online converters may be convenient when Excel is unavailable or when a format needs a specialized conversion. Before using one, read its privacy and retention terms and consider whether the file contains names, financial details, health information, or confidential company data. Uploading a file sends it to a third party; do not assume that a converter deletes it immediately or keeps it private just because conversion is free.

There is no separate charge for using Excel’s text import tools when they are included in the Excel version or Microsoft 365 plan you already use. Access to desktop Excel itself depends on the license or subscription. Online services may be free, paid, or limited by file size and features, so check their current terms rather than assuming that every converter has the same price or privacy protections.

Frequently Asked Questions

How do I convert a text file to Excel without losing data?
In desktop Excel, use Data > Get & Transform Data > From Text/CSV, inspect the preview, and set identifiers or other sensitive columns to Text before loading. Check dates, leading zeros, long numbers, and unusual characters, then save a checked copy as .xlsx.

How do I separate text into columns in Excel?
Select the cells containing the text and choose Data > Text to Columns. Pick Delimited for values separated by a character such as a tab or pipe, or Fixed width when fields consistently occupy set positions. Confirm the preview and destination before finishing.

Can Excel convert a PDF or Word document into columns?
Not by treating either file as an ordinary .txt or .csv file. Copying text may work for a simple table, but layouts can shift and lose structure. For a PDF table, use an available PDF data import feature in your Excel version or extract the table with a suitable tool, then inspect the result; a scanned image may require optical character recognition.

Why did Excel remove the zeros at the start of my codes?
Excel interpreted the codes as numbers, and numeric values do not retain leading zeros as part of the stored number. Reimport the original data and set that column to Text before loading. Changing the cell format after the zeros have been discarded will not reconstruct them.

Can I convert text to Excel on a Mac?
Yes. Excel for Mac includes data import and Text to Columns tools, though the interface and available options can differ from Windows. Use the Data tab, inspect the import preview, and verify the resulting cells. For sensitive encoding or type decisions, use the desktop import controls available in your installed version rather than relying on automatic conversion.

Before you rely on the converted sheet

Compare a few output rows with the source, including the first and last records and any rows with commas, quotation marks, unusual characters, or empty fields. Confirm that the column headings match the data, that codes remain intact, and that numbers and dates behave as intended. Then save the result as .xlsx if it will be formatted, edited, or used with formulas. A careful preview and a brief check after loading are often more valuable than choosing a converter with extra features.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.