Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Problems Importing Numbers

Topic Labels: ImportingExporting
140 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

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:
image

The data when uploaded looks like:
image

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

Thank you,
Lindsay

1 Reply 1

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.