What is the fastest way to add products to the database?

Question

MySQL

Hello everyone, there is a table of goods (a lot of goods) of an online store of building materials, table columns - 1) category 2) size 3) quantity in a box 4) price,

what is the fastest way to add this data or will you have to handle everything as in the example below?

insert into products (category, size, quantityPerbox, price) VALUES ("Люк", "15x15", "108", 181.74945)

Answer 1

What is the task? So that mysql loads faster or that you have less work to do?
Upload from existing files / databases or through an application / site?
If from a file, then the easiest and fastest way is LOAD