Importing Currency field from CSV

[stevenjo57]

Hi. Thanks in advance for any help.

I am importing a  CSV file out of another application that exports a field in a currency format. ($X,XXX.XX). I've created a currency field in Airtable to import it into, but AT always ignores it.

So, I ended up exporting to Excel, changing that field to a number without a dollar sign and that allowed me to import it into the AT currency field.  However, I'd like to avoid this step and go directly from the exported CSV into AT without messing with Excel.

I assumed this meant that Airtable wasn't recognizing it as a currency or number and wouldn't move it into the currency field. So, I thought I'd create a text field to import it into, then create a formula field to make it what I need it to be, but it won't import it into a text file either.

Not sure why this is so difficult for me.  Any ideas welcome. Thanks again.

[TheTimeSavingCo]

Any chance you could provide an example CSV file that showcases the error?  How are you doing the import?

As a data point, I was able to import the following CSV sucessfully:

currency
$5,000.11

[Alexey_Gusev · Accepted solution]

Hi,
You can use scripting extension, take spreadsheet importer from Examples

you need to put your table name here.
Ensure your field names match to the data in CSV, case-sensitive
Header line should be like 'Field1,field2,field3', not 'Field1, field2, field3', otherwise it thinks the name ' field2' starts with space char.
currency field type must be currency or any other number type, not a text. 
change row mapping like this (suppose the currency field in CSV named 'amount' ) :

if the field has other name, change all three occurrences.

If you are familiar with scripting, you can also change code to omit second confirmation, maybe even file selection.

[stevenjo57]

I have resolved this. Thanks for all help!