All Questions
7
questions
0
votes
1
answer
831
views
Convert csv-like file (with custom separators) to ods, odf, xls, or xlsx
I have a csv-like file with complicated data and would like to open it in LibreOffice Calc, Microsoft Excel, or another spreadsheet program.
What I mean by csv-like:
Fields are separated by the ...
- 659
0
votes
1
answer
3k
views
Batch converting csv files to xls on a Mac
I would like to convert all the csv files in a directory to xls files. Nick T posted this code here How to batch convert .csv to .xls/xlsx
import os
import glob
import csv
import xlwt # from http://...
5
votes
0
answers
255
views
Excel 2007 doesn't preserve asian characters when converting to csv [duplicate]
I am trying to save a spreadsheet as a CSV file. The file consists of korean characters, and the resulting csv has those characters literally converted to question marks (0x3F).
I am running on an ...
- 1,199
4
votes
1
answer
544
views
CLI program for xlxs -> csv conversion? [closed]
Is there an foss command line program that can convert between Excel (.XLXS) and Comma Separated Value (.CSV) files?
- 3,058
0
votes
1
answer
8k
views
Set row delimiter in Excel
How can I use row delimiter other than \n?
CSV fields contain \n and the row delimiter is \n\n\n\n, to separate line breaks in fields from the row delimiter.
I'm using Excel 2010, and in need to ...
- 313
0
votes
1
answer
2k
views
How to automatically convert CSV file to XLS file with filters and formatting of the top row?
I have a big CSV file (10,000s of rows).
How can I automatically convert it to an XLS file which will have Filters and some formatting (color, font) on the top row?
- 223
0
votes
5
answers
14k
views
How can I convert an ordinary text file to a .csv file, and import it to Excel?
I have a group of names and addresses that I would like to import into Outlook.
At the moment I have imported them into Excel, but all names and addresses are in one long entry.
All are already ...
- 8,198