Convert CSV/TSV to TXT
Parse CSV/TSV in the browser and choose columns, delimiters, blank fields, and line-break codes to convert it to UTF-8 TXT.
Open the tool to convert CSV/TSV to TXTConclusion: Specify the input tab and output separator separately
For the input delimiter, select Tab or check the auto-detection result. Output can remain Tab-delimited or use spaces, pipes, commas, custom strings, fixed width, or key-value format. Because spaces within fields are part of the value, changing to space-delimited format makes it difficult to restore the original column boundaries.
TSV checklist
| Target | confirmation |
|---|---|
| Record | Whether each line is one record |
| Field | Whether columns are separated by Tabs |
| Header | Whether the first row is column names or Data |
| Empty Field | Whether to preserve consecutive Tabs and trailing Tabs |
| Line Ending | Whether to output CRLF or LF |
Conversion steps
- Load TSV and confirm that the Delimiter display is Tab.
- Check Header names and the number of data rows and columns.
- Choose output columns and options such as Space, Pipe, and fixed width.
- Preview blank and long fields.
- Save the TXT and check it in a Text Editor.
What DevelopTools' CSV / TSV conversion can do
The current tool loads one CSV, TSV, or TXT file, or uses pasted delimited text. Manually select UTF-8 or Shift_JIS as the file input encoding. It can automatically detect the delimiter by comparing column counts for commas, tabs, semicolons, and pipes, or you can specify any one character. It does not automatically detect encoding.
| Item | Support in the current Tool |
|---|---|
| Parsing | Process quoted Commas and Newlines, Escaped Quotes, and empty Fields with a custom Parser. |
| Columns | Headers, column selection, sorting, and multi-column output |
| output | Delimited text, fixed width, key-value pairs. Tab, space, pipe, comma, or arbitrary strings |
| plastic surgery | Trim, replace blanks, remove empty lines, LF / CRLF |
| Save | Preview, Copy, UTF-8 TXT, and optional UTF-8 BOM |
A line break cannot be selected as the separator between fields, but with only one column, one record can be placed on each line. Automatic encoding detection, deduplication, sorting, chunking / streaming, and error line number display are not implemented. Input encoding is used only when reading a file's byte sequence.
Parse CSV as fields, not by bulk comma replacement
CSV can contain commas, line breaks, and escaped quotes inside double quotes as one field. “"Tokyo, Japan"” is one field. split and replaceAll misidentify column and record boundaries.
RFC 4180 is an Informational RFC that documents a widely used CSV format. For actual Data, also check the input source specification for Headers, Delimiters, Quotes, empty Fields, and line breaks. The current Parser handles major Quote Cases but is not a strict Validator.
Before and after conversion, check the number of Data rows and columns, and representative rows containing Embedded Commas, Embedded Newlines, Escaped Quotes, empty fields, and trailing empty fields.
Basic steps for converting CSV / TSV to TXT
- Keep the original File, then select one file or paste its contents.
- Check the encoding, delimiter, header, number of data rows, number of columns, and warnings.
- Decide columns and order, output format, Separator, empty fields, Trim, and line-break Code.
- Compare previews before and after conversion, then copy or save under a different name.
Changing an extension from .csv to .txt alone does not change column structure or quotes. Reconstruct the content as plain text appropriate for the purpose.
Check character encoding, BOM, and line-ending codes separately.
Mojibake occurs when a byte sequence is decoded with a different encoding. When loading a file, select UTF-8 or Shift_JIS and check Japanese text and symbols in the preview.
A UTF-8 BOM in the input is removed. Output can use UTF-8 with or without a BOM, and CRLF or LF line endings. Specify the options according to destination requirements.
- Compare Japanese Preview in UTF-8 and Shift_JIS
- Use CRLF as a candidate for Windows-centered work and LF for Repository-centered work
- When returning to Excel, check whether a BOM is required in the actual environment
Check for omissions, shifted columns, and unintended changes before saving.
| Account to check | How to check | Points to note |
|---|---|---|
| Lines | Compare input data rows and output rows. | Differences appear when excluding headers and removing blank lines |
| Columns | Compare the input preview and selected columns. | Confirm whether column selection is an intentional reduction |
| Quote | Check fields containing commas, line breaks, or quotes | Do not bulk-remove only surrounding quotes |
| Blank | Check empty fields in the middle and at the end. | Distinguish replacing blanks from deleting blank lines |
| Line breaks within cells | Check the \n notation in the output | The current tool converts to a literal \n |
| Encoding | Open Japanese text and symbols at the destination. | Match BOM presence as well. |
Primary sources for CSV, TSV, and character encoding
Check the RFC Editor for CSV structure, IANA for the media type, and the WHATWG Encoding Standard and MDN for browser decoding. For real data, also prioritize the export specification of the source system.
Example: convert a three-column TSV to space-delimited text
Use TSV such as Alice
Specify Tab, Header settings, three columns, half-width Space, and LF. After conversion, check Field order, Spaces within Fields, empty Fields, the number of Data rows, and Line Endings; consider it complete only after opening it in the destination.
- Load the input by specifying the encoding, delimiter, and whether it has a header.
- Check row count, column count, parsing warnings, and representative rows containing problems.
- Specify the required columns and order, output format, separator, and line ending.
- Convert to TXT, then compare the input Preview with the result.
- Copy or download under another name, then verify it at the actual destination.
Check not only regular rows but also rows containing commas, quotes, line breaks, blank fields, and Japanese text.
Frequently asked questions
- Does simply changing a CSV extension to .txt make it TXT?
- You can rename the file, but commas, quotes, and column structure remain. To change the content into one item per line or space-delimited text, parse it as CSV and then reconstruct it.
- Is the entered CSV/TSV sent to a server?
- It is not sent. File loading, parsing, preview, conversion, copying, and TXT saving are processed in the Browser.