Company
The Ultimate Add-in to Supercharge your Excel Productivity
Resources
Quick Links
Company
EasySheet Pro
"Universal integration with heterogeneous data ecosystems"
EasySheet Pro implements an advanced connectivity architecture that ensures complete interoperability with multiple data repositories. The platform natively handles import and export from diverse formats, ensuring optimized compatibility with Google Sheets, XML, JSON, structured text files, CSV and Microsoft Access databases. This integration versatility eliminates the barriers between information silos, allowing the implementation of consistent workflows regardless of the data source.
Here are some of the features available:
EasySheet Pro - 2025
EasySheet Pro - 2025
Database Connection
This feature allows users to seamlessly manage data from various file formats and databases, ensuring smooth integration and efficient data handling. It is accessed from the EasySheet Pro ribbon and opens a side panel for import and export operations.
Supported Formats
Excel (.xls, .xlsx)
CSV (.csv)
XML (Structured XML files)
TXT (Text files)
Access (.accdb, .mdb)
SQLite (.sqlite, .db)
JSON (JavaScript Object Notation)
Automatic Data Validation: During import and export, data is automatically validated to ensure integrity and consistency.
Database Management (Access/SQLite)
Text File Management (CSV/TXT)
XML/JSON File Management
Google Sheets Integration
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.