To export contacts from Microsoft Outlook, you'll need to use Outlook's "Export to a file" feature, which is built-in.
To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.