Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Problems Importing Numbers

603 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I am having trouble with numbers coming from a .CSV.

Currently I have the field set as a Decimal (1.0).

The data in the CSV looks like:

The data when uploaded looks like:

I’ve tried changing formats, but I need it to remain a number format so that I can pull averages.

Thank you,

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

I hope you have solved it in the meantime!

I have problems with importing numbers because the data I have in csv, extracted from the bank site and from paypal, consider the dot as a decimal separator and the comma as a separator for thousands, while airtable reasons the other way around.

The solution I found is to convert the numbers to text format in excel, replace commas with nothing and replace periods with commas and then use the copy/paste function directly on the table.

I hope this solution will be useful to you.