Enter Data Right Away

If you are a Microsoft Excel or spreadsheet user who would like to first enter the data into the tables and then worry about naming the columns or formatting them, then this is the option that you have to choose.

Refer the following video to know how to create a table by directly entering data into it.

In the sheet, you can start entering the data that you wish to add under the respective columns named Column1, Column2 etc., You can also rename the column headers by double-clicking on them and providing a name. As mentioned already, do ensure that column names are unique in a table.

Once you are done with your data entry, click on the Save button in the toolbar. This will prompt the Save dialog where you need to provide the name of the table (mandatory) and description (optional). The new table will be created with the given name, including the newly added data and columns.

Note:

  • Anytime you can rename a table by clicking on the Edit icon seen in the top-left corner of the tab in which the table is displayed. The edit icon will be visible only when you mouse over the tab. Clicking on the icon, the table name will become editable. You can modify the name and press the Enter key to save the table with the new name.