RockWorks | Utilities | File | Import | CSV
This program is used to import into the Utilities datasheet an existing text file of row and column data that has been saved in a "CSV" or comma-separated-variable format. Once the data is displayed in the datasheet, you can modify the column names and types using the Columns | Column Properties menu option.
Note: Data will be imported into the datasheet starting at the currently highlighted datasheet row.
Menu Options
Step-by-Step Summary
Menu Options
- Input File: Click to the right to browse for the name of an existing CSV file that contains the data that is to be imported into the RockWare datasheet.
- File contains header line: Some data files contain a "header" within the first line that contains the column titles. If so, you must specify it, by checking this option, so that this program doesn't include the header line as data within the RockWare datasheet.
- Extract Column Titles from header line: If the CSV file contains a header line, choose this option to read the titles within the header line and use them to redefine the column titles within the RockWare datasheet.
- Skip Header Line(s): Choose this option to ignore the header lines(s) in the file being imported. Expand this heading to select how many rows are to be ignored.
Step-by-Step Summary
- Access the RockWorks Utilities program tab.
- Select the File | Import | CSV menu option.
- Enter the requested program settings, described above.
- Click the Process button.
The program will import the text data and display it in the datasheet.
- To adjust column heading names, data type, and/or units, use the Columns | Column Properties option.
Back to Importing Data
RockWare home page