> For the complete documentation index, see [llms.txt](https://doc.biwee.fr/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.biwee.fr/english/data-connection/files.md). # Files connectors ## Excel file ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-MQCuJOsR3ypRxhpdOfb%2F-MQD34iidrp20oQdoy99%2Fimage.png?alt=media\&token=78087417-b455-4b4e-9768-6a28666cf02a) No matter if you want to access it locally or online you have to specify a connection name. ### Stored locally ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd65i6oTCPdIJ9qGxM%2FExcelLocal.png?alt=media\&token=c57d65e6-c26c-4e8f-8e5e-3a5987603429) It is possible to add an Excel file in several ways: * By dragging and dropping it into the drop zone. * A click on the drop zone opens the Windows explorer where you can select your Excel file. * Enter the location of your file. {% hint style="info" %} Don't forget to fill in the password if the Excel workbook is protected. {% endhint %} ### Stored on a FTP/SFTP ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd65i3j9QwuxbgQFV4%2FExcelFTP.png?alt=media\&token=ab5052ef-287e-4075-bf61-d36c04e765e3) To access your Excel file on an FTP you must fill in the following fields: * **FTP Server** * **Full location of the file** * **Authentication**: * Username * Password ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd65i1X7JmW9WIXcUX%2FExcelSFTP.png?alt=media\&token=ca083797-f65f-4086-abd6-6c764855abe9) * **SFTP settings** * Key SSH * PassPhrase {% hint style="info" %} Don't forget to fill in the password if the Excel workbook is protected. {% endhint %} ### Stored on One drive / Google drive ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd65i5VJUmkDYFSXz6%2FExcelODrive.png?alt=media\&token=f326b12e-ae9f-4cb0-a969-884b3b7edb5a) ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd65i2mJFp5iwLdLZ0%2FExcelGDrive.png?alt=media\&token=92e2ca4e-e19c-4876-aff7-827155fda156) To access your Excel file on a One drive or a Google drive, connect to your account: Once you have logged in and authorized Biwee to access your files you can return to Biwee where you will select your Excel file. ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd62h_RGsU_ar6GbBg%2Fdrive.png?alt=media\&token=06457271-4f9a-4640-9a1d-e2f55c0e90af) ### Query definition for Excel files Once your file is loaded, you have the possibility to choose the sheets to use. To do this you can either: * Check the sheets to load * Enter a regular expression that will define all the sheets to be loaded :warning: In order to load several sheets, they must have the same number of columns, the same name and be in the same order. #### Method 1: Select sheets from the drop-down list ![1st method - Select sheets](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-ML7J3m_7oFtqqYdq0mw-1972196547%2Fuploads%2Ff1oBXMTOHeHQR1pRQfMz%2FMultipleSheets.png?alt=media\&token=d685e367-98aa-4991-902d-9aaae001df8a) Biwee takes care of concatenating the data from the selected sheets into a single data grid. In the "Results" tab, you can see all the data of the selected sheets and an additional column indicates the corresponding sheet. ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-ML7J3m_7oFtqqYdq0mw-1972196547%2Fuploads%2FTCqDaIT2mK3ZsVvemnWI%2FSheetName.png?alt=media\&token=647a33b6-4f45-48a0-b07c-bcac83ef672d) #### Method 2: selection of sheets by regular expression To do this, check the option "Use a regular expression" and in the free text area enter the desired regular expression. In this example, by entering "***^Sales***", Biwee will load the data of all sheets whose name starts with ***Sales***. ![2nd method - Regular expression](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-ML7J3m_7oFtqqYdq0mw-1972196547%2Fuploads%2FCdU5OBrvxufvyryr836t%2FRegularExpression.png?alt=media\&token=6e144829-2e5e-4c0c-a022-1bba3fc0b00b) Biwee takes care of concatenating the data from the selected sheets into a single data grid. In the "Results" tab, you can see all the data of the selected sheets and an additional column indicates the corresponding sheet. ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-ML7J3m_7oFtqqYdq0mw-1972196547%2Fuploads%2FfgucyqoyPU2jQHPbHAD8%2FRegularExpressionColumnName.png?alt=media\&token=fabc4474-03e7-4c16-8ff6-0877a997a3ce) **Common regular expressions** Here are some regular expressions that can be useful : * select all the sheets whatever the sheetnames `.` * select all the sheets whose name starts with the word : `^word` * select all the sheets whose name ends with the word : `word$` * select all the sheets whose name contains one or many numbers : `\d` or`[0-9]` * select all the sheets whose name contains one or many low case characters : `[a-z]` It is possible to combine different sets, for example: * select all the sheets whose name contains numbers, letters or underscores: `[a-zA-Z0-9_]` or`\w` * select all the sheets whose name start with `Sales` and tha ends with a date MM\_YYYY (for example exemple `05_2023`): `^Sales.*\d{2}_\d{4}$` This regular expression checks if the sheetname starts with Sales with the expression `^Sales` Then, it accepts all the characters (`.`) repeated from 0 to many times (`*`), with the expression `.*` Then it checks if the name ends with exaclty two digits `\d{2}` followed by an underscore `_` then exactly 4 digits `\d{4}` with the end marker `$` The regular expression `^Sales.*\d{2}_\d{4}$` enables to get the following sheetnames for example : *Sales\_05\_2023, Sales\_06\_2023, SalesProducts\_France\_06\_2023, etc.* ## CSV file ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-MQCuJOsR3ypRxhpdOfb%2F-MQD37hQ0vaxxwCKVYM9%2Fimage.png?alt=media\&token=34cf8067-680e-4185-ab75-3adc5e3e06e3) No matter if you want to access it locally or online you have to specify a connection name. ### Stored locally ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd63mvgLbYyNTHPiqE%2FCSVLocal.png?alt=media\&token=34dc17ef-bd78-4d55-aa50-8e2c980ec5ea) It is possible to add a CSV file in several ways: * Drag and drop in the drop zone. * A click on the drop zone opens the Windows explorer where you can select your CSV file. * Enter the location of your file. ### Stored on FTP/SFTP ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd63my5avxWgjF8ZYh%2FCSVFTP.png?alt=media\&token=79e23c44-b77b-4539-b09c-282164757c35) To access your CSV file on an FTP you must fill in the following fields: * **FTP Server** * **Full location of the file** * **Authentication** : * Username * Password ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd63n-8kC7Ulcv47dl%2FCSVSFTP.png?alt=media\&token=53e5f6ab-cd6c-408e-abb9-cf9848ea3596) * **SFTP Settings** * SSH Key * PassPhrase ### Stored on One drive / Google drive ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd63n0L6NgtsAXWLKJ%2FCSVODrive.png?alt=media\&token=e119e00b-9dff-44a5-b4b5-6daa4dfe945f) ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd63mzkMAlfcTHZcbn%2FCSVGDrive.png?alt=media\&token=59ae9ff8-3543-4711-9da6-2538fe882b5e) To access your CSV file on a One drive or Google drive, log in to your account: Once you have logged in and authorized Biwee to access your files you can return to Biwee where you will select your CSV file. ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd62h_RGsU_ar6GbBg%2Fdrive.png?alt=media\&token=06457271-4f9a-4640-9a1d-e2f55c0e90af) ### Properties definition for CSV files For a better reading of the CSV file, please fill in: ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd63mwT7867UlNEvFt%2FProperties.png?alt=media\&token=c178471e-87f2-4574-99c9-b9fc02cd8c88) ## Json ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-MQCuJOsR3ypRxhpdOfb%2F-MQD3B5zJkv1o0Y6qfNl%2Fimage.png?alt=media\&token=92328ebc-752f-40bb-9e93-a565da0893a4) No matter if you want to access it locally or online you have to specify a connection name. ### Stored locally ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd67NIpVTvvfGK7jNC%2FJsonLocal.png?alt=media\&token=50739e11-07e2-45eb-a515-41730f7149ca) It is possible to add a Json file in several ways: * Drag and drop in the drop zone. * A click on the drop zone opens the Windows explorer where you can select your Json file. * Enter the location of your file. ### Stored on FTP/SFTP ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd67NFgnM-pbDS_vTC%2FJsonFTP.png?alt=media\&token=48e0d229-40a9-4279-89d9-7def6d7d2ba2) To access your Json file on FTP you must fill in the following fields * **FTP Server** * **Full location of the file** * **Authentication** : * Username * Password ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd67NKrxA7mtrEooqX%2FJsonSFTP.png?alt=media\&token=5f09a3f1-b0db-4e88-b178-c721d5846a05) * **SFTP settings** * SSH Key * PassPhrase ### Stored on One drive / Google drive To access your Json file on a One drive or Google drive, log in to your account: ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd67NJdD_TF1pwpBls%2FJsonODrive.png?alt=media\&token=0e5c16c8-a04d-4944-bf27-e7911a84bf32) ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd67NG-QjDSZC3-VS7%2FJsonGDrive.png?alt=media\&token=3a0cacde-c741-43ec-99e2-45c4d1557c9f) Once you have logged in and authorized Biwee to access your files you can go back to Biwee where you will select your Json file. ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd62h_RGsU_ar6GbBg%2Fdrive.png?alt=media\&token=06457271-4f9a-4640-9a1d-e2f55c0e90af) ### ### Properties for JSON files ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd67NLXdGxgpzNSmi3%2FProperties.png?alt=media\&token=74be9508-0495-45be-9608-975673bc75ea) ## Google Sheets ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-MQCuJOsR3ypRxhpdOfb%2F-MQD3MddpUqCYTst8Psr%2Fimage.png?alt=media\&token=c0792745-8640-45f4-921e-2d19c9a0040f) You must fill in the field "Connection name" with what you want. To access your Google Sheets file on a Google drive, login to your account: ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd62ha2m7uGo-vOjEg%2FGoogleSheets.png?alt=media\&token=61a1e104-ec03-4101-856f-e9c7521bd618) Once you have logged in and authorized Biwee to access your files you can go back to Biwee where you will select your Google Sheets file. ![](https://1155922781-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-ML7J3m_7oFtqqYdq0mw%2F-Mjd5k3nNKvHgGUF31Ho%2F-Mjd62h_RGsU_ar6GbBg%2Fdrive.png?alt=media\&token=06457271-4f9a-4640-9a1d-e2f55c0e90af)