how do i create multiple records in the same table

i am using this thing for the first time
i am unable to enter more than one record in the same table

A spreadsheet basically isn’t a table. It doesn’t hold records but cell contents cell by cell.
If you want to create a table in a spreasheet you need to use the first row for column (“field” now) names. Now you can enter something like a record: enter values column by column into the next empty row.

If you regard everything concerning types and field headings, you can export such a sheet (e.g.) as a table in any csv style, and import it somewhere else as a data table …
A database driver may also be able to connect to such a sheet.