Magic/Replace is a free web-based tool for making changes to all of the rows of a data table at once. You can paste in a spreadsheet, CSV or TSV file, make your changes in a single row and it intelligently applies the same changes to all rows. So for example, you can make all email addresses lowercase, or combine forename and surname into a single column, or change middle names to initials, or reformat dates....
There's a good video demo on the site.
This has already been added to my 'Resources' bookmarks folder.
No comments:
Post a Comment