Free Excel Add-ins – Spreadsheet Tools

Details: Bug fixes and performance improvements.

Let us see the first add-in! Further expansion will take place in this direction!

DataXL – Free Excel Productivity Add-in

We proudly present our improved tool!

Text Tools and Smart Utilities 

Text processing and string manipulations in Excel are not an easy tasks but we’ll help you to simplify string related functions using our add-in.

Feature list:

1. Convert text to uppercase, apply Excel lowercase to your data or convert your text values to proper / title case
2. Delete first or last character from a selected string
3. Delete x characters starting at the nth position
4. Remove spaces, non-printable characters, all line breaks, initial apostrophes
5. Insert text before first, after last character
6. Insert text starting at nth position and much more….

• Calendar. Quick dates entry to save your time.
• Drop-down list creator: Create drop-down list in selected cells in seconds

Spreadsheet Tools – Effective management for Ranges 

• Data Collector: Collect data from selected sheets.
• Split Ranges: Split one data table into several different sheets based on the values of the specified column or other criteria.

Splitting methods:

1. by values of column no. ‘n’
2. by fill color of column ‘n’
3. by horizontal page breaks
4. by blocks of ‘n’ rows

• Compare Ranges: Comparison of the two ranges and the output or highlighting of coincidences / differences between them.
• Clean Ranges: Delete text, formats, notes, hyperlinks, conditional formatting, etc. in selected cells.
• Screenshot Manager: Create screenshot of selected range and export it into various formats.

Worksheet and Workbook Tools

• Sheet Manager: Perform vary operations (adding, sorting, protecting, etc.) on sheets in current workbook.

Feature list:

1. Short Sheets
2. Copy selected sheets n-times
3. Protect or unprotect sheets
4. Change visibility of selected sheets
5. Sync all shets
6. Add Table of Contents (TOC) sheets
7. Save selected sheets as separate files
8. Delete unused empty rows or columns from selected sheets

• Split Sheets to Files: Save sheets in separate files using user-friendly interface.
• Workbook Cleaner: Clean current workbook of unnecessary data, formats, images, macros, etc. making file smaller and faster.

Feature list:

• Delete empty and hidden sheets in the actual workbook
• Delete unused, empty rows and comments on all sheets

Formula Audit Tools

Good news! We’ve updated the free excel add-in with a powerful formula audit tool!

Smart Precedents Checker: Opens a dialog box that contains links to all precedent cells relied upon for calculation of the active cell. You can quickly navigate to each precedent cell, including those on other worksheets and in other workbooks. This tool will attempt to open any external workbooks containing precedent cells.

Smart Dependents Checker: Opens a dialog box that contains links to all dependent cells whose calculation relies upon the active cell. You can quickly navigate to each dependent cell, including those on other worksheets and in other workbooks. This tool will attempt to open any external workbooks containing dependent cells.

Last Audited Cell: Return to the last cell audited using Smart Precedents or Dependents.

User Defined Functions and Library browser

We’ve just added 80+ UDF to boost your productivity using special functions!

Download

Older versions:

Download DataXL v5

STAY TUNED.