Aristotle Support

Excel File Format Problem

Article ID: 813
Last updated: 07 Mar, 2010

Excel File Format Problem

If you're opening an Excel file and it is unreadable with commas separating information, you'll need to modify your file.

 

  1. Open the file with Excel.  

  2. Click the column header button to highlight Column A where all the data is.

  3. Go to Data menu, click “text to columns”

  4. Check the box for “comma” then click Finish.

 

This should separate the data into separate columns that you should be able to manage in Excel.

 

Click File -> Save As and make sure to save the file as a .csv or .xls document.

 

This article was:   Helpful | Not helpful Report an issue


Article ID: 813
Last updated: 07 Mar, 2010
Revision: 1
Views: 408
Prev     Next
Expired Session       FAQ's - Frequently Asked Questions