DATAshaper

DATAshaper direct transforms Microsoft Excel into a powerful interface for data management. It combines a robust SQL editor with a suite of standalone validation tools to ensure your data is clean and accurate.

1. Data Validation Toolkit

Use our advanced validators to clean your spreadsheets instantly:

• VAT Verification (VIES): Check the validity of European VAT numbers directly against the EU Commission database.
• Address Check (OSM): Verify and standardize addresses using OpenStreetMap services.
• Email Validation: Perform syntax checks and DNS lookups to ensure email domains exist and can receive mail.
• Finance: Validate IBAN checksums to prevent payment errors.

2. SQL Server Editor

Connect Excel directly to your SQL Server to view and edit data in real-time:

• Read & Write: Fetch live data, edit records in Excel cells, and publish changes back to SQL with transaction safety.
• Audit Logging: Keep track of data changes with built-in logging (stored locally or centrally).
• Authentication: Full support for Windows, SQL Server, and Azure AD (Entra ID) authentication.

Note: Designed with a privacy-first architecture. Data processing happens locally and external validation services are only queried upon user request.