How to update records via csv

Hi all,

I wonder if it is possible to update some records via csv?
I exported the records and the id field looks like this (in excel)

so when I made my changes and imported them, it would create the records not update them!

any ideas why!!

Does changing the column type to a string/text fix the generated CSV?
We’ve had quite a few issues with excel (and alike) and changing column types usually fixed the issue.

@tjerman the id field is the recordID, I think. because I don’t have a column called id in my module also some of the numbers in the middle are similar to the recordID.

I’m not sure how to change the column’s type in Excel !

will try opening the CSV file in a text editor instead … and see how it goes

Yes, id would be recordID; unsure why I decided to name it as such, apologies for confusion.

Haven’t used Excel in ages but I think it is the same as with Google Sheets – there should be something in the ones of formats/data formatting.

I usually edit all CSV files in VSCode (or similar editors) so I don’t have to deal with this.

1 Like