Exporting Data from a Table

To export data from a table:

  1. Click the Setup link in the top right corner of the window.

  2. Choose a table and click the corresponding tab at the top of the window.

  3. From the menu in the main frame, select Tables > Export data from table. The system allows you to export data using three possible formats:

    • Microsoft Excel (XLS)
    • Comma-Separated Values (CSV)
    • Hypertext Markup Language (HTML)
      Export Data from a table
  4. Choose the format and click the Export button.

Please note, if you export data from a table, only physical columns (such as text, number, email, etc.) with data will be exported. The other columns like formulas, lookups, and summary columns can’t be exported in this case.

Therefore, if you need to export data kept in formula-, lookup-, or summary-columns, you should use the Export button displayed in any table view. Moreover, if you need to export file attachments, use the tdbackupwin tool; otherwise, only attachment names will be exported.

Please note that the following limits apply when expoting data: