Process Your Excel Data Simpler and Faster

Published on 26 Oct, 2018 by Milos Gregor


This month I released new tool. Reshape.XL is a general purpose tool for effective data processing (wrangling) in Excel. This tool is released as a small installable add-in for Excel.

I have the idea of this tool in my head for a longer time. This summer, the time has come to implement. In Excel, you can do a lot of work with data. If your data are incomplete, in raw form or large, it may be difficult to work with. You must combine several approaches, such as basic formulas, VBA, Power Query, Power Pivot or other third-party tools. Exactly for this reason I created Reshape.XL.

Reshape.XL smoothly combines in one framework features that are normally available in several tools and their combination is challenging or impossible. Similar features are available in programming languages such as R or Python. In Reshape.XL you have these options accessible in a simple and powerful visual interface, without need of coding or complicated formulas. The architecture is based on the Grammar of Data and the tool is strongly inspired by up-to-date data science framework - tidyverse in R language.

Processing steps that took hours are now only take minutes. I really recommend you to look at this tool. If you work with data in spreadsheets this tool can save you an incredible amount of time. On the contrary, mastering the workflow in add-in is a matter of minutes. Reshape.XL is my newest tool and I’m really proud of it.