How to import CSV files to Excel

If your using a database-driven website (like a WordPress site) then you'll probably be able to export the data as a CSV file (comma separated values). This allows you to open the file in Microsoft Excel however the data doesn't always display in columns as expected.