This feature allows interaction with Google Sheets directly from Excel. It is accessed via two buttons in the ribbon.

Prerequisites
A Google account with access to Google Sheets
Active internet connection
App authorization (requested on first use)

Importing from Google Sheets
Connection: Enter the Google Sheets URL and authorize access.
Sheet Selection: Import either a specific sheet or all sheets within the document.
Data Handling: The import preserves values, formulas (automatically converted to Excel format), and formatting\\(background colors, text styles, number formats, currencies, dates, and times).
Automatic Features:Formula conversion,Number format adaptation,Handling of duplicate sheet names, Color conversion,Management of empty cells

Google Sheets Synchronization
Link Management: The Excel sheet is automatically linked to the Google Sheet, keeping track of its origin.
Sync Options: Update an existing sheet, Create a new sheet if no match is found
Synced Elements: Data and values, Formulas, Formatting (background colors, text styles, number formats)
Synchronization Process: The process is automatic but requires some waiting time for confirmation.

Important Notes
Initial authorization is required for synchronization.
Sheets retain their link after import.
Formulas are converted between Excel and Google Sheets formats.
Formatting is preserved in both directions.
Write access to the Google Sheet is required.
It is recommended to verify the data after synchronization.

Limitations
Charts and images are not synchronized.
Some complex formulas may not be converted.
Conditional formatting is not transferred.
Macros and scripts are not synced.