Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Problems Importing Numbers

Topic Labels: ImportingExporting
836 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lindsay_Kirsch
4 - Data Explorer
4 - Data Explorer

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
Alessandra_Carl
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.