Skip to main content

How to preview & select columns

Use Awesome Table Connectors’ Preview & Select columns feature to edit your output sheet's layout by choosing the columns you need, editing their names, and configuring a sort order before you run a request.

This article demonstrates how to use the Preview & Select columns feature. As an example, we are using the Zendesk connector to export a list of all articles from our knowledge base to perform a content audit.

  1. Click Preview & Select columns.

    The parameters are key-value pairs for the following: query-nature and per_page-100

    The Preview & Select columns window opens. This window has two main areas in its layout: the Column picker sidebar and the Data table.

    Preview & Select columns modal user interface (UI) with UI elements highlighted.
  2. In the column picker sidebar, deselect all columns using the main checkbox.

    The data table is now empty.

  3. Select the columns you want to get in your output. For each article we are selecting Title, Created at, Updated at and Html URL.

  4. Rename the columns according to your preferences or naming conventions. We are renaming Html URL into Article link.

    The new column name is displayed in the sidebar, along with the original name for reference.

  5. Drag and drop the column headers to reorder the columns. We are moving the Title column to the left.

  6. Click Save changes to save your changes along with your request and exit the window.

    Awesome Table Connectors informs you if your changes have been succesfully applied.

You have successfully previewed, selected columns and saved your output sheet's layout.

What's next

Run your request with the new layout and start your content audit.