Informational guide

How to Convert TXT to CSV: 6 Reliable Methods

Converting a text file to CSV sounds trivial until a column shifts, a name with a comma splits into two, or Excel swallows your leading zeros. The format is simple. The mistakes are predictable. This guide covers six methods, from a one-click browser tool to a scripted pipeline, and it tells you which one fits the file in front of you.

What is the fastest way to convert TXT to CSV?

The fastest way is a browser-based converter: paste the text, pick the separator, download the CSV. No install, no upload, no spreadsheet quirks. Our TXT to CSV converter auto-detects whether your file is tab, comma, semicolon or space separated, shows a live table preview, and handles the quoting rules for you.

Use this method when you have a single file and you want a clean result in seconds. It runs on your device, so the data stays local. For repeated jobs across many files, a script is the better tool, and that is covered further down.

What actually separates TXT from CSV?

A TXT file is unstructured. A CSV file is a table where each line is a row and a chosen character, usually a comma, separates the columns. The rules that make a CSV reliable come from RFC 4180, the specification most software follows. Two of those rules cause almost every real problem.

First, any field that contains the separator, a double quote, or a line break must be wrapped in double quotes. Second, a double quote inside a quoted field is written twice. So Smith, John becomes "Smith, John" and 5" pipe becomes "5"" pipe". A converter that ignores this will break the moment your data contains a comma. You can read the exact rules in the official specification from the IETF.

Method 1: Convert TXT to CSV in the browser

Paste your text into the left pane of the converter. Leave the separator on Auto-detect for a first pass. The right pane shows the parsed table immediately, so you can see whether the columns landed correctly before you download anything.

If a column looks wrong, switch the separator manually. Tab and semicolon are the two most common surprises in exported files. Tick Header row if your first line holds column names, then download. The output is UTF-8 with a byte order mark, which is the version Excel reads without mangling accented characters.

Method 2: Convert TXT to CSV in Excel

Do not double-click the text file and hope. Open Excel, go to Data, then From Text/CSV, and select your file. Excel shows a preview with a delimiter dropdown. Choose the right separator, set any code-heavy column to Text so leading zeros survive, then load.

This route respects your data types. Opening a raw file directly lets Excel guess, and its guesses turn 007 into 7 and long account numbers into scientific notation. Microsoft documents the import flow on Microsoft Learn. For a full walkthrough with the zero-loss settings, see convert TXT to CSV in Excel.

Method 3: Convert TXT to CSV in Notepad++

Notepad++ is useful when the file is nearly a CSV and needs a find-and-replace pass. Open the file, press Ctrl+H, enable Regular expression mode, and replace your current separator with a comma. To turn runs of whitespace into a single comma, search for \s{2,} and replace with ,.

Save the file with a .csv extension. This method gives you control over messy, inconsistent spacing that a fixed delimiter cannot handle. It does not add quoting, so use it only when your values contain no commas.

Method 4: Convert TXT to CSV with Python and pandas

For anything you will repeat, a few lines of Python beats manual work.

import pandas as pd

# whitespace-separated input, no header in the source
df = pd.read_csv("input.txt", sep=r"\s+", header=None)
df.to_csv("output.csv", index=False)

read_csv handles the parsing and to_csv writes a compliant file with correct quoting, so a value like Smith, John is quoted automatically. Change sep to "\t" for tab-separated data or ";" for semicolons. The full pattern, including how to set column names and handle encodings, is in the Python and pandas guide. The official reference lives in the pandas documentation.

Method 5: Convert TXT to CSV in PowerShell

PowerShell is built for this on Windows and needs no extra install.

Import-Csv input.txt -Delimiter "`t" |
  Export-Csv output.csv -NoTypeInformation -Encoding UTF8

Import-Csv reads the tab-delimited text into objects, and Export-Csv writes a properly quoted comma file. Swap the delimiter for whatever your source uses. This scales cleanly to a folder of files with a Get-ChildItem loop, which makes it a solid choice for batch jobs on a server.

Method 6: Convert TXT to CSV in Google Sheets

Open a blank sheet, go to File, then Import, and upload the text file. Sheets asks for the separator type and previews the result. Once it looks right, go to File, then Download, and choose Comma-separated values.

This is handy when you are already working in Sheets or need to share the result with a team. The trade-off is the round trip through a browser upload, so avoid it for confidential data.

Which method should you use?

The three errors that ruin a conversion

Most broken CSVs trace back to the same trio. Values with commas that were never quoted, which shifts every later column. A separator mismatch between the file and the program reading it, which piles everything into one column. And an encoding clash, where UTF-8 text without a byte order mark shows up as garbled characters in Excel.

A converter that quotes correctly and exports UTF-8 with a BOM removes all three. That is exactly what the browser tool does, and it is why a quick paste often beats a manual fix.

Next steps

Start with the free converter for a one-off file. If you convert text regularly, save the Python or PowerShell snippet above. And when you need to reverse the process, the CSV to TXT converter turns a comma file back into tab or custom-delimited text.