Question: 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. Is there a solution on VeryDOC?
Answer: When you need to convert XLS to CSV, VeryDOC Doc to Any Convert Version 3.5 can help you make it easily. CSV :means C omma S eparated V alues. it is a plain text (ansi) format.
XLS : is the main binary file format for all e X ce L S heets.
CSV files hold plain text as a series of values (cells) separated by commas (,) in a series of lines (rows). You can actually open a CSV file in a text editor and read it yourself. Many applications are capable of reading CSV files, and many languages provide built-in functions that simplify reading/writing CSV format. And CSV files are intentionally designed to be widely supported; any OS or application that imports or exports data usually has CSV support.They do nothing else but hold data - no text formatting for example.Excel files hold the same data, but in binary format. This allows the file to save specific Excel features - charts, formatting, etc. Based on those differences, sometime we need to convert XLS to CSV. In the following part, I will show you how to run the conversion by Doc to Any Convert Version 3.5.
Step 1. Free download Doc to Any Convert Version 3.5.
- Same with before, it is also command line version software. When downloading finishes, please extract it to some folder then you can find the executable file and call it from MS Dos Window.
- Please check usage and parameters in readme.txt file.
Step 2. Convert XLS to CSV by command line.
- Here is the usage for your reference: doc2any [options] <in-file> [<out-file>]
- When converting XLS to CSV, please refer to the following command line templates and parameters:
-useprinter : Convert DOC files to other formats via virtual printer
-useopenoffice : Only use OpenOfice to convert office documents to PDF files
-nooffice : Don't use MS Office and OpenOffice at all, use VeryPDF's Document analysis technologies
Here are command line templates:
doc2any.exe -nooffice "C:\test.xls" "C:\out.csv"
doc2any.exe -nooffice "C:\test.xlsx" "C:\out.csv"
By this software, you can also convert XLS to other file formats:
doc2any.exe -nooffice "C:\test.xls" "C:\out.html"
doc2any.exe -nooffice "C:\test.xlsx" "C:\out.html"
doc2any.exe -nooffice "C:\test.xls" "C:\out.pdf"
doc2any.exe -nooffice "C:\test.xlsx" "C:\out.pdf"
Please note all the conversion could be done under the circumstance that there is no MS Office or OpenOffice installed. During the using, if you have any question, please contact us as soon as possible.