Varonis announces strategic partnership with Microsoft to accelerate the secure adoption of Copilot. Learn more

Seven Free Data Wrangling Tools

Reformatting, de-duping, merging, and filtering are just some of the functions that go under the broad category of data wrangling. It’s all the scrubbing and cleaning that data scientists apply...
Michael Buckbee
2 min read
Last updated February 25, 2022

Reformatting, de-duping, merging, and filtering are just some of the functions that go under the broad category of data wrangling. It’s all the scrubbing and cleaning that data scientists apply to raw data before it’s ready for real analysis. Even The New York Times ran an article about this less glamorous side of Big Data, referring to wrangling as ‘janitor work’.

We prefer to see it instead as an important first step to understanding and gaining insights into the datasets you’ll be dealing with. However, this doesn’t have to be a tedious manual task.

Get the Free PowerShell and Active Directory Essentials Video Course

There are some great free tools available that can make this part of data science less of a chore. Cindy and I scoured the Internet to put together the following list of powerful wrangleware.

1. Tabula

Ever had to convert a table data embedded in a PDF into a spreadsheet? There should be a better way to do this than pasting raw PDF into Excel, and then spending hours forcing the messy data into the right columns. The very smart Tabula does this task automatically. It’s available as a Github project. It’s great for marketers, data journalists, financial analysts, as well as data scientists.

2. OpenRefine

OpenRefine was a Google code project that now lives on as open source software. Its friendly GUI is very good at letting you describe and then manipulate data. It was meant for non-data scientist to use directly, but it has a powerful set of programmable expressions for more sophisticated tasks.

3. “R” packages

R is an important programming language for data scientists. It has serious support of statistical and probability functions, and excels at handling slabs of numeric data, unlike general purpose languages. R can be extended through a series of libraries or packages so you don’t have to reinvent the data wrangle wheel. R programmers have used the functions in the popular dlpr and tidyr packages to help them tame unruly data. There’s a good overview of how to wrangle with R, courtesy of the folks at ComputerWorld.

If you’re new to R and want to give it a try, there’s a great interactive tutorial over at Code School.

Wrangle data visually with DataWrangler.

4. DataWrangler

Highly recommended by top analysts, visualizers and data scientists, DataWrangler is an interactive tool for data cleaning. It takes messy, real-world data and transforms it into data tables. Then you can export to Excel, Tableau, R, etc. The goal: spend less time manually formatting and more time analyzing your data.

5. CSVKit

csvkit can help convert data – from Excel to CSV, JSON to CSV, Query with SQL and much more! Simply put, csvkit will make your data wrangling life easier.

6. Python and Pandas

Python of course is an excellent language for data manipulation. Add on the Pandas library, which includes its DataFrame object, and data scientists can quickly perform even more complex operations. For example, merging, joining, and transforming huge hunks of data with a single Python statement.

7. Mr. Data Converter

Mr. Data Converter is straight forward – it takes Excel data and transforms it to web-friendly formats like HTML, JSON and XML.

What should I do now?

Below are three ways you can continue your journey to reduce data risk at your company:


Schedule a demo with us to see Varonis in action. We'll personalize the session to your org's data security needs and answer any questions.


See a sample of our Data Risk Assessment and learn the risks that could be lingering in your environment. Varonis' DRA is completely free and offers a clear path to automated remediation.


Follow us on LinkedIn, YouTube, and X (Twitter) for bite-sized insights on all things data security, including DSPM, threat detection, AI security, and more.

Try Varonis free.

Get a detailed data risk report based on your company’s data.
Deploys in minutes.

Keep reading

Varonis tackles hundreds of use cases, making it the ultimate platform to stop data breaches and ensure compliance.

5 Data Governance Reports for Data Owners
This blog will cover five Varonis reports that you can automatically generate for data owners to promote strong data governance practices. We will show you how to create, customize, schedule,...
What is Human Generated Data?
Unlike business application data, like a billing database or CRM system, or machine-generated data, such as the log files that servers generate, human-generated data is comprised of the emails, Word...
It’s Here! The 2019 Global Data Risk Report Reveals Every Employee has Access to 17 Million Files
If you could take the temperature of data security risk at more than 700 enterprises around the globe, what would you find? Every year, Varonis gives the world a behind-the-scenes...
Varonis Introduces Universal Classification Support for Databases
Integrate Varonis with virtually any network-connected database to discover and classify sensitive data at scale with pinpoint accuracy.