I'm preparing a sheet that contains 100 entries in 100 cells. what i want to do is that I want this excel file to be converted into csv format, so that these 100 entries will be on one cell only, with a delimiter as in a regular csv.
Six answers:
2008-01-21 21:32:12 UTC
Bring up the 'Save As' dialog in Excel (File menu->Save As)
In the file type, select CSV, and save it!
pangster612
2008-01-21 21:31:35 UTC
xls extension of excel file. to convert excel file to csv, save it as text.
2008-01-22 00:23:47 UTC
Maybe you can try XLS Converter. It can easily convert the excel file to CSV, txt, html, mdb, dbf, etc.
2016-04-07 01:56:49 UTC
Yes, Open Excel got to Menu Data -> Imoprt External Data -> Import Data and select teh .csv file.
?
2013-12-02 09:30:30 UTC
IMO the easiest way is to use an online tool such as http://csv-to-excel.com/ExcelToCsv
Dan
2008-01-21 21:37:36 UTC
->File ->Save As... ->CSV
ⓘ
This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.