Knowledge Base

Why do my imported currency values appear as "0"?

JT
Jenny Takahara, November 2, 2023

When importing from spreadsheets, make sure all monetary values (for default fields such as deal value, and for any custom fields where you have currencies) are formatted as numbers without currency symbols (so as 1000000000 as opposed to $1000000000).

If numbers include currency symbols, the Pipedrive import system won’t detect them properly and thus all values will be formatted as ”0”.

If you’ve already imported and are facing this issue, the best course of action is to revert your import, remove the currency symbols from the spreadsheet you’re importing and import again.

Was this article helpful?

Yes

No

Related articles

Got any questions?

Contact us