Import from Excel
|Top Previous Next|
CAP 5 offers the ability to import data directly from a Microsoft Excel spreadsheet. The program can import .csv (Comma-separated values) files, .xls files (Excel 97-2003 format), but not xlsx (Excel 2007/10/13) folders.
It is important, however, that a number of points are observed:
The image below shows a typical data set organised within Excel. The columns are the samples and the rows are the values for the variables.
Remember that you can also copy from Excel and paste directly into a CAP data grid - see Copy and pasting data.