Customise Excel to Leave Data Unchanged
This guide is for people that are having to open their CSV file to edit something and they are finding that Excel is changing their data.
For example, the leading zero's are disappearing on an invoice number - 001257 is displayed as 1257 or on bank details.
Using Microsoft Excel
The first step is to not open your CSV file when it downloads to your computer. Just leave it where it is for the moment.
Next you need to open a blank Excel file.
Click on Data> select 'From Text/CSV' > find your CSV file on your computer > Import. This will open a new pop up window.
Under Delimiter section> Select Comma > Load.
To save it click on File> Save As> Select where you want to save it> name the file and change the 'Save As Type' to be 'CSV (Comma delimited) (*.csv)'
You can now upload the CSV into your software
Please note, if you have opened a csv before this is set, it is more than likely that Excel will have changed the data in some way which will later affect the export.
If the data is still being changed, try setting Data Type Detection to 'Do not detect data types".
Using Google Sheets
For those who don't have Microsoft Excel, you can try to do so similarly using Google Sheets
File > Import > Upload your selected file.
Upon import, uncheck the "convert text to numbers, dates, formulas" > Import Data and you can review the data from Sheets.
This will now hold your leading 0's. Once you're happy with your list, File > Download > csv.
Use that file to upload direct into Lightyear.