The world's leading automated proofreading software

October 8, 2020

The Schlafender Hase Team

How to Compare Excel Files: To Improve your Proofreading Workflow

By: The Schlafender Hase Team

Yes, this can be a common situation: a Brand Owner submits the packaging or labeling brief in multiple file formats using an Excel spreadsheet combined with a Word document. Critical, legally required table information such as nutrition facts and allergens arrive in Excel templates. These Excel files are used to generate label revisions which comply with FDA regulations.

FMCG, CPG, Cosmetic & Food industries are experiencing ever-increasing regulations and growing pressure to get products on the shelf quicker. This means the necessity to get things right the first time and avoid time and money consuming additional correction cycles has never been more important. Efficient, error-free processes for labeling and packaging make the painstaking proofreading workflow a place where value can be added – or lost. This is where the right proofreading software can be invaluable: it reduces time-to-market and at the same time improves document/artwork quality.

At EU level, the first labeling directives appeared in the late ’70s. At first the primary aim of such legislation was to guarantee the safety of products in the context of free movement of goods and to provide basic information such as price, origin, ingredients/materials, weight and measurements. Over the years mandatory labeling has come to address additional aspects, in particular environmental aspects. This mandatory labeling information is usually delivered to the DTP (Desktop Publishing) in Excel. Excel is great for systematically gathering and ordering large amounts of information. But translating Excel information into a finished package that meets all legal requirements and beats the competition to the shelf is another matter. This is where proofreading software matters and companies with the right proofreading software will be the companies that “excel”.

Compulsory labeling is increasingly used to communicate on nutritional matters, health and safety, country of origin, environment, energy, ingredients list – depending on country and context the list grows longer. Consumers now expect detailed product information and may select products with more information on the package over other goods that do not provide the information the consumer is looking for. Nowadays Excel (and Word) files are still commonly used, even for big companies (such as multinational food-products corporations) to record, track and print information about goods. When you use a proofreading software to verify your Excel files, you and your team:

  • Better protect your artwork from recalls and reprints
  • Improve and simplify your artwork and label review processes
  • Easily manage reviewing large volumes of goods
  • Ensure accuracy, regardless of language on packaging
  • Maximize the value of the packaging supply chain

To proofread material manually can take days and is error prone; using proofreading software is indispensable. However, not many are able to correctly read tables or Excel files. And not many can accurately compare table and Excel files to a Word or a PDF file. This is where TVT, the unique Text Verification Tool, developed by Schlafender Hase, can spell the difference. As an example, some documents containing complex Excel tables may require the use of TVT’s “Table Area Mode” to enable the mapping of text within tables. This also enables the detection of moved cells, called Table Breaks.

TVT takes a different approach to text comparison. It does not work on the basis of language at all, but rather compares the underlying universal code (‘Unicode’) – i.e. the international standard agreed across the software industry. TVT can read all documents in the following file formats: DOC, DOCX, DOCM, RTF, TXT, PPT, PPTX, PDF, AI, XML (QRD – EMA, SPL – FDA), XLS and XLSX in any language written from left to right and right to left, as well as in the main Asian languages (Chinese, Japanese and Korean) that use Unicode standard fonts.

At some point most big companies will switch to .xml or a comparable file format for their legal texts. That is some point in the future. At the moment the best way to the future is TVT.

If you would like to find out more about TVT® and best practices for table comparison, register for the free webinar:

Do you want to find out more about how your proofreading life can be easier? Get in touch and we’ll tell you all about it.

Related Blogs

April 8, 2024

Schlafender Hase Team

Sustainable Solutions: Enhancing Workflows through Paperless Document Reviews

Earth Day is a commitment to safeguarding and enhancing our natural environment, with an anticipated mobilization of over 1 billion people in 2024. At Schlafender Hase, when we thought about how Earth Day affected us as individuals and a company, we unanimously agreed: it's especially about trees and minimizing use of paper.

March 22, 2024

Schlafender Hase Team

Best Practices for your Promotional Review Process

The aim of a pharmaceutical promotional review process is to ensure the accuracy and compliance of promotional material with the relevant medical, legal, and regulatory aspects of a specific market.

March 18, 2024

Schlafender Hase Team

Ensuring Patient Safety: Medical Device Recall Process and Prevention Strategies

The costs of medical device recalls can run well into the millions of dollars. In terms of numbers of devices recalled, heading the unfortunate list of medical device recalls in recent times is a Class I recall of 38 million Vial2Bag fluid transfer systems by West Pharmaceuticals in 2019.