Loading data to create a map visualization ?

[santho_ak]

I have a table like this. How do I create a map for this.

Address
123, Carriage Dr, Arlington Heights, IL 60004
345, West street, Arlington Heights, IL 60005
124, East street, Springfield, VA 40005
475, John Lane, Arlingotn, Texas 30005
784, South Road, Merrifield, VA 4009
478, Dundee Road, Buffalo grove, IL 60001

How to take out City, state name separately.

How do I create a map for this data.

Thanks