Enquire Now

Data validation in Excel for improved accuracy and efficiency

DQ for Excel™ provides a suite of Data Quality Improvement Tools within the familiar Microsoft Excel environment. Our no code product can be easily downloaded from the Excel add-in store and you can begin to Validate Data In Minutes!

Go further than just Excel data validation

Enrich your customers information, and authenticate emails and phone numbers in real time! Process hundreds of thousands of records at once and only pay for your usage on a pay-as-you-go basis.

KYC within Excel

Through our partnership with Experian you can achieve AML compliance by surfacing KYC data insights within Excel spreadsheets.

Untitled design (7)

Why use DQ for Excel™?

Familiar Environment (4) Free to download

DQ For Excel™ is in the Office Store which is easily found in the "Get Add-ins" function on Microsoft Excel. Pay for what you use and receive 1000 free credits to trial upon registration.

Familiar Environment (2) Familiar environment

DQ for Excel provides access to our DQ on Demand functions with all the flexibility of the Excel ecosystem. It can work directly with user created sheets and exports from SQL server or Microsoft Dynamics.

Credit Based Consumption Pay as you go

Only pay for what you use. Register with DQ Global and Purchase credits from the DQ Global Shop. Then Apply them to whatever service you require.

The benefits of using DQ for Excel™

bubbles Quickly cleanse your customer data

 

Only pay for what you use with our PAYG method (1) Only pay for what you use with our PAYG method

not much time Set up in under 30 minutes

 

familiar evironment Work in the familiarity of your own Excel spreadsheets

Receive free credits on intallation Receive 1,000 FREE credits on registration

 

No obligation (2) No obligation, no subscription and no commitment

Get started

With DQ for Excel™ you can ensure the data within your Excel spreadsheets is accurate and correctly formatted with data validation in Excel. High quality data at point of entry will save you time and improve customer satisfaction.

The DQ for Excel™ suite

Validate

Validate

Check the syntactical validity of Phone Numbers, Email Addresses, I.P. Address, URL’s and more… e.g. A telephone containing 3 digits is not Valid, nor is an email without an ‘@’ symbol

Enrich

Enrich

Cross reference third party data to enrich your database for marketing, sales, or compliance purposes. Add contact or company data to existing datasets and ensure you maintain a complete and accurate database

Compliance

Compliance

Compliance allows you to access Experian's powerful FinCrime data on excel. Acquire new data and enrich the customer data within

Authenticate (3)

Authenticate

Truly confirm if a piece of data, record or entity is Authentic. e.g. Will an email truly deliver to an inbox or telephone number dial

Format

Format

Using our vast metaverse of data transformations, users can leverage this DQ function to format worldwide telephone numbers, email addresses, I.P. address, URL’s

Transform

Transform

Transform data (Abbreviate, Elaborate, Exclude or Normalize) in 5 spoken languages. Choose from 11 different transformation libraries including: Business, Countries, First Names and Addressing… e.g. Abbreviate country transform (United Kingdom to UK)

Compare

Compare

The DQ Compare function gives users the ability to analyse if records are legitimate matches, essential when bulk processing duplicate records. Score the similarity between records and choose from multiple comparison methods

Derive

Derive

Obtain information from a piece of data by analysing its structure, pattern, or values. e.g. derive a gender from a first name, country ISO code from a telephone number, or segment contacts by job roles

Parse

Parse

Manipulate data by splitting data into its constituent parts. Including: Email Addresses, I.P. Address and URL’s

Congruence

Congruence

Compare elements of a record to assess its congruence. Analyse two data field values to examine if they are aligned. For example, does a dialling code align with the country field or ISO code?

Verify

Verify

Match records against reference data, including: Addressing which covers 240 Countries, Location GeoCodes, Company Names and People living at an address

Suppress

suppress

Discover whether people are deceased, gone away, or have expressed a preference not to be contacted

Contact us for more information

The best way to learn more about how our solutions can help is to let us know more about your data challenge.

  • Hidden
  • Hidden
  • Hidden
  • This field is for validation purposes and should be left unchanged.