How do I save an excel file as a CSV file?
NOTE: Always create a copy of a .csv file before opening to avoid loss of data
If you are importing data from excel into Stockbook the file must be in a Comma Delimited file otherwise known as a .csv file.
NOTE: If you have long numbers in your file (e.g. Sheep Genetics ID or EID’s) it is important not to reopen the file after it has been saved as a CSV.
Open up the excel file. Make any necessary changes that need to be made to the data before you save it as an CSV file (e.g. adding leading zeros to a number, changing the format of a number or altering the headings.)