CSV to MySQL required

2 large CSV file with 6 headings each require entry into MySQL databases. Each will have it's own database, no mixing of data required. Attached is a subset of the data to be converted. All city information must be converted to uppercase first letter, lowercase remaining. Example ABBOTSFORD will need to be Abbotsford once converted.