This software is absolutely amazing! Using Easy Data Transformation, I was able to stack 4 Excel workbooks, trim the data, remove unneeded columns, unpivot the data (this is huge), stack the new dataset with another Excel workbook, concatenate columns, filter, sort, pivot, summarize and export to Excel, in less than 15 minutes. This would have taken me hours to do in Excel. The genius of this software is that you get to see each transformations results in real time! If you made a error in data transformation, you see it instantly!! I love this software and so will you!!
The tool is simply amazing by the way! Best data transformation tool I’ve even seen my entire career. Wish I had of found it years ago.
We've used Access and Excel to do this sort of work for 20 years! Every so often I look around for something better. And I found your software using Google last week. It seemed exactly what we'd been looking for. I've already replaced some of the transforms I do. It's super-easy to use.. and fast. A couple of things I really like:
* Most of our systems are cloud-based and we process a lot of confidential client data. Doing this work on a PC is one less thing to worry about.
* And the way you implemented splitting one file to many is very clever.
I haven't found anything I can't do, yet. But will let you know if I do. Thanks for coming up with such a great piece of software. I'm a very happy customer.
I’m so glad I found Easy Data Transform. It’s saved hours of development time. I was about to write multiple complicated scripts to clean up and combine hundreds of thousands of .json files, but with Easy Data Transform’s interface I’ve been able to complete the task in under an hour. Everything is now ready for the database import and regular processing. I love being able to visually see the changes at every stage of the process. So grateful and thanks again for your incredibly fast response to my support request.
I’ve been using EasyDataTransform for the past couple of years on a massive data migration project I’ve been working on. I just wanted to email you to say what a massive difference EasyDataTransform makes - I use it pretty much daily, and I really can’t being to imagine being able to fulfil my role without it.
Just a quick comment on EDT - wow! I love it and use it mainly for cleaning up downloaded CSV or tab-delimited text files. It relegates all those dusty old sed/awk/perl/python scripts to the bit-bucket.
After years writing scripts for my bits and pieces of data, along comes a new "disruptor" product; Easy Data Transform. It dawns on me that lots of scripting will now become unnecessary. If you've ever seen a dog snapping at a wasp, that's how quickly the result appeared! Using EDT is as easy as plugging little plastic bricks together - and just as much fun! Without programming, EDT makes detailed ad-hoc examination of your data possible. Back in the day, I'd mentally compare the desire for a 'what if' answer from my data with the time it would take to write the script - so often the question was left unanswered. Easy Data Transform has changed that.
I am so impressed by what EDT does. In managing my finances each month, I take many credit card statements, bank account statements, and cost category files and merge them together at the beginning of each month for the prior month. This used to take 2-3 hours each time I did this. I now have EDT set up to do this and all I have to do is change the input files each month and the formatting, aggregation, and summarization all happens instantly. I set up checkpoints and error “reports” along the transform flow so I can look at various nodes to see if things are formatted and adding up the way they should be. It is such a powerful tool. I also use it to explore the famous comprehensive baseball database (Lahman I think). EDT is really a totally cool tool. I have done joins resulting in 3-4 million records and EDT handles it easily.
Easy Data Transform is now an essential part of my software toolkit when working with Excel files. It’s already paid for itself many times over in terms of time saved, and its simplicity of use means you can jump in and start benefitting right away. If you have to handle large, messy Excel files, you need this program.
Oh my god! I have been looking for a tool like this for ages! All too often I have to ingest a spreadsheet into a scripting language just to iterate over the rows and do some basic transforms. Simple stuff, but way too complex for excel functions. Basically a way to treat a tabular spreadsheet and perform some SQL commands on it. This tool is awesome!
I downloaded the trial and merged 6 files, some with over 2 million rows of data. I cleaned it up, removed what I didn’t need, filtered, and exported the data into a single easy to read spreadsheet. After that - I was sold. I didn’t even wait to see if I could convince my work to buy the software, choosing to make the purchase myself.
Your app is now a central piece of my daily workflow. I'm a UNIX system administrator and a big part of the day I have to work with text files, specially to support our staff. I'll be honest, my Perl scripts were running short of massaging the amount of data I was working on. Lists of image files, data catalogs, converting, merging, etc. Which required constant rewriting and modification of my scripts to adapt to the task, very time consuming over time. One of our staff experiments had a massive amount of raw data that has to be transform into something more manageable and useful, so my search for an alternative started. Easy Data Transform hits the sweet spot. I have to admit that I'm still learning its capabilities, but it has helped me a lot with many of my tasks.
I just used [version] 1.7 for a major project - worked like a dream and flawless. I created an entire Payroll validation from Legacy suite to new system in less than 90 minutes: 1) Data manipulation in Easy Data Transform - 10 minutes (this would have taken several hours in Excel manually). 2) Data verification and manual checks - 45 min. 3) Excel Report Formatting - 35 min. Entire Process was easy and flawless.
I trialed the software and it made what was previously a very difficult and finicky process involving BBEdit and Excel simple, so I bought it. I probably won’t use it more than 4-5 times a year, but when I need it, it saves a ton of time.
I see EDT is still being updated frequently and regularly so you're clearly keeping busy! And I should add my thanks for keeping EDT as good as it is -- it remains a brilliant program, up there with the short list of things I often recommend to like-minded souls who don't mind thinking outside of stereotypical boxes.
We were surprised how fast Easy Data Transform is. It processed our ~100,000 rows of data in just seconds, where our existing solution needed minutes. It took us less than an hour to transfer a script that filters and merges different datasets to Easy Data Transform. A script that initially took us days to write and test in our existing solution. Easy Data Transform is intuitive, fast, and simply does the job.
I truly enjoy using your software that helps me even for smaller chores (sorting through a list of 60 e-mails with "name, first name <firstname.lastname@example.org>" and generating two columns with the names and the mails) that can be done by hand or with other software, but way faster and more enjoyably with Easy Data Transform.
I was able to immediately write a version of an accounting program in 5 minutes which effectively did the same thing that it took me hours to write in R. Easy Data Transform will save me hours on my accounting and Sales Tax support.
I now use EasyDataTransform practically everyday to analyze the Philippine wholesale electricity spot market. Trading intervals are every 5-minutes so a lot of data is available, about 260k rows and 12 columns for each day, over 90 million rows for a year.
I have been searching for a long time noW for a way to manage all my suppliers price files. I have to everyday update my prices and stock from my suppliers files and comparing them to what I actually have published on my webshop. Easy data tranfer have made my work a lot easier! Thank you!
I'm a founder / executive who works a lot with data. Although my engineers can set up ETLs for any regular process, I often have to explore the data myself to tell them what needs to be done. Also, in the world of startups, there is no hat toO big OR toO small to wear for the work to be done, so executives and PMs at early stage companies often do their own analysis. Easy Data Transform is the perfect fit for managers who need to structure and analyze data, but don't need to get sucked into re-inventing the wheel of writing Python scripts for data clean-up every other day.
I really can’t say enough good things about EDT, I am finding that I’m using it every day to make things easier and essentially, better! Just today I modified the script that I was using for our ASA output, to allow me to work with a 2.9 million line log file. Pull out the important data and provide it back to our networking team so they could correct an issue to clear up intermittent internet access for our company. The coolest thing is, it’s repeatable, in minutes not hours. You are producing an excellent product! It’s going to take me a bit to get all the transform names down and their capabilities, once I’m dialed in there, look out, I fear everything may start with an EDT Transform. LOL. For me it’s all about Data consumption, EDT makes data consumption easier, it allows me to put data into a more consumable presentation.
I consider it easily the most useful new piece of software I’ve come across this year, on any platform. I had to convert a large musical database exported from a music application, and tested Easy Data Transform at full scale: 15000 records, 64 variables, an unholy mess. The XML exported from the music application was so messy it clogged up a double Xeon system for 8 hours before it crashed. Then EDT came into play, and it proved handy beyond expectation. Spreadsheet-like visualization combined with the agility of a Unix tool and the conceptual neatness of iThoughts. Elegant. We love it. We won’t part with it.
Just to say that EDT is terrific! Really well done, I bow, bravo. EDT is my best software purchase since 5 years minimum.
The product provides excellent value and with it I was quickly able to achieve the tasks I initially purchased it for. It's one of a small handful of software purchases I've made where I felt the value was realized by me almost immediately after purchase.
Cannot tell you how much time this product saves me or the number of referrals I’ve made, but it is a lot.
BTW, this is the most brilliant program ever. Well done!!!
I always need to gather data from multiple sources. They could be in txt/csv formats or from multiple worksheets of an Excel or from multiple Excel. EDT is a very handy and useful ELT tool. I could finish my job in the first 15 min trial run and I cannot locate a better and simpler tool to do the same.
I love this software! I do a lot of data conversion from one system into another and this tool has been a life saver!
Your software is fantastic! Made a transform yesterday for finding and inserting correct salutation (gender) for our German customers. Worked perfect, and saved me hours of work!
I use Easy Data Transform to join and manipulate multiple CSV files and I have found it to be very powerful and simple to use. It has saved me a lot of time as I had been using scripts to do the work previously.
I really like your application Easy Data Transform, it helps me soooo much! I really have fun using it, good job!
I do work with data and I abhor having to go through the steps I have to go through using access or any other query language. You just make it so easy.
Just yesterday I had this client with a complex list reorganization: a couple dozen lists with several thousand data sets each, in all forms of CSV - with different delimiters and encodings - and Excel files had to be stacked, deduped, sorted, columns to be merged and removed and new columns to be added in order to create new improved lists. I've done projects like this a hundred times before. I had estimated the whole day for the implementation. Enter Easy Data Transform. I basically just needed to drag and drop the files onto the file area, add the "transformations" and that was it. Done in an hour. As a first time user. Wow!
I am using Easy Data Transform to see if I can compare raw data files from various DNA testing companies and ultimately to merge them together. I had previously done that in Excel, but that was a real PITA using vlookup functions and millions of equations. I was quite impressed that Easy Data Transform could merge 2 files of 700,000 lines together, do some summarization and pivot in about 5 seconds. The pivot table enhancements you made for me were excellent.
EDT makes extracting data for endless CSV files fast and FUN. Its a playful tool that gets that job DONE!! Very Nice.
I’m quite impressed with the capabilities, it has me dreaming a bit. I know there will be some excel geeks saying I can do that but being able to set up multiple filters, multiple branching and save the logic to drop and drag, all I can say is wow! Great job, I will be showcasing your app whenever I have the opportunity. And I appreciate that the price is reasonable and also that it is cross platform, a big plus in my books!
Easy Data Transform allows quick and easy visual shuffling and exploration of biological data without command line tools and sql databases. It turns the handling of large data tables generated in transcriptome and genome analyses into a much easier task. Your app is a joy to use, it allows me to follow ideas at much higher speed than before.
I have done formal tests with another tools and your's is simple to use and also powerful. You also have a super support users !! very reactive and very professional.
Easy Data Transform saved a lot of time doing a client's postal code analysis instead of trying to set it up in Excel.
Easy Data Transform has a generous demo policy to help people get started and then really see the ease and power of the solution. The process for combining continuously updated, large datasets from public and private sources is greatly streamlined with this flexible tool. The visual workflow environment allows me to clearly communicate data processing workflows in our published work that are easily repeatable and adjustable by others: all without writing and textually documenting complicated data manipulation scripts.
Your software is easy to learn and powerful!
I use Easy Data Transform to manage my banking information from three separate accounts to analyze my expenses. Easy Data Transform cleans up the three different data structures into one universal structure, filters out everything that's not an expense and then Aggregates (fantastic) the data into Categories (gas, utilities etc.) and Class (e.i. overhead, normal etc.) and outputs to an Excel file. Excel's only job is to present a nice looking report. Why not let Excel do all the aggregating? Because Excel sheets have a way of getting complex very fast then after months of creating the sheet, when you need to make changes, it becomes unclear where the changes that are needed are located in the sheet and is prone to introduce hard to see errors in the data. In Easy Data Transform it is very easy to locate what you need to change and avoid the ease of introducing errors into the calculations.
I haven’t yet found a situation which I couldn’t manage with your solution. Great work :)
EDT has already enabled me to quickly accomplish at task I would not have bothered to tackle by conventional means (Excel). Briefest description I can manage: Copy/paste multiple HTML results tables for motorcycle races throughout the season so far (9 to date, 33 by end of season). More complicated than it sounds. To properly understand who’s doing best at a given point in the season it’s necessary to apply various rules-based transforms to the data. [allocate non-linear points depending on race position from a lookup table, calculate bonus podium credits for the top 3 in each race, apply a 8 rider top slice based on the aggregate of points to date (excluding podium credits), reset baseline points for the top 8 and add back in the podium credits for just those riders. Then report both position to date based on race results and projected top 8 when the cutoff is applied for the last 3 events of the season]. Making sense so far? No … I don’t think it’s meant to. The serious point is I managed to knock this together in EDT in about 45 mins never having used it before. And I enjoyed doing it. I will be able to easily paste new results tables as the season progresses. Excel could easily do the job but it would have been much more painful and taken ten times as long. The modular approach to processing of EDT is brilliant. It enables parallel approaches to be tried so easily. The block diagram presentation is fantastic. It’s easy to see the data flow and “play with the plumbing”. I love it.
Your app is wonderful, it seems to solve a problem that should be simple for things like excel to do, but I can’t get it to do it so this app makes my life easier. Thanks for making it and also not making it a subscription app that requires an internet connection. That is a huge positive I’m my opinion.
I found you by looking for XLS to XML convert tools to use with HESA return. And it is really useful to use because it Exports data so effortlessly. And I can go back to XLS and amend something and re export without major works. Before I used Excel Developer tools which failed to convert 9 times in 10. This is great!
When it comes to quickly prep and unify data sets, even with millions of rows, nothing beats this tool. I have saved hundreds of hours by quickly be able to merge, analyze and unify data. It has become my go-to tool to prepare both small and massive data sets for both ad-hoc analysis and cleaning data before putting it into a database or BI tool.
I am using Easy Data Transform to manipulate a CSV and I just wanted to say thanks for a brilliant app. I had to split and re-order columns and it was so easy! Your help on the web site is accurate and very easy to follow. The interface, which is very unusual, is extremely effective – the design must have taken you a long time to perfect but is spot on please don’t change it). Great job. I won’t be using Excel for this type of task again anytime soon!
It's just amazingly quick and intuitive to build up some quite complex transforms.
Download a Free Trial Now
No commitments. You don't even have to give us your email address.
Email email@example.com .