I have a CSV file. If I just open it in Excel 2007, Excel doesn't ask any questions and the resulting data is organized properly.

If I import the same file, and tell Excel to delimit it via commas, the resulting data is messy and unorganized. The reason that I want to import as opposed to open, is that I want to build a Macro to automatically pull in the data and make a chart based on it.

Why is Excel handling the data improperly on the import?