Convert TXT to CSV with one row for each non-empty line

Choose a plain .txt list below. Every non-empty line becomes one cell in a CSV column named Text; review the preview before downloading your table.

Drop a file here

or click to choose a file

Files stay on your device — never uploaded

Processed on this device · Maximum file size 15 MB

How to make a one-column CSV from a text list

Put one complete item on each line

Open your source in a plain text editor and make sure each line represents exactly one item: a product name, email address, search term, or similar value. Save it with a .txt extension, choose the file in the tool above, and select Convert to CSV. The preview shows the header Text followed by the converted rows. Download the .csv file and open it in a spreadsheet or import it into another application. The FilePiko home page lists other formats when your source is not plain text.

For example, three lines reading Red apple, Green pear, and Blue plum become three data rows beneath the Text header. A line that contains Red apple, large is still one item, not two columns. The CSV writer places quotes around a value when its comma would otherwise look like a separator. The csv to excel tool can then place that single-column list into an XLSX workbook if you need the Excel file format.

Review the preview and keep the source file

The browser reads one chosen TXT file at a time. After conversion, the preview displays the beginning of the generated CSV; long results can be truncated on screen while the downloaded file contains the full output. Check the first few rows for expected commas, quotes, and line breaks, then inspect the downloaded file if the list is large. This tool allows input and output up to 15 MB and at most 100,000 non-empty lines.

Keep the original text list until you have checked the CSV in the destination application. CSV importers can display the same text differently, especially values that resemble dates, long numbers, or formulas. Conversion creates a table representation of the lines; it does not validate that the items are unique, correctly spelled, or suitable for a particular mailing or catalog system.

Why a TXT file is not already a CSV table

A line is a record, while a CSV row has a defined column

A TXT file can contain arbitrary prose and line breaks. CSV uses a delimiter and quoting rules to represent cells. This converter makes the simplest possible schema: one column with the literal header Text. It treats each non-empty input line as one row in that column. This is useful for lists, but it does not discover first name, last name, price, and date fields hidden inside a line.

If the input is actually a multi-column table separated by tabs, semicolons, or pipes, this converter will put the entire line into one CSV cell. It will not recognize a tab as a new column or infer that a pipe divides two values. Use a text editor or a data import tool with explicit delimiter settings if you need more than one column. Check the shape before using csv to json, which treats CSV headers as JSON keys.

The Text header is inserted, not taken from your list

The first line of your input is data. The tool adds Text above it as the CSV column name. If your file already starts with a header such as Product, that word becomes the first data row unless you remove it from the source first. This difference matters when importing a mailing list into a service that expects the first CSV row to name fields. Rename the header after conversion if the destination needs a specific column name.

Because there is only one column, each row has one value even when the value contains a comma. A spreadsheet that opens the CSV using a different delimiter convention may show quoted content strangely. Inspect the raw CSV in a text editor to tell whether the file is correctly quoted before changing your source data. The CSV format and an individual spreadsheet's import preferences are separate concerns.

How blank lines, commas, quotes, and whitespace behave

Blank lines are skipped, while text spaces can remain

Lines containing no non-whitespace characters are removed before writing rows. This includes a line made only of spaces or tabs. Non-empty lines are kept as their original strings, so leading or trailing spaces around an item can remain in the cell. If an import treats Alice and space-Alice as different values, clean the text in the source first. The displayed row count refers to retained input lines, not all physical line breaks.

The reader removes a UTF-8 byte-order mark when it appears at the very start of the text. It splits lines on common LF or CRLF endings. A file saved with unusual line-ending conventions may need normalizing in a text editor before conversion. If all lines are empty, the output can still have a Text header without meaningful data rows; inspect the result before sending it to another system.

CSV quoting protects commas and embedded double quotes

Suppose one list item is Smith, Jane. The comma is part of a single cell, so the CSV writer quotes that value. A double quote inside an item is escaped according to CSV rules, usually by writing it twice inside a quoted field. The output may look more complicated in a text editor than the original list, but a CSV-aware importer will restore the original cell text.

Do not manually remove quote characters from the generated CSV merely because they appear around a value. Doing so can split one product name into two columns. If you are checking a complex item, compare its raw CSV line with how a trusted spreadsheet importer displays the one Text cell. This distinction helps diagnose whether the converter or the receiving program is interpreting the delimiter differently.

What changes when you open the CSV in a spreadsheet

Spreadsheet apps may reinterpret cell text

A CSV is plain text, so it cannot mark a column as text, attach a date format, or preserve spreadsheet styling. An application that opens it may turn 00123 into 123, reformat a date-looking value, or display a long number in scientific notation. The generated CSV may still contain the exact original characters. Import the file with the Text column set to text when leading zeros, account codes, or serial numbers must stay unchanged.

Values that begin with symbols such as an equals sign deserve extra care when opened in spreadsheet software. Some applications interpret them as formulas rather than ordinary text. This converter does not neutralize such values. If the list comes from an untrusted source, review or sanitize suspicious lines before opening the CSV in a spreadsheet that evaluates formulas. A plain text editor lets you inspect the raw output without triggering spreadsheet interpretation.

One-column CSV helps with lists, not complex records

For a simple import of city names or image filenames, the output is often ready as soon as the receiving service accepts a Text column. For a contact export, a single line like name, email, phone remains one field; it does not become three usable columns. Decide which pieces of information should become separate fields and reshape the data before import. The excel to csv route is for existing workbooks with real rows and columns, rather than arbitrary TXT lines.

If you ultimately need JSON, one option is to use the generated CSV through csv to json. That creates an array of objects with a Text property for each row. This is predictable but does not turn individual phrases into rich records. The explicit column name makes the resulting JSON easy to inspect and rename in code if your application expects a different key.

What to check when the CSV has the wrong rows

Unexpected row counts usually come from line boundaries

If the preview shows fewer rows than you expected, search the original for blank lines and check whether several items were pasted onto one line. A visual wrap in a text editor is not necessarily a real line break. Turn on visible line endings or move the cursor through the file to tell the difference. The tool does not split on commas, semicolons, or tabs, so those characters will not create additional rows.

If the whole file appears as one row, check the saved text format and line endings. Re-save a copy as ordinary UTF-8 text with LF or CRLF newlines and retry. Avoid editing the only copy of a source list until you know which representation the receiving system expects. For a very large list, try a short sample first and then process the complete file once the sample has the right shape.

Resolve file limit and import errors at the right stage

The workspace refuses a TXT file larger than 15 MB and more than 100,000 non-empty lines. The generated CSV can also be larger than the input because of its header and quoting. Split a long list into manageable files if the target system permits multiple imports. Refreshing the browser will not increase those limits, and closing the page clears the selected file and preview.

If conversion succeeds but the destination rejects the CSV, read the destination's required header, delimiter, encoding, and maximum size. This tool produces a one-column Text CSV; it cannot meet a schema that requires multiple named fields without a separate reshape. Check the file in a text editor before assuming the error is caused by a missing row or a failed download.

Questions about txt to csv files

Will commas in a TXT line create extra CSV columns?

No. Each non-empty line remains one Text cell. The CSV writer quotes a value containing commas so a CSV-aware reader keeps it together.

Why did my blank lines disappear?

The converter skips lines whose contents are empty or only whitespace. The row count therefore describes retained lines, not every line break in the source.

Does the first TXT line become the CSV header?

No. The tool inserts a header named Text. Your first non-empty source line becomes the first data row.

Can tabs or pipes in a line become separate columns?

This tool does not split a line by those delimiters. Use an import workflow that lets you choose a delimiter if you need multiple columns.

Why did 00123 display as 123 in Excel?

A spreadsheet may infer a number when it opens CSV text. Check the raw file; import the Text column as text to preserve leading zeros.

What happens to quotes in a product name?

The CSV writer escapes embedded double quotes using CSV quoting rules. A compatible importer reconstructs the original one-cell value.

Can I convert a paragraph file into several spreadsheet fields?

No. Each non-empty line becomes one field in one row. A paragraph is not automatically split into names, dates, or other columns.