This page contains examples of text tables that you can filter with the set of available filters. Please try to use the macro in each specific situation.

Generic table data filtration

Please select one or multiple values to filter data in the table below.

,,,150,150,150,150Last NameCity,First Name,Occupation1457694137940_-159727723

Last Name	First Name	Occupation	City
Doe	John	Developer	London
Fry	Philip	Delivery boy	New York City
Doe	Janet	Scientist	Tokyo
Farnsworth	Hubert	Scientist	New York City
Farnsworth	Cubert	Student	New York City

Regular expressions and default values for filtratio

Please note that Table Filter macro allows you to define default filter values for table columns. These values will be automatically applied upon each reload of the page. You can also use regular expressions for flexible data filtration.

Doe|FryLast Nameyy-mm-dd1457694292173_-997170632Point (.)

Last Name	First Name	Occupation	City
Doe	John	Developer	London
Fry	Philip	Delivery boy	New York City
Doe	Janet	Scientist	Tokyo
Farnsworth	Hubert	Scientist	New York City
Farnsworth	Cubert	Student	New York City

Doe,,Last Name, Cityyy-mm-dd1457694296418_-997170632Point (.)

Last Name	First Name	Occupation	City
Doe	John	Developer	London
Fry	Philip	Delivery boy	New York City
Doe	Janet	Scientist	Tokyo
Farnsworth	Hubert	Scientist	New York City
Farnsworth	Cubert	Student	New York City

Table filtration by the user-entered keyword

Please note that Table Filter macro allows you to add free-text fields for dynamic data filtration depending on the specified query.

Try to start entering some values for filters to get dynamic filtration of the table.

,,,,,,First Name,City,Last Name,Occupationyy-mm-dd1457694300404_1866020122Point (.)

Last Name	First Name	Occupation	City
Doe	John	Developer	London
Fry	Philip	Delivery boy	New York City
Doe	Janet	Scientist	Tokyo
Farnsworth	Hubert	Scientist	New York City
Farnsworth	Cubert	Student	New York City

Filtering throughout the table

The global filter allows you to dynamically filter values in all columns of your table. Enter some query to get the table filtered.

yy-mm-ddtrue1457694304175_1866020122Point (.)

Last Name	First Name	Occupation	City
Doe	John	Developer	London
Fry	Philip	Delivery boy	New York City
Doe	Janet	Scientist	Tokyo
Farnsworth	Hubert	Scientist	New York City
Farnsworth	Cubert	Student	New York City

Filtering multiple tables at once

You can filter several tables at a time. Just paste two or more tables into the macro.

,,100,150,200Last Name,First Name,Occupationyy-mm-dd1457694308097_-1576072861Point (.)

Last Name	First Name	Occupation	City
Doe	John	Developer	London
Fry	Philip	Delivery boy	New York City
Doe	Janet	Scientist	Tokyo
Farnsworth	Hubert	Scientist	New York City
Farnsworth	Cubert	Student	New York City

Last Name	First Name	Occupation	City
Brown	Adam	Developer	New York City
Fry	Andy	Delivery boy	London
Black	Jane	Scientist	Tokyo
McCarthy	Hubert	Scientist	New York City
McCarthy	Cubert	Student	London