Company

The Ultimate Add-in to Supercharge your Excel Productivity

logo256 2025-01-06 16_00_47

Resources

Quick Links 

Company

EasySheet Pro

Data Import and Export

 

"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:

easylogo32

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)

  • Create & Update: Ability to create new databases or update existing ones.
  • Table Structures: Automatically manages table structures to ensure correct data organization.

 

Text File Management (CSV/TXT)

  • Format Detection: Automatically recognizes the file format to simplify import.
  • Special Characters & Delimiters: Effectively handles special characters and delimiters, supporting various encoding types.

 

XML/JSON File Management

  • Data Type Conversion: Automatically converts data types to ensure compatibility.
  • Nested Structures: Efficiently processes complex and nested data structures.
  • Syntax Validation: Checks for syntax correctness, providing detailed error messages in case of issues.
espug-dbconn01.jpeg

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.

espug-gsheet04.jpeg