How to Import and Parse .csv and .txt Files

You can parse .csv or .txt files imported into Workstation to ensure that the different values in your file are not read as a single object. By default, Workstation recognizes commas used as delimiters and automatically separates your values into individual objects. However, if your file uses a delimiter other then commas, such as semi-colons, tabs, forward slashes, etc., you can manually parse the data to separate the values into individual objects.

1. Open a new dashboard.
2. Choose Add Data > New Data.
3. Select File from Disk > Choose files.
4. Open your .csv or .txt file and click Prepare Data from the Local Drive dialog to open the Preview dialog.
5. Click the drop-down arrow for the table you want to modify and choose Parse. The Parse Your Data Dialog opens.
6. Open the Delimiter drop-down and select the delimiter that your file uses.

   If you select custom, you must also enter the symbol acting as a delimiter in your file.

7. Click Apply.

Related Topics

Import Data

Preview Data and Specify Import Options