With the functions I'll discuss here, you can make data cleanup much easier in Excel. They allow you to extract, style, split, and join text to get what you need without wasting hours doing it ...

For txt, I let it stay similar format to the msg tool. That means one lang one txt file. For csv, I put all the languages into one file, with the msg entry name, its guid, and attributes. I think this ...

Converts a BMECat XML file into a flat Excel file. Hierarchical groups are represendet as columns. Each feature attribute is an own column. Multiple feature values are comma separated in a cell.

Anthea Levi is a registered dietitian (RD) and reporter with more than 6 years of experience writing for major health outlets including Health magazine, BuzzFeed, Eat This, Not That!, and Livestrong.