onlinetexttools logo

Nice columns to text converter

World's simplest text tool

World's simplest browser-based utility for converting nice columns to text. Load your columns in the input form on the left and you'll instantly get text in the output area. Powerful, free, and fast. Load neat columns – get plain text. Created by developers from team Browserling.
announcement heads up!
We just launched a new site – Online String Tools – a collection of string processing utilities. Check it out!
fullscreen fullscreen_exit
Ignore Columns
List of column numbers that should be ignored.
Column numbers can be a list or a range. For example, 1,2,3 or 3-5, or 4,6-8.
Join Columns
Replace spaces between columns with this symbol.
Replace newlines at the end of columns with this symbol.
Nice columns to text converter tool What is a nice columns to text converter?
With this tool, you can convert vertically aligned text columns into horizontally oriented text. The tool automatically finds all columns in the input data and applies formatting that you've specified in the options. If you need to leave some of the columns untouched, then you can specify their position in the ignore-columns field. This fields accepts two formats – a comma-separated list of column positions (such as 1, 5, 6) or intervals (such as 2-4). In the second group of options, you can specify characters for gluing the columns together. In particular, you can set a symbol to replace spaces between the columns and a symbol to replace newlines. Textabulous!
Nice columns to text converter examples Click to use
Dog Breeds
In this example, we convert three columns about dog breeds into joined text. We detect and replace spaces between columns with a single space character and instead of newlines we put a dots.
Breed Origin Group Akita Japan Working Group Havanese Cuba Toy Group Pekingese China Toy Group Barbet France Miscellaneous Class Azawakh Mali Hound Group Boxer Germany Working Group
Breed Origin Group. Akita Japan Working Group. Havanese Cuba Toy Group. Pekingese China Toy Group. Barbet France Miscellaneous Class. Azawakh Mali Hound Group. Boxer Germany Working Group
Required options
These options will be used automatically if you select this example.
List of column numbers that should be ignored.
Replace spaces between columns with this symbol.
Replace newlines at the end of columns with this symbol.
Metal Properties
This example converts columns with properties of metals into text separated by dashes. Notice that in the third column temperature °C symbol forms the fourth column. We exclude it by specifying the number 3 in the column ignore option. This means ignore column separator between the third and fourth columns. As a result, the tool places hyphens everywhere, except that one space before Celsius symbol and melting temperature.
Metal Density Melting (name) (g/cm³) temperature (°C) Iron 7.87 1539 Silver 10.50 960 Gold 19.32 1063 Copper 8.94 1083 Aluminum 2.70 660
Metal-Density-Melting (name)-(g/cm³)-temperature (°C) Iron-7.87-1539 Silver-10.50-960 Gold-19.32-1063 Copper-8.94-1083 Aluminum-2.70-660
Required options
These options will be used automatically if you select this example.
List of column numbers that should be ignored.
Replace spaces between columns with this symbol.
Replace newlines at the end of columns with this symbol.
Women's Clothing Sizes
In this example, we reformat only the last column. As you can see, the first three columns remain unchanged but the separator before fourth column is changed to the tilde symbol. This is accomplished by setting the column ignore interval option to "0-2". Column zero means leaving spaces before the first column untouched. As a result, we get columns 3 and 4 connected by a tilde.
USA Europen UK SML Sizes Sizes Sizes Sizes 1 32 4 XS 2 34 6 4 36 8 S 6 38 10 8 40 12 M 10 42 14 12 44 16 L 14 46 18 16 48 20 XL 18 50 22 20 52 24 XXL 22 54 26
USA Europen UK~SML Sizes Sizes Sizes~Sizes 1 32 4~XS 2 34 6 4 36 8~S 6 38 10 8 40 12~M 10 42 14 12 44 16~L 14 46 18 16 48 20~XL 18 50 22 20 52 24~XXL 22 54 26
Required options
These options will be used automatically if you select this example.
List of column numbers that should be ignored.
Replace spaces between columns with this symbol.
Replace newlines at the end of columns with this symbol.
Fish Species
In this example, we turn tab-separated columns with info about fish species into comma-separated text. The tool is able to process tabs as column separators but if it sees a space then it treats it as a regular character and doesn't consider it a column separator.
Fish Water type Family Salmon Fresh water Salmonidae Cobia Salt water Rachycentridae Cod Fresh water Percichthyidae Tailor Salt water Pomatomidae Trout Fresh water Salmonidae Carp Fresh water Cyprinidae Bonito Salt water Scombridae
Fish, Water, Family Salmon, Fresh water, Salmonidae Cobia, Salt water, Rachycentridae Cod, Fresh water, Percichthyidae Tailor, Salt water, Pomatomidae Trout, Fresh water, Salmonidae Carp, Fresh water, Cyprinidae Bonito, Salt water, Scombridae
Required options
These options will be used automatically if you select this example.
List of column numbers that should be ignored.
Replace spaces between columns with this symbol.
Replace newlines at the end of columns with this symbol.
Pro tips Master online text tools
You can pass input to this tool via ?input query argument and it will automatically compute output. Here's how to type it in your browser's address bar. Click to try!
https://onlinetexttools.com/convert-nice-columns-to-text?input=Breed%20%20%20%20%20Origin%20%20%20Group%0AAkita%20%20%20%20%20Japan%20%20%20%20Working%20Group%0AHavanese%20%20Cuba%20%20%20%20%20Toy%20Group%0APekingese%20China%20%20%20%20Toy%20Group%0ABarbet%20%20%20%20France%20%20%20Miscellaneous%20Class%0AAzawakh%20%20%20Mali%20%20%20%20%20Hound%20Group%0ABoxer%20%20%20%20%20Germany%20%20Working%20Group&output-element-separator=%20&output-row-separator=.%20&ignore-columns=
All text tools
Didn't find the tool you were looking for? Let us know what tool we are missing and we'll build it!
Quickly split text into chunks.
Quickly merge lines of text together.
Quickly repeat text many times.
Quickly write text backwards.
Quickly cut text to the given length.
Quickly trim left or right side of text.
Quickly pad the left side of text.
Quickly pad the right side of text.
Quickly align text to the right side.
Quickly center text.
Quickly prepend a prefix to text.
Quickly append a suffix to text.
Quickly delete all blank lines from text.
Quickly delete all repeated lines from text.
Quickly return text lines that match a string or a regex.
Quickly find and replace text patterns.
Quickly count the number of characters in text.
Quickly find the number of lines in text.
Quickly create an image from text.
Apply the Zalgo effect to the input text.
Quickly construct a palindrome from plain text.
Quickly test if text is a palindrome.
Quickly convert text letters to uppercase.
Quickly convert text letters to lowercase.
Quickly randomize character case in text.
Quickly invert character case in text.
Quickly replace spaces with newlines in text.
Quickly replace newlines with spaces in text.
Quickly get tabs instead of spaces in text.
Quickly get spaces instead of tabs in text.
Quickly clear text from spaces, tabs, and newlines.
Quickly clear text from dots, commas, and similar characters.
Quickly extract tag content from HTML code.
Quickly extract tag content from an XML document.
Quickly extract all textual data from BBCode markup.
Quickly extract keys and values from a JSON data structure.
Quickly convert text to a JSON string.
Quickly convert previously JSON stringified text to plain text.
Quickly escape special symbols in text with slashes.
Quickly remove slashes from previously slash-escaped text.
Quickly encode or decode text using ROT13 cipher algorithm.
Quickly encode and decode text with ROT47 cipher algorithm.
Quickly create text that matches the given regexp.
Quickly find and return all regexp matches.
Quickly format text using the printf or sprintf function.
Quickly cyclically rotate text letters to the right or left.
Quickly rewrite text to vertical position.
Quickly format text so that all words are in neat columns.
Quickly convert data aligned in columns to linear text.
Quickly create a list of all monograms from text.
Quickly create a list of all digrams from text.
Quickly create a list of all ngrams from text.
Quickly write the text in Morse code.
Quickly decode Morse code to plain text.
Quickly URL-escape text.
Quickly URL-unescape text.
Quickly convert all plain text characters to HTML entities.
Quickly convert HTML entities to plain text.
Quickly encode text to base64.
Quickly decode base64-encoded text.
Quickly convert plain text to binary text.
Quickly convert binary text to plain text.
Quickly convert plain text to octal text.
Quickly convert octal text to plain text.
Quickly convert text to decimal values.
Quickly convert decimal values to text.
Quickly convert plain text to hexadecimal values.
Quickly convert hexadecimal to readable text.
Coming soon These text tools are on the way
Calculate Levenstein Distance
Find Levenstein distance of two text fragments.
Tokenize Text
Create a list of all words in text.
Lemmatize Text
Lemmatize all words in text.
Generate Glitch Text
Mess up characters in your text.
Generate Random Text
Generate text using random words.
Convert Text to Code Points
Convert text characters to their corresponding code points.
Convert Code Points to Text
Convert numeric character code points to text.
Convert CSV to Text Columns
Convert CSV data to plain text columns.
Convert Text Columns to CSV
Convert plain text columns to a CSV file.
Generate Text Trigrams
Create a list of all 3-grams.
Generate Text Skip-grams
Create a list of all n-skip-m-grams.
Stem Words in Text
Apply stemming to all words in text.
Convert Text to Title Case
Convert words in text to have title case.
Convert Text to Proper Case
Capitalize the first letter of every word in text.
Justify Text
Stretch spaces between words in text to make all lines equal length.
Chunkify Text
Divide text into chunks of certain size.
Format Text
Apply formatting and modification functions to text.
Find the Number of Letters in Text
Count the number of letters in text.
Find the Number of Words in Text
Count the number of words in text.
Find the Number of Paragraphs in Text
Count the number of paragraphs in text.
Sort Letters in Text
Sort all characters in text alphabetically.
Sort Words in Text
Sort all words in text alphabetically.
Sort Sentences in Text
Sort all sentences in text alphabetically.
Sort Paragraphs in Text
Sort all paragraphs in text alphabetically.
Statistical Text Analysis
Analyze text for most frequent letters, words, phrases, sentences and paragraphs.
Add Text Line Numbers
Add a number before every line in text.
Wrap Text
Wrap words in text to a specified length.
Shuffle Letters in Text
Randomize the order of letters in text.
Shuffle Words in Text
Randomize the order of all words in text.
Shuffle Sentences in Text
Randomize the order of all sentences in text.
Shuffle Paragraphs in Text
Randomize the order of all paragraphs in text.
Find All Email Addresses in Text
Extract all emails from text.
Find All Web Addresses in Text
Extract all URLs from text.
Find All Numbers in Text
Extract all numbers from text.
Encode Text to Punycode
Convert text to punycode.
Decode Punycode to Text
Convert punycode to text.
Convert Text to Base32
Encode text to base32 encoding.
Convert Base32 to Text
Decode base32-encoded text.
Convert Text to Base58
Encode text to base58 encoding.
Convert Base58 to Text
Decode base58-encoded text.
Convert Text to Base85
Encode text to Ascii85 encoding.
Convert Base85 to Text
Decode Ascii85-encoded text.
UTF8-encode Text
Encode text to UTF8 encoding.
UTF8-decode Text
Decode UTF8-encoded text.
UTF16-encode Text
Encode text to UTF16 encoding.
UTF16-decode Text
Decode UTF8-encoded text.
UTF32-encode Text
Encode text to UTF32 encoding.
UTF32-decode Text
Decode UTF32-encoded text.
IDN-encode Text
Encode text to IDN.
IDN-decode Text
Decode IDN-encoded text.
Uuencode Text
Convert text to Unix-to-Unix encoding.
Uudecode Text
Decode Unix-to-Unix-encoded text.
Xxencode Text
Convert text to Xxencoding.
Xxdecode Text
Decode Xxencoded text.
Convert Text to Quoted Printable
Encode text to QP encoding.
Convert Quoted Printable to Text
Decode QP-encoded text.
Strip HTML Tags from Text
Remove all HTML tags from Text.
Strip XML Tags from Text
Remove all XML tags from Text.
Remove Diacritics from Text
Remove all accent marks from all characters in text.
Normalize Text Spacing
Remove duplicate spaces from text.
Compare Text
Find diff between two text fragments.
Create Text Typos
Generate various text typos.
Create a Mirror Copy of Text
Generate a mirror reflection of text.
Grep Text
Grep text for regular expression matches.
Head Text
Extract first lines from text.
Tail Text
Extract last lines from text
Rewrite Text
Rewrite text using transformation rules.
Generate Text Mnemonic
Return the first letter of each word in text.
Reverse Words in Text
Reverse every word in the given text.
Reverse Sentences in Text
Reverse every sentence in the given text.
Remove Zalgo from Text
Undo Zalgo effect from text.