How to import data efficiently?

Dear all,

Case: I have about 400 Products and 2000 Ingredients (Product and Ingredient are 2 of 13 Dimensions). I want to enter formulas in which one Product consists of some Ingredients. If I use Product as Page and Ingredient as Row, I have to choose each Product to enter data, but I don't want to do that because there are too many Products. If I use Product as Column and Ingredient as Row or both are Rows, It's not OK because of inefficience (400*2.000=800.000 cells).

I have read some docs and I see that I can use Interface Table or something like that in order to import data directly to database. But I don't know how to use it. If you know this function, please tell me some instructions.