AbanteCart Community

Shopping Cart Operations => Documentations & Manuals => Topic started by: johnmartin on August 19, 2017, 07:25:42 PM

Title: How to read CSV file in Excel all figures are jumbled in one column
Post by: johnmartin on August 19, 2017, 07:25:42 PM

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.

Title: Re: How to read CSV file in Excel all figures are jumbled in one column
Post by: abantecart on August 20, 2017, 04:08:27 AM

Here is the an article that might help you:
https://www.ablebits.com/office-addins-blog/2014/05/01/convert-csv-excel/

Title: Re: How to read CSV file in Excel all figures are jumbled in one column
Post by: johnmartin 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

Title: Re: How to read CSV file in Excel all figures are jumbled in one column
Post by: Basara on August 21, 2017, 01:18:37 AM

Hi.
When edit csv I personally prefer OpenOffice software. It is much better for csv

Title: Re: How to read CSV file in Excel all figures are jumbled in one column
Post by: Aaradhana Aksha on February 13, 2019, 11:40:34 PM

Awesome information, really helpful.

Title: Re: How to read CSV file in Excel all figures are jumbled in one column
Post by: chona 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.

Title: Re: How to read CSV file in Excel all figures are jumbled in one column
Post by: iroman on August 11, 2019, 01:10:46 AM

thank you for topic merci