About the Preview & Select columns popup

Awesome Table Connectors’ Preview & Select columns feature is a powerful tool that you can use 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.

Overview of the Preview & Select columns popup

Area	Description
Column picker sidebar	Contains the properties from your import. Selecting or deselecting a property in the sidebar allows you to add or remove its corresponding column in the data table. Additonally: Clicking or hovering over a property in the sidebar highlights the corresponding column or nested columns in the data table. Clicking or hovering over a table cell highlights its corresponding column in the sidebar. If the property is a child and its parent is collapsed, the parent is identified.
Data table	Displays the columns selected for import.

Preview & Select columns actions

Action	Description
(1) Display full names	Toggles full or short property names for nested properties. Properties with custom names aren't affected.
(2) Search	Enables you to search for any string contained in a property name, including nested ones.
(3) Sort	Sorts the entire table by the selected column or row. Click: once to sort by ascending values twice to sort by descending values three times to disable sorting
(4) Rename	Enables you to edit any column/row header in your table.
(5) Move column/row	Moves any column or row to any location on your table. You can use the following actions to move columns: Move to beginning Moves a column to the leftmost position if the table is oriented vertically or a row to the top position if the table is oriented horizontally. Move to end Moves a column to the rightmost position if the table is oriented vertically or a row to the bottom position if the table is oriented horizontally. Drag Drags and repositions any column or row (depending on your table's orientation) by clicking on a column or row header using your mouse.
(6) Transpose data	Transforms columns into rows to orient the table horizontally, or rows into columns to orient the table vertically.
(7) Show more	Displays a table cell's entire contents in a toolip when hovered over. Only applies for table cells which content is too long to be displayed on the default column width.
(8) Reset all changes	Resets all changes that you have made while editing your table. Warning: Once you choose to reset, you can't undo its effect. You will have to edit your layout again manually.
(9) Show raw response	Enables you to view data without table formatting. This view gives you two additional options: Copy to clipboard - Copies the raw data onto your clipboard. Download - Downloads the raw data in JSON format.
(10) Select all	Selects or deselects all properties or only those that match specific search criteria. Clicking the drop-down expands or collapses all nested properties.

What's next

Preview & Select columns to customize your output sheet's layout.