Skip to Content
Author's profile photo Deepak Palsaniya

Creating a csv file in other format than comma for master or transaction data Import

Hi,

Sometime we encounter a situation when description or other properties of master or transaction data have comma. In this case while saving data file as csv then that field will split into two different columns of csv file. So this document will help you  to “Creating a csv file in other format than comma for master or transaction data Import”.

Steps for the same are as below:

  1. Open downloaded file in excel. Select column A and Click on “Text To Column” from Data -> Text to Column then check Delimated radiobutton.After this click on next as shown in below screenshot.

/wp-content/uploads/2015/10/1_802035.png

   2.       Select “Others” check box and specify pipe “|” sign.

/wp-content/uploads/2015/10/2_802036.png

   3.   Select “Text” in “Column data format”.

/wp-content/uploads/2015/10/3_802070.png

     4.       Go to “Control Panel -> Region and Language->”

/wp-content/uploads/2015/10/4_802071.png

     5. Click on “Additional Settings”.

/wp-content/uploads/2015/10/5_802072.png


     6. Specify “|” symbol  in “List separator”

/wp-content/uploads/2015/10/6_802073.png

     7. After apply above setting  Save excel data file as .CSV format.

     8. After saving file make List separator back to  “,” (comma) from Control Panel -> Region and Language.

Best Regards,

Deepak

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Deepak,

      Thank you for sharing this documentation.

      Cheers!