Rons Data Tools - Data Utilities for CSV and Tabular Text Files
A free Windows utility designed to simplify routine tasks associated with processing CSV files.
Rons Data Tools in action (light)
Rons Data Tools in action (dark)
Rons Data Tools brings together a collection of practical tools in one clear, intuitive application for handling large, disk based CSV files.
Why is it free?
Rons Place Software offers a state-of-the-art CSV editor, Rons Data Edit, a powerful application designed to load files into memory for fast and efficient data manipulation. However, some customer requirements do not fit comfortably within the workflow of Rons Data Edit, or are constrained by the practical limitations of processing very large files in memory.
Rons Data Tools was created to address these scenarios. It provides a platform for specialized tools requested by customers, extending the capabilities of Rons Data Edit and offering solutions for workflows that require a different approach.
Note: All the features in Rons Data Tools are the result of customer requests. If something is missing, or could be improved, please contact us.
Overview
Rons Data Tools addresses common data processing needs by providing utilities for:
-
Removing Duplicate Rows:
Identify and remove duplicate rows from a CSV file. -
Merging CSV Files Horizontally:
Combine two CSV files together by joining each row on one, or more, key columns. -
Merging CSV Files Vertically:
Append rows from various CSV files together into a single file, with column alignment. -
Splitting CSV Files Horizontally:
Split the rows from a large CSV file into different files, based on various criterion.
The tool is built with a logical layout that supports both light and dark modes, allowing users to customize the interface with their preferred theme colors.
Removing Duplicate Rows
The Remove Duplicate Rows tool allows the removal of any duplicates it finds in CSV files of any size, by checking a defined list of columns (a key) for duplicate values.
Merging CSV Files Horizontally
The Merge CSV Files Horizontally tool allows the joining of two CSV files at the row level, by using columns in the Left file, to lookup rows with matching columns in the Right file.
Merging CSV Files Vertically
The Merge CSV Files Vertically tool allows the joining of multiple CSV files stacked on top of each other. Columns can be aligned by column number or by name, with multiple options to output column headers.
Splitting CSV Files Horizontally
The Split CSV File Horizontally tool allows a CSV file of any size to be split into multiple smaller CSV files, based on various criterion. Files can be split on row count, percentage ratios, or the value of one or more columns.
Pieter de BruinJust testing with a big file. About 9,6 million ID numbers to be filled with extra data. Speed looks about 50000 URLs per minute. So about 3 million per hour. Job should be done in about 3 hours. Thanks for this tool!
Taran WilliamsRons Data Edit already handles most of my everyday CSV work really well, but I’m glad to have Rons Data Tools for certain jobs like merging files or splitting huge CSVs, especially since it doesn’t need to load everything into memory.
To Get Started
Download Rons Data Tools for free and enjoy its simple installation and easy-to-use design. Start managing your CSV and text files more effectively today
