BLACK FRIDAY: 50% OFF all Pro plans
Pro from $18 a year or $60 lifetime, no code needed
Ends Cyber Monday, 30 Nov. Lock in the price today
Get 50% Off
Guide

Advanced Data Table Pro

How to set up and style the Advanced Data Table widget in Elementor.

Advanced Data Table builds a table from rows you type, CSV text you paste, or a CSV file. Visitors can sort columns, search the rows and move through pages. Use it for price lists, schedules, comparison data and any spreadsheet you want on a page.

Part of: Bright Addons Pro.

Set it up

  1. Drag the Advanced Data Table widget onto the page.

  2. In the Data section, choose a Source: Type the Rows, Paste CSV or CSV File (URL).

  3. For typed rows, add one item per row under Rows and separate the cells with the | character.

  4. In the Columns section, add one item per column in order and set its Title, Sort As and Alignment.

  5. In Search, Sorting and Pages, turn Search Box and Sorting on or off and set Rows per Page.

  6. Choose how the table behaves On Phones: Rows as Cards (with labels) or Scroll Sideways.

  7. Open the Style tab to set the table, header row, cell, search box and pagination styles.

Content options

Data

Option What it does
Source Where the data comes from: typed rows, pasted CSV or a CSV file address.
Rows The repeater of typed rows. Each item is one table row.
Cells The cells of the row, separated by the / character.
Highlight Row Gives this row the highlighted row color.
CSV The pasted CSV text. Quoted cells with commas and line breaks are supported.
CSV File Address The address of a CSV file in the Media Library or a public CSV link.
Separator The CSV separator: detected, comma, semicolon or tab.
First Row Is the Header Uses the first CSV row as the column titles.

Columns

Option What it does
Columns The repeater of column settings, matched to the columns in order.
Title The header text of the column. With CSV, an empty title keeps the title from the file.
Sort As Sorts the column as text, number or date, or detects the type.
Sortable Lets visitors sort by this column.
Alignment Aligns the column left, center or right.
Hide on Phones Hides this column on phones.

Search, Sorting and Pages

Option What it does
Search Box Shows a search box above the table.
Sorting Turns sorting by column header on or off for the whole table.
Sort First By Column The column number the table is sorted by when it loads. 0 keeps your order.
Rows per Page Rows shown on each page. 0 shows every row on one page.
Row Count Text Shows a line such as Showing 1 to 10 of 25 rows.
On Phones Shows rows as cards with labels, or lets the table scroll sideways.
Sticky Header Row Keeps the header row visible while scrolling a long table.
Bright Addons Pro

Unlock this and 80 more Pro widgets

Bright Addons Pro has 80 Pro widgets plus all 51 free widgets, 10 extensions, a Theme Builder and 32 dynamic tags. From $18 a year, with a 14-day money-back guarantee.

Style options

These sections are in the Style tab.

  • Table

    background, border, radius, shadow, row line color, column lines, striped rows, and hover, highlighted row and accent colors.

  • Header Row

    typography, text color, background, sortable hover background, padding and sort arrow color.

  • Cells

    typography, text color, link color, padding, bold first column and the phone card label color.

  • Search Box

    width, position, typography, colors for normal and focus, padding, border width and radius.

  • Pagination and Row Count

    typography and color of the row count text, and typography, colors, padding and radius of the page buttons.

Tips

  • In typed rows, write a backslash before | to show a real | inside a cell.

  • Cells may hold simple HTML such as links, bold text, line breaks and images. Other tags are removed.

  • Remote CSV files are cached for an hour, so a change in the sheet can take up to an hour to show.

  • The sticky header row only sticks when the table fits the available width.

Questions and answers

Can I show a Google Sheet?

Yes. Publish the sheet as CSV, set Source to CSV File (URL) and paste the link in CSV File Address. The file is fetched by your site and cached for an hour.

How does sorting know if a column holds numbers or dates?

With Sort As set to Detect, a column where every cell is a number, including prices and percentages, sorts as numbers. A column of dates sorts as dates, and everything else as text.

Does the search look in every column?

Yes. It checks the text of the whole row, and when a visitor types several words, a row must contain all of them.

Need more help?

Check the troubleshooting guide, or contact support with the page address and what you expected to happen.

Troubleshooting guide
All guides