Annotation platforms use Excel. I once received 25 files of separate Excel spreadsheets from a labeling service for 10k texts (short texts about product titles, e.g. "Sauvignon blanc" -> "wine"). Had to merge them, which wasn't as easy as you'd might expect.
Also, I once labeled 5,000 texts during my master's degree via Excel. Was painful as hell.
Thanks for the insight about annotation platforms!
How might Excel have been better for you in these tasks? Or put another way, in the first case of merging 25 files - did you wind up using a different tool to merge and then re-opening them in Excel? Was Excel limiting because you needed to do some kind of fuzzy matching against the labels, e.g., wine, Wine, white wine etc. to do the merge?
On the labeling task that you had - what might have made that easier for you? Some kind of custom scripting that's above and beyond what you can do in VBA?
localhost|3 years ago
How might Excel have been better for you in these tasks? Or put another way, in the first case of merging 25 files - did you wind up using a different tool to merge and then re-opening them in Excel? Was Excel limiting because you needed to do some kind of fuzzy matching against the labels, e.g., wine, Wine, white wine etc. to do the merge?
On the labeling task that you had - what might have made that easier for you? Some kind of custom scripting that's above and beyond what you can do in VBA?