With "Append Line" to the CSV file, how do you append the string value to the CSV as is with original text

Help Studio
,
1

Good morning to all.

Here is an example of what I am trying to write into a csv file using the Append Line activity text value: (This is not the whole string)

“2026108546713”.ToString+“,”+
“Company Name”+“,”+
“WI4”+“,”+
“Open - Status”+“,”+
datetime.Now.ToString

and the real problem is when i open the csv file, the value “2026108546713” converted to scientific value rather than keeping the original value.
and what I end up with text in the csv file as below.

2.03E+12 Company Name WI4 Open - Status 7/8/2026 16:26

Is anyone have similar issue and how do I achieve this.

2

Hi,

How do you check the value? If in excel, it seems display matter and data is correctly stored. For now, can you change the cell’s format General to Number?

image
image474×334 10.2 KB

Regards,

3

While we can find the value you showed us, the problem is that the bot creates multiple CSV files each day. These files have many columns with similar number values and thousands of records. Converting each file to Excel every day is a tedious task for the team.

4

@shyammaddi

A small work around would be to include a small space or a single quote at the start so that the number is treated and stored as text

Also typically are you opening the csv as text file is that when you see the scientific value?

Cheers

5

There is no luck with including small space at start of the number. I am storing the file as a Microsoft excel comma separated file and opening the file same format, not in the text file. Even if you open the same file in notepad the number will show as scientific number.

6

@shyammaddi

If you open in excel by default with the formatting of number it would display in scientific format.

Can you try with a ' before number

Cheers

7

Hi @shyammaddi

Could you pls try -
write the value as text by prefixing it with ="...":

“=”“” + “2026108546713” + “”“” + “,” +

“Company Name” + “,” +

“WI4” + “,” +

“Open - Status” + “,” +

Now.ToString()

Or:

String.Format(“”“=”“{0}”“”", “2026108546713”)

8

@prashant1603765 you mean appending the “=” prefix the number, so that the number will be displayed as =2026108546713 in the sheet like this? i am getting syntax errors while using your whole syntax. if possible, can you try to explain what was mentioned in the syntax.

9

@Anil_G Thank you.
I am getting the value as '2026108143713 in the sheet, this is what you are expecting? the number with single quite prefix the number.

10

@shyammaddi

Yes in excel to make number convert to string we have to add this

Hope this solved the issue

cheers

11

Yes, exactly. The = is prefixed to the value so Excel interprets it as a text formula (="2026108546713"), which helps preserve the full number. The expression I shared was intended to generate:

=“2026108546713”,Company Name,WI4,Open - Status,

The doubled quotes ("") are just VB . NET’s way of escaping quotation marks inside a string. If you’re seeing syntax errors, it’s likely due to the quote formatting when copying into UiPath rather than the = prefix itself.