Whenever possible we allow exporting data from PropReports in the Microsoft Excel file format (.xls). While a useful and powerful tool, Excel's file format has certain limitations. For example, a worksheet is limited to 65,536 rows by 256 columns. Also, because they are binary, the files are difficult to import into other systems. Because of this, we sometimes export data as text files with comma-separated values (.csv).
...
While you can open csv files in Excel, they can cause other problems discussed below:
| Anchor | ||||
|---|---|---|---|---|
|
Text Gets Formatted as a Date or Number
...
If this is causing problems, the workaround is to open the file from the Data menu as follows:
- On the Data menu, point to Import External Data and then click Import Data to open the Select Data Source dialog box.
- In the Select Data Source dialog box, in the Files of type list, select Text Files.
- Then, in the Look in list, navigate to the folder containing the file you want and select the text file you want to import.
Choose Delimited as the Original Data Type and click Next. The Text Import Wizard opens and guides you through a three-step process that ensures that the text is correctly split into separate worksheet columns by selecting delimiters in the files.
- Choose Comma as the Delimiter and click Next.
Make formatting changes as necessary by selecting a column and then selecting an option under Column data format. For example, if there's a column of part numbers that you want to define as text instead of numbers, select the Text option. Click Finish when done.
 |  |  |
| Anchor | ||||
|---|---|---|---|---|
|
Opening a .CSV file too large for Excel
...