- Refine data easily
The toolkit covers the best part of all essential data preparation needs.
- Minimize errors
Get rid of manual data manipulations and prevent human errors.
- Get quality data
Get clean, well-formatted and reliable data for further analysis.
- Process bulk data
Process dozens of worksheets and thousands of rows in a click.
- Pay once & use forever
Lifetime license, 1 year of free upgrades, free support.
Transform and rearrangetables, sheets and workbooks
RunSQL queriesdirectly on Excel tables
Query and transform your Excel tables using SQL. Generate SELECT statements, use LEFT JOIN, GROUP BY, DISTINCT, and other SQLite operators.
Intuitive query editor displays all available tables and highlights syntax.
Calculate, aggregate and match values
Export Excel to CSVwith your custom settings
Easily convert Excel tables to plain text CSV files. Choose tab, pipe or any other delimiter. Set UTF-8, ISO or other character encoding.
Unlike the standard “Save As CSV” operation, exporting a range proceeds without closing the original Excel file.
Send personalized emailsto your Excel contact list using Mail Merge
Send work and marketing emails to people in your Excel contact list without leaving Excel interface!
Set up mail merge (without Word) with your Outlook, Gmail, or other email account and send personalized emails in a click.
Enjoyhandy productivity toolsand shortcuts
Also included in Data Prep toolkit
Insert dates and time in cells from a handy Popup Calendar. Simply select a cell and pick the necessary date or time from the date picker.
You can also embed the calendar into your workbooks and make it a part of spreadsheets you share with other people.
Popup Calendar toolsto insert dates in cells
Get started in no time
Download and try free for 14 days
- MS Excel 2010 — 201932-bit and 64-bit
- Windows 7 — 1032-bit and 64-bit