Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I made a table using the tab button on my keyboard rather than creating a chart with cells. How can i convert it to a table? It looks like this:
Brown น้ำตาล Namtaan
Navy น้ำเงินเข้ม Namngoenkhem
Grey เทา Thao
Teal น้ำเงินคราม Namngoenkhram
White ขาว Khao
Violet ม่วงอ่อน Muangon
Olive เขียวมะกอก Khiaomakok
Cyan ฟ้า Fah
Blue น้ำเงิน Namngoen
Lime เขียวมะนาว Khiaomanao
[Re-Titled by Moderator]
HomePod mini, 17
Select your entire tab delineated content in your Pages document, not from the above post in your browser — and copy to the clipboard.
Insert a new table object into your Pages document. Single-click only on the first cell, and then simply paste. Pages will automatically fill each row and column cell of the table with your matching row and column content from the clipboard.
A fix that one can apply to the source text is to employ additional tabs to complete gaps in the content.
and that pastes normally:
and not in pages 14 either!
Yes, the paste attempts to normalize to the longest column.
If I start with:
the paste into a Pages table will make these adjustments:
and although the paste still works, it is not the expected outcome. Deleting or hiding the empty column is a crude fix. Otherwise, there is no Pages fix for this uneven tabular data problem. With unequal columns, both LibreOffice Writer 24.2.2 and Word v16.84 Text to Table fail to separate into discrete columns and both create single-column results.
Thanks for this terrific answer! After following the process, i was faced with a prompt, "The table data was imported and can be adjusted" It was necessary that I clicked on the fly-out and change the settings to Delimited, and separate values using Tab. Worked like a charm. I really appreciate it!
Yes, it does. Tested with Pages v14 in macOS Sonoma 14.4.1. With tab-delimited text and a copy/paste of a formal HTML (not CSS) table from Safari into a Pages table.
Follow the instructions that I have posted.
Thank you.
It appears that the method you give works if each line in the text contains the same number of tabs.
However, if this is not the case, then copy and pasting the text into a table does not work
Follow these instructions. It most certainly works in Pages v13.2 on macOS including Sonoma 14.4.1.
How can I convert text to tables in Pages? - Apple Community
You are welcome.
Does not work in Pages 13.2 on macOS. :‑(((
How do I convert text to a Table in Pages?
