Need to add latitude and longitude to excel sheet to addresses and make new column

Job ID: 34050678

Budget: ₹600 – ₹1,500 INR

Excel sheet contains Company name, address and category

1.
Looking for geocode or similar software to add latitude and longitude to excel sheet with addresses. No restrictions on number of addresses

2.
Add a new Column description which will add data of 2 to 3 columns which will be useful for making description of the Company.

Sample Column Company Name ( Variable ) is located in Column Address ( Variable ) dealing in Category ( Variable )


This may keep on changing , you just need to teach me how to add formula


3. If Company name found duplicate and has differenet category, need to both Categories and Remove Duplicates record
Related categories: Python Excel Google Maps API Excel VBA