can we import excel files using wildcards ?

Yes, you can import Excel files using wildcards in Airbyte. This is possible with connectors like Microsoft OneDrive, Microsoft SharePoint, Google Cloud Storage (GCS), Azure Blob Storage, S3, and Google Drive. These connectors support glob-style patterns, which allow you to reference multiple files with just one pattern. For example,

**/*.xlsx

would match all Excel files in the folder. Here are some example patterns: -

**

: match everything. -

**/*.xlsx

: match all Excel files. -

myFolder/**/*.xlsx

: match all Excel files anywhere under myFolder. -

*/**

: match everything at least one folder deep. -

*/*/*/**

: match everything at least three folders deep. -

**/file.*|**/file

: match every file called "file" with any extension (or no extension). -

x/*/y/*

: match all files that sit in sub-folder x -> any folder -> folder y. -

**/prefix*.xlsx

: match all Excel files with a specific prefix. Please note that each path pattern is a reference from the root of the folder, so don't include the root folder name itself in the pattern(s). Sources: - [Microsoft OneDrive](https://docs.airbyte.com/integrations/sources/microsoft-onedrive#path-patterns) - [Microsoft SharePoint](https://docs.airbyte.com/integrations/sources/microsoft-sharepoint#path-patterns) - [Google Cloud Storage (GCS)](https://docs.airbyte.com/integrations/sources/gcs#path-patterns) - [Azure Blob Storage](https://docs.airbyte.com/integrations/sources/azure-blob-storage#path-patterns) - [S3](https://docs.airbyte.com/integrations/sources/s3#globs) - [Google Drive](https://docs.airbyte.com/integrations/sources/google-drive#path-patterns)