Most of us know that Excell will corrupt the CRC field in some CSV records.





Here is how to safely use Excell on your csvs.





1. Open Excell with a blank workbook.


2. Select "Data" from the top menu.


3. Select "Get External Data".


4. Select "Import Text File".


5. Browse to the file you want to import, select it, and click on the "Import" button.


6. At the next window make sure that the "Delimited" radio button is selected and click on "Next".


7. Check the "Comma" option box and click"Next".


8. Select the "Text" radio button for each column's format by selecting the column and then selecting the "Text" radio button.


9. Click on"Finish" when ALL columns have been set to text (step 8).


10. Depending on the version of Excell, you may get another pop-up window.





If so click on "OK".





You can now safely edit your CSVs.





When you are ready to save the CSV be sure to select "Save As" and select CSV from the Type options.





When prompted by warning windows about the format select "Yes" and your done!





I know this sounds like a lot of work, but after a few times you won't think anything of it.





As always, practice first on a file (or copy of a file) that you can afford to loose!





Hope this helps some of you.





Dave