When working with Excel, there is an addon (paid) called KUTOOLS that saved me a lot of time. It has a bunch of preset operations like removing duplicates, merging multiple sheets, bulking changing rows etc.
Another text editor worth mentioning is EMEDITOR that has tons of macros and handles larger files much better than Sublime
Another text editor worth mentioning is EMEDITOR that has tons of macros and handles larger files much better than Sublime