Author Topic: How to read CSV file in Excel all figures are jumbled in one column  (Read 10009 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: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Please  rate your experience or leave your review
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: 5772
  • Karma: +274/-2
    • 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

Offline Aaradhana Aksha

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
    • Data Science course in Chennai
Re: How to read CSV file in Excel all figures are jumbled in one column
« Reply #4 on: February 13, 2019, 11:40:34 PM »
Awesome information, really helpful.

Offline chona

  • Newbie
  • *
  • Posts: 2
  • Karma: +1/-0
    • View Profile
Re: How to read CSV file in Excel all figures are jumbled in one column
« Reply #5 on: June 25, 2019, 08:46:48 AM »
Upload you CSV file in Google drive and open it in Google Sheets. The use that Google sheet as a Excel Sheet.

Cheers.
Currently working in Dow Group a leading Web design company in Dubai providing exceptional Digital Marketing and Web Design services in all over the UAE.

Offline iroman

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
    • فولاد SPK
Re: How to read CSV file in Excel all figures are jumbled in one column
« Reply #6 on: August 11, 2019, 01:10:46 AM »
thank you for topic merci

 

Powered by SMFPacks Social Login Mod