Creating a data table asset is actually very simple, you've already done the work by creating the Excel sheet itself and converting it into *.csv, but in fact this is not enough for it to work.

You see from the previous point, that after dropping the file into Unreal, it will ask you to "pick a structure" which means you can't proceed with the file without having a data structure, which we will be covering next.

But what I want to cover now, is how to create a data table within Unreal. Let's say you don't want to create your work within Excel or a Google spreadsheet, and then convert it, and finally import it. You want to write your table directly within Unreal! And this is totally doable!

Dragging and dropping a *.csv file generating a data table asset, which you can create directly from within the content browser and the Miscellaneous section, will give you the same result. Despite that, you'll be asked for the data structure, but still you can create it directly...