Google Answers Logo
View Question
Q: CRC utility ( Answered,   2 Comments )
Subject: CRC utility
Category: Computers > Algorithms
Asked by: ottawaelmer-ga
List Price: $25.00
Posted: 13 May 2006 09:23 PDT
Expires: 12 Jun 2006 09:23 PDT
Question ID: 728425
I need to find a utility that will wrap a file in a CRC algorithm.  I
have an excel spreadsheet with navigation data that I want to send to
another person.  To ensure that the file arrives intact I want to run
it through a CRC hash algorithm.  CRC stands for "cyclical redundancy
checking".  To be complete your answer must direct me to a utility
that will wrap an excel table of data in a CRC.

Request for Question Clarification by leapinglizard-ga on 13 May 2006 09:31 PDT
CRC is not a hash algorithm, but a way to add redundant information to
data so that errors can be automatically corrected to a certain point.
If all you want is a way to ensure that your file has been transmitted
properly, it suffices to get a hash value for the file, which your
correspondent can check at the other end. If I show you how to do this
with a readily available hash utility, will you accept it as an


Request for Question Clarification by leapinglizard-ga on 13 May 2006 09:39 PDT
Actually, CRC does not allow for error correction, but only error
detection. Its mathematical properties make it useful for detecting
errors in a continuous stream of data. To detect errors in a discrete
chunk of data, hashing is the usual approach. In any case, what I can
offer is a standard method for your correspondent to use a hash
utility to verify that the Excel spreadsheet has been transmitted
without any data corruption.

Subject: Re: CRC utility
Answered By: leapinglizard-ga on 13 May 2006 13:47 PDT
Dear ottawaelmer,

The ZIP archive format uses CRC to guard against data corruption.

    One of the most commonly encountered CRC algorithms is known
    as CRC-32, used by (among others) Ethernet, FDDI, ZIP and other
    archive formats, and PNG image format.

Wikipedia: Cyclic redundancy check: Implementation

Therefore, you can employ CRC on your spreadsheet by making a ZIP archive
from the Excel file using a free utility such as ZipCentral.

PC World: Downloads: ZipCentral,fid,6531,00.asp

Once your correspondent has installed ZipCentral, he can open the ZIP
archive and extract the Excel file. ZipCentral will issue a warning
if it detects error corruption based on the CRC-32 algorithm. Your
correspondent can also run CRC-32 manually by using the "Test" button
at the far right of ZipCentral's toolbar.

An alternative is for your correspondent to run a standalone CRC utility,
such as CRCheck32, on the ZIP archive you have made from the spreadsheet

Breezin Software: CRCheck32

Finally, it is possible to calculate the CRC-32 value of a file without
making a ZIP archive from it. The CheckCRC.exe program in the following
package will calculate CRC-32 for the Excel spreadsheet at your end,
which your correspondent can verify by running CheckCRC.exe on his copy
of the file. If you and your correspondent don't get the same result,
the file has been corrupted.

Brinkster: CRC32:

I have enjoyed answering your question. If you have any concerns about
the accuracy or completeness of my research, please advise me through
a Clarification Request and allow me the opportunity to fully meet your
needs before you rate this answer.



Search strategy:

crc error detect

crc32 calculator
Subject: Re: CRC utility
From: kottekoe-ga on 13 May 2006 10:30 PDT
There are many hash algorithms. CRC is one of them. It happens to have
some very nice mathematical properties, is good at detecting common
transmission errors, and is easy to compute.
Subject: Re: CRC utility
From: ottawaelmer-ga on 13 May 2006 16:09 PDT
Your answer looks to be complete.  Thanks for your prompt reply.  I'll
post a rating in a couple of days.  Thanks again.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy