Account Management
Entities
Actions
Account Management
Entities
Actions
DQ For Excel™ is a Microsoft Add-in that works right inside Microsoft Excel, it’s familiar and simple to use! Import data from almost any source, prepare it, master it and perfect it; then upload it back to almost any target. Process hundreds of thousands of records at once and only pay for your usage on a credit based model.
DQ For Excel™ is powered by DQ on Demand™, DQ Global's Data Quality as a Service (DQaaS) Data Quality Improvement Platform.
DQ on Demand™ is a Data Quality as a Service (DQaaS) Data Quality Improvement Platform. DQ on Demand™ delivers a suite of data quality improvement utilities, designed to make the task of enterprise data management simpler.
DQ for Excel™ can be installed in minutes from the Microsoft Office store.
DQ for Excel™ can be found in the Microsoft Office store which you can access via heading to the Insert tab within Microsoft Excel and selecting 'Get Add-ins'.
A full Installation Guide can be found here.
Billing for DQ for Excel™ is transactional, i.e. each request will consume credits, which can be spent on any of the available services. The application can be installed free of charge from the Microsoft Store.
Credits can be purchased at the DQ Global Shop which can be found at https://shop.dqglobal.com/.
If the operation was not processed by DQ on Excel™ then no charge will apply.
Records are processed in batches of 1000 for all first party functions.
This is most likely due to permissions not being granted to the API key. Head to https://shop.dqglobal.com/my-account/ and Login. From there, head to the Permissions section on the left-hand menu. From here, you will be able to add permissions to use first-party and third-party functions. If the problem still persists, please contact the DQ Global Support team (support@dqglobal.com).
If your PC is running at a display scale other than 100%, run MS Excel in Compatibility Mode to avoid display errors.
If you have any questions, please contact us at support@dqglobal.com and we will get back to you as soon as possible.
A data type, in programming, is a classification that specifies which type of value a variable has and what type of mathematical, relational or logical operations can be applied to it without causing an error.
Examples of different data types you might be using with DQ for Excel™ include:
string - A sequence of characters and the most commonly used data type to store text. Additionally, a string can also include digits and symbols, however, it is always treated as text
string[][] - A table of strings, it's used to represent multiple values returned by a spilling function
boolean - This represents the values true and false. When working with the boolean data type, keep in mind that sometimes a boolean value is also represented as 0 (for false) and 1 (for true)
number - Often used as a data type that includes both of the following types: