Mozilla will shut down Pocket’s services on July 8, 2025. At that time users will no longer be able to access the Pocket website, apps and API. You can export your saved items and API data until October 8, 2025 before they are permanently removed. For more information, see this article.

Avatar for Username

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

Convert text to a table

  • 8 replies
  • 1 has this problem
  • 23 views
  • Last reply by Matt

Tony
Tony

Is there a way to convert a set of tabbed text to a table?

AREA MONTH SALES GP 1 10000 GP 2 15000 GP 3 11200 KZN 1 20000 KZN 2 22000 KZN 3 21500

Can I highlight the text above, select something like "Insert" and select "Text to Table" and perhaps select "Create columns per TAB" and then have this text changed to a nicely formatted table?

Thanks in anticipation, Tony Robson

Is there a way to convert a set of tabbed text to a table? AREA MONTH SALES GP 1 10000 GP 2 15000 GP 3 11200 KZN 1 20000 KZN 2 22000 KZN 3 21500 Can I highlight the text above, select something like "Insert" and select "Text to Table" and perhaps select "Create columns per TAB" and then have this text changed to a nicely formatted table? Thanks in anticipation, Tony Robson

Chosen solution

There might be a way, if you write your lines with tabs then mark it all in Format /table there is "create table from selection" select space as separator and ignore extra spaces

Read this answer in context 👍 1

All Replies (8)

Matt
Matt
  • Moderator
  • Top 10 Contributor

There is nothing I am aware of that does that outside of a word processing program.

Tony
Tony Question owner

Thanks for the response Matt. I assume that means that MS Outlook is a "Word Processing Program"  :-) Or maybe MS Outlook uses MS Word to create mail messages?

So - next question then.... Is there a way to copy text into adjacent rows and columns in a table? I copied a tabbed list and a comma separated list, highlighted all the rows and columns in my table and pressed Ctrl V to paste.

All the text was copied into column 1. Is there some sort of "special" or "advanced" copy method that will do the trick?

Gnospen
Gnospen

Your text has only spaces in between and also nothing to end a line. If you want to import it in a table or document use a program like office and LibreOffice. But there MUST be something that tell when next line starts.

Gnospen
Gnospen

With Libreoffice (and ms-office) you can convert text to table in the word processor OR you can import it in a spreadsheet.

Tony
Tony Question owner

Well.... I did type my original text on separate lines. Sorry. The "post" seemed to strip it all out?

Anyway.... The answer is then to use a Word Processor and then copy and paste the table back into Thunderbird. It is a bit of a long way round but I suppose that is just how it is! Thank you.

Gnospen
Gnospen

Chosen Solution

There might be a way, if you write your lines with tabs then mark it all in Format /table there is "create table from selection" select space as separator and ignore extra spaces

Tony
Tony Question owner

Excellent Gnospen!

That is EXACTLY what I was looking for! Convert text to table..... Format highlighted text as a table... It works 100% Thank you so much and well done!  :-)

Matt
Matt
  • Moderator
  • Top 10 Contributor

Well learn something new every day. I stand corrected.