Using Anaconda Prompt to import excel doc in MYSQL Step 1 - Open Anaconda Prompt which is available with Anaconda Navigator Step 2 - Type ("pip install csvkit") this will install all the necessary ...

Provide your MySQL credentials in config.json, under "mysql" key. Under "table" & "fields", provide the MySQL table name & fields receiving the import; "name" is required and need to match the field ...