In BaseBear you can import data from an Excel file into an existing table. So you can maintain the structure of the table and all custom permissions applied. Here's how:
The Excel file must have the column names the same as the BaseBear table. Also the data type must be the same, for example, you cannot import the text values in a numeric column.