Author Topic: How to read CSV file in Excel all figures are jumbled in one column  (Read 599 times)

Offline johnmartin

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
How to read CSV file in Excel all figures are jumbled in one column. Kindly help me step by step how to do we convert text to column.

please find my attached product file in csv and help me.

Also, send me step by step help how can I do the bulk import on about cart.

Your prompt action will be highly appreciated.

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 3159
  • Karma: +227/-9
    • View Profile
    • Ideal Open Source Ecommerce Solution
We need your help to build better free open source eCommerce platform for everyone.
See how you can help

Offline johnmartin

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: How to read CSV file in Excel all figures are jumbled in one column
« Reply #2 on: August 20, 2017, 11:24:45 AM »
can somebody fix my attached file, i am still can't figure it out how to align correctly in excel

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 3156
  • Karma: +149/-0
    • View Profile
Re: How to read CSV file in Excel all figures are jumbled in one column
« Reply #3 on: August 21, 2017, 01:18:37 AM »
Hi.
When edit csv I personally prefer OpenOffice software. It is much better for csv
“Chuck Norris is so amazing.”
― Mother Teresa

 

Cheap Prom dresses 2018