Help

Importing Currency field from CSV

Topic Labels: Importing-Exporting
Solved
Jump to Solution
311 3
cancel
Showing results for 
Search instead for 
Did you mean: 
stevenjo57
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
Alexey_Gusev
13 - Mars
13 - Mars

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

Alexey_Gusev_1-1730580242465.png

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' ) :

Alexey_Gusev_2-1730580699940.png

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.

See Solution in Thread

3 Replies 3

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:

Screenshot 2024-11-02 at 4.29.26 PM.png

currency
$5,000.11

Screenshot 2024-11-02 at 4.30.30 PM.png

 

Alexey_Gusev
13 - Mars
13 - Mars

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

Alexey_Gusev_1-1730580242465.png

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' ) :

Alexey_Gusev_2-1730580699940.png

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
5 - Automation Enthusiast
5 - Automation Enthusiast

I have resolved this. Thanks for all help!