优化添加字段的操作

[ghost]

Is your feature request related to a problem? Please describe.
在使用的过程中，我首先需要按照自己的需求新建数据表，未发现导入功能，只能先试试手动建表了。
见表的过程中我发现新建的操作非常依赖鼠标，我只能不停的切换打字、点击，非常的麻烦不方便。

Describe the solution you'd like

1. 提供通过excel或者其他格式的表格导入功能，可以自动的吧表头变成字段！
2. 对添加字段的操作步骤进行优化，比如一直填写、enter（或者tab）就可以不停的连续的操作、新建，不需要手动点击。（例如新建好一个字段之后再新建第二个字段不需要点击而是新建字段完成之后自动的把focus放在新建一个的按钮上）
3. 不想要随机生成一个字段名称，我认为从字段名进行翻译（中文情景）来建立、或者是直接把字段名用下划线链接之后建立为好
   （英文情景），如果有编程数据库基础的人都知道不能建立完全相同的字段名。

Describe alternatives you've considered
我只能说这个新建字段的操作并不舒适…… 而且从测边划出的窗口我总怕不小心消失掉。

Additional context

[budnail]

English translation from Google Translate:
Is your feature request related to a problem? Please describe.
In the process of using, I first need to create a new data table according to my own needs. I can't find the import function, so I can only try to create a table manually.
In the process of looking at the table, I found that the new operation is very dependent on the mouse. I can only switch typing and clicking, which is very troublesome and inconvenient.
Describe the solution you'd like

1. Provides the function of importing tables through excel or other formats, and the headers can be automatically turned into fields!
2. Optimize the operation steps of adding fields, such as filling in all the time, enter (or tab), you can continue to operate continuously, create new ones, and do not need to click manually. (For example, after creating a new field and then creating a second field, you do not need to click, but after the new field is completed, the focus is automatically placed on the new button)
3. I don't want to randomly generate a field name. I think it is better to translate the field name (Chinese scenario) to create it, or to directly link the field name with an underscore.
   (English scenario), if anyone who has programming database foundation knows that it is impossible to create exactly the same field name.
   Describe alternatives you've considered
   I can only say that the operation of this new field is not comfortable... and the window drawn from the measurement side is always afraid of disappearing accidentally.

[budnail]

I would vote initial for a simple CSV import where the first row (header row) contains the field name and the remaining rows contain data. This would greatly reduce the work load on creating a collection.

Maybe have an option to select: (Create new collection, Add to existing collection, Update existing collection).
If Update is selected ask for key field(s) to match the row of the data to update.

Maybe add an option to select the field delimiter. (comma, tab, pipe |,...)

[zhouyanliang]

@kasusa @budnail We are considering improving the experience of adding fields