Creating a table from text
How do I convert structured text into a table?
First let's explain why this might be useful. Consider that you're making a sign-in sheet for an event. If you have a list of names already, Open Office makes it easy to transform it into a list. Each line of content will become a row and anything separated by the chosen item (tab, paragraph, semicolon, or other) will be placed in its own row. The steps and images below explain the process.
1. Structure your text so that content from each row is on its on line and content of each cell that you want created is separated by one of the available options, such as using a comma.
2. From the menu toolbar, click Table.
3. Hover over or click on Convert and select Text to Table..
4. This will bring up an options dialogue.
5. The default option is Tabs – this will place each segment of content separated by a tab into its own table cell. Each line will be turned into its own row in the table. Other options include:
- Paragraph – content on its own line will be placed in its own cell and row.
- Semicolon – content between semicolons will be placed in its own cell. Each row is placed on its own line.
- Other – the user selects an option, such as a comma, and the content between the user selected option will be placed in its own cell. Each row is placed on its own line.
6. After you select the option you want to use, click OK.
