When I request phone numbers on forms, then export to an excel, the result is an unformatted string of numbers in the excel doc. Is there a way to keep the format as such: +1 (###) ###-#### once it lands in the downloaded excel information?
Answered
Phone number formatting from Typeform to Excel
Best answer by john.desborough
as long as we are not using a lifeline to phone a friend - pardon my bad tv show reference
once the data is in Excel, simply create an additional column in the spreadsheet that is formatted in the style you want - you can use, for example, Format-Special-Phone Number or create a custom formatting option. then, to get the string of number from, say, column D formatted in that fashion you would put the “= D2” (for example) in the formatted column - that will convert automatically anything that shows up in D2 to the new formatting
to make sure that each additional row added to the spreadsheet inherits the formula, you would need to use some form of the array function in Excel to ensure that it is spawned down the column.
(i do the vast majority of my stuff in google sheets, and it would be the arrayformula function)
des
+5Hi
Our native integration doesn’t offer specific formatting, so you would need to create a forumla to do this, I believe.
+6- Certified Partner & Champion
- 5274 replies
- Answer
as long as we are not using a lifeline to phone a friend - pardon my bad tv show reference
once the data is in Excel, simply create an additional column in the spreadsheet that is formatted in the style you want - you can use, for example, Format-Special-Phone Number or create a custom formatting option. then, to get the string of number from, say, column D formatted in that fashion you would put the “= D2” (for example) in the formatted column - that will convert automatically anything that shows up in D2 to the new formatting
to make sure that each additional row added to the spreadsheet inherits the formula, you would need to use some form of the array function in Excel to ensure that it is spawned down the column.
(i do the vast majority of my stuff in google sheets, and it would be the arrayformula function)
des
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
1 person likes this
+5Hi
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.