Selecting the file format

The Select format page provides a preview of the file so that you can confirm the format and the delimiter.

Before importing, make sure you understand the data requirements. This will save you import errors.

The application runs a quick analysis on the selected file to determine the file format and auto-fills the Format fields above the file preview. the File preview is based on the results of the analysis. For example, if successive rows have a consistent number of commas each, the application will select a delimited file format with the comma as the delimiter.

  1. If you have a saved template that you want to use, browse to and select the template file. What the template includes depends on which page of the import wizard that you saved it on. For example, if you saved it on the Select format page, the template will include the file format and the number of rows to skip, but not the assigned column headers on the next page of the wizard.
  2. If you did not load a template, confirm the displayed file Format:

Delimited

Supported delimiters are: comma, tab, pipe, semi-colon, colon, and custom. The file analysis will not detect custom delimiters.

For a custom delimiter:

  1. Make sure the format is Delimited
  2. For Delimiter select Custom.
  3. In the third box, select the custom delimiter character.

Columnar

The file analysis looks for consistent breaks in text strings and defines columns, but you can define the column breaks on the next page of the wizard.

  1. Enter the number of header rows to skip, or simply click on the last header row. The first row of actual data should be the next row.
  2. If you have rows you want to skip at the end of the file, enter the first row of footer data. All rows that follow until the end of the file will be skipped.
  1. Click Next to assign column headers.