Skip to main content
kavyashren650312
Participating Frequently
Feb 26, 2026 2:20 PM UTC
Solved

Text value is converted to numeric form while generating excel

Hi Below is the data input to JSON to Excel smart service.

{testtName=314120-26000-008 Test Data, testPriority=A, id=17315}

When excel is generated the testName is converted to numeric value.

testName is of type text. but the smart service has converted it to numeric form.

How to avoid the default type conversion while generating excel.

shubhama926776
Brainy
Feb 27, 2026 11:11 AM UTC

Prefix testtName with single quote '.
Excel treats it as text, hiding the apostrophe.

शुभम्

2 replies

stefanhelzle0001
Brainy
Feb 26, 2026 6:22 PM UTC

Are you sure the value converted? I mean, Excel is notoriously known for trying to be clever about how to display values.

shubhama926776
Brainy
Feb 27, 2026 11:11 AM UTC

Prefix testtName with single quote '.
Excel treats it as text, hiding the apostrophe.

शुभम्