I am trying to write a table to a csv file, but the contents of each row are being stored in a single cell. I’m using “Data Table action: Write to file”. Does anyone know how to fix this?
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/61e0ac20-d56f-4827-b46b-c6b5b384dfb5.png)
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/49dbcea6-906d-462a-98cc-d705383768b0.png)
I have a couple of suggestions:
The simplest solution is to save the destination file with “.csv” extension, if you’re not already.
If you must save the destination file with “.txt” and use Excel, you can use the Text Import Wizard in Excel. Otherwise, it doesn’t appear there is another way to do this in Automation Anywhere except for the Excel “Save As” action, but once again it would need a “.csv” extension.
To open the Text Import Wizard in Excel, select the entire column and then go to Data > Text to Columns.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.