Choosing an Export Format

Many table pages include an Export tool. Use the Export Table Data Format option in Preferences to choose the file format to use with the Export tool. You can choose CSV, HTML, or Text. The graphics below shows samples of a parts table exported using each format.

Related Topics
Exporting Data

  1. From the global toolbar, select > My Tools > Preferences. The Preferences dialog box opens.

  2. From the General category, click Export Table Data Format. The page for choosing your export format appears.



  3. Choose the format you want:


    • CSV. Gives you the option to save the table data to a flat file in CSV (comma-separated values) format or open it in Excel. Export does not include columns with icons.

      If the data is saved directly to a file without opening it in Excel, the values are wrapped with double quotes ("?"). If there are leading zeros in an all numeric column value, it is wrapped as ="nnnn", where nnnn is the actual value. For example, if the value is 0001124, the value is printed as = "0001124". This special wrapping of values is required to preserve the formatting when opened in Excel.

      Example:



    • HTML. Opens table data in a new browser window as an Excel file. While displaying the Excel file, the images and styles are maintained but hyperlinks are inactive.

      Example:



    • Text. Gives you the option to save the table data in a flat file with delimiters defined in preferences, or open it in the default text editor. Export does not include columns with icons.

      Example with format with | as field separator and comma as the multi-value separator. Record separator is new line:



  4. If you chose Text format, choose the remaining preferences. These preferences are ignored for the CSV and HTML formats.


    • Field Separator. The character used to separate column data for each item. By default, the Field Separator is a comma. If there are multiple values within a single cell, these values are separated by a comma (,). If you define the Field Separator as a comma (,), the multiple value separator is |.
    • Record Separator. The character used to separate information for each item or row. By default, the Record Separator is a carriage return with a new line (\r\n).
    • Remove Carriage Return. To replace carriage returns with a space, choose Yes.

  5. Click Apply or Done to save your selection. Clicking Apply leaves the Preferences popup open so you can set other preferences. Clicking Done closes it.