Open your file in your spreadsheet program.

  • Click on File and choose Save As.
  • Under Save as type, choose CSV (Comma delimited). Click Save.
  • You may see a message that your file "may contain features that are not compatible with CSV."

IF a .csv file is opened/created in excel any leading zeros will immediately be lost. 

Never open a .csv in Excel, always open as notepad, especially if amending the file. 

If you open the file in excel and lose the leading zeros you will need to take the following steps to resave with leading zeroes.

  • Right click on .csv file
  • Choose Open With Notepad
  • Once open Edit, Select All, Copy
  • Open Excel
  • Cell A1, Paste, Values
  • Highlight Column A
  • Data Tab, Text To Columns
  • Delimited, Next, Comma, next
  • Highlight Columns with leading zero issues and Select Text as the format
  • Finish
  • Delete all unused tabs
  • Excel, file, Save As, CSV Comma Delimited
  • Warning Box, Yes
  • Close File
  • Don’t Save

Check your csv file with Notepad to ensure leading zeroes are there.