I have an Excel spreadsheet column with hundreds of company names on it. I need to find the address (or just city if that's easier)
The operation for this is simple in wolfram alpha. i.e. typing "Target headquarters" returns "1000 Nicollet Mall Minneapolis Minnesota 55403"
How do I use mathematica or the wolfram cloud programming language to automate this? I found this similar question: Use the value of a cell in a table as the argument to a function but can't get it to work for my problem.
I'm pretty good with excel,so I can turn the spreadsheet column into a list or anything if needed.
Thanks for any and all help!