Skip to Main Content
Ideas Portal
Status Future consideration
Categories Other
Created by Guest
Created on Sep 2, 2021

Exporting Numeric Fields

When exporting numeric fields which have a meaningful leading zero, such as a bank account number or sort code, it would be useful if these could be exported as strings, i.e. by enclosing the field in the csv row within quotation marks.This would overcome the problem where if the csv file is opened directly in Excel the bank account field is treated as numeric and Excel removes the leading zero and thus makes the value of the bank account number field incorrect. We realise that it is possible to use Excel's import function to do a more controlled transformation of the data and ensure that the field is treated as string, but users tend to open the csv file directly into Excel which causes leading zeroes to be removed.

  • ADMIN RESPONSE
    Sep 13, 2021

    Hi Hayley. Thanks for the suggestion. It sounds like we should perhaps give any user the option to choose whether to export using quotation marks - that way those that want to can etc. I'll raise this up for review.
    Cheers
    Dylan

  • Attach files