Jotform to Google sheet mobile numbers are missing a 0 infront

When importing to google sheet, the data for mobile numbers is missing the 0 infront
how can we fix this?

Hi Annys,

I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

When mobile numbers are imported to Google Sheets and the leading zero is missing, it is usually due to the way Google Sheets interprets the numbers as numeric values, which removes leading zeros.

One common way to fix this is to format the mobile number column in Google Sheets as text before importing the data. This preserves the leading zeros.

Alternatively, you can add a custom formula in Google Sheets to add the leading zero back to the numbers if they are missing it.

If the issue persists, disconnecting and reconnecting the Google Sheets integration in Jotform might help. Here’s how to do it:

1. Go to Settings in your Jotform Form Builder.
2. Select Integrations from the menu on the left.
3. Find and Remove the Google Sheets integration by clicking Remove Integration and confirming.
4. Reconnect the integration by following the guide on integrating forms with Google Sheets.

After reconnecting, try submitting a test entry to see if the mobile numbers retain their leading zeros.

Give it a try and let us know how it goes.

Still would like a proper answer

Hi Annys,

The issue with missing leading zeros in mobile numbers when importing to Google Sheets happens because Google Sheets treats the numbers as numeric values and automatically removes any leading zeros.

To fix this, you can try the following steps:

1. Format the column as text in Google Sheets before importing the data. This will preserve the leading zeros.
2. If the data is already imported, use a formula to add the leading zero back. For example, if your numbers are in column A, you can use the formula =TEXT(A1,"0000000000") in another column to format numbers with leading zeros.
3. Ensure that in your Jotform, the mobile number field is set to collect the number as text or string rather than numeric. This helps preserve formatting during integration.

These steps should help maintain the leading zero in your mobile numbers when syncing with Google Sheets.