When I extract records via csv and my records have picklist values, it gives me the code of the picklist value selected and not the picklist value. May I ask what was the reason why it was designed like that?
Spreadsheet import expects integration codes for picklists, that is by design. If picklists do not have codes, values will be used instead.