Skip to main content
Tab Pattern

Dynamically select tabs in an Excel or Google Sheet file using patterns to match tab names in Savant.

Updated this week

The Tab Pattern option in Savant allows you to dynamically select one or more tabs based on their names. This is useful for files with many tabs where you need to match specific naming conventions without manually selecting each one.

Configuration Options

  1. Select Tab Pattern under the Tab Settings section.

  2. Enter a pattern to match tab names. Patterns use wildcards to create flexible rules:

    • * (asterisk): Matches zero or more characters.

      • Example: Orders* matches tabs named Orders_Q1 and Orders_2024.

When to Use Tab Pattern

Use Tab Pattern when:

  • Your file(s) contains many tabs with predictable naming structures.

  • You want to dynamically include all tabs that follow a naming convention (e.g., Sales*, Data_202*).

If the selected tabs have inconsistent schemas, Savant will display an error. Use Common Headers to include only the shared columns across the matched tabs.

Did this answer your question?