All Questions
Tagged with microsoft-excel csv
495
questions
246
votes
13
answers
684k
views
Easiest way to open CSV with commas in Excel
CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this:
It's probably because when Excel thinks "comma-separated values", it ...
- 14.5k
158
votes
5
answers
117k
views
Is it possible to paste CSV formatted data into Excel 2007?
I want to copy and paste CSV formatted text into Excel 2007.
Is there a way of doing this without saving it to a temporary file first?
I'm sure in previous versions of Excel there was a way to ...
- 8,522
135
votes
6
answers
326k
views
Formatting a comma-delimited CSV to force Excel to interpret value as a string
I've been searching around for a while trying to figure out how to output a CSV file in such a way to force Excel to interpret the values as a string and not try to convert them to numbers or dates.
...
- 4,174
135
votes
7
answers
119k
views
How can I stop Excel from eating my delicious CSV files and excreting useless data?
I have a database which tracks sales of widgets by serial number. Users enter purchaser data and quantity, and scan each widget into a custom client program. They then finalize the order. This all ...
- 2,616
131
votes
9
answers
489k
views
How to get Excel to interpret the comma as a default delimiter in CSV files?
I have a number of .csv files. Some of them are comma delimited, some are tab delimited (maybe they should be called .tsv ...)
The csv extension gets associated with Excel when Excel is installed. ...
- 2,967
125
votes
20
answers
554k
views
How do you force excel to quote all columns of a CSV file?
Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?
- 1,527
125
votes
5
answers
567k
views
How to set character encoding when opening a CSV file in Excel?
Is it possible to set the default encoding for Excel (any version, e.g. 2010) when opening files like csv files (like you can in Open Office Calc)?
I When I try to open a csv file encoded in Japanese ...
- 1,383
120
votes
7
answers
216k
views
How to open semicolon delimited CSV-files in US-version of Excel
When I double-click on a .csv file, it is opened in Excel. The csv-files have columns delimited with semicolons (not commas, but also a valid format).
Using a German Windows/Excel setup, the opened ...
- 1,494
67
votes
9
answers
390k
views
How to force Excel to open CSV files with data arranged in columns
I generate a CSV file with an extension .csv in which every piece of data in one line is separated with a comma:
1,2,3,4
1,2,3,4
The file is sent via email and I want that when a customer opens it ...
- 1,341
47
votes
5
answers
53k
views
What is the "sep=" metadata you can add to CSVs?
While trying to find out how to get CSVs to open correctly in Excel on a Spanish PC (belonging to a customer) I found many answers recommending using sep=, at the top of the file:
Easiest way to open ...
- 755
44
votes
3
answers
262k
views
How do you change default delimiter in the Text Import in Excel?
I want to import a CSV file to Excel. The CSV file has comma separated data (go figure), but the delimiter in the Text Import Wizard is set to "Tab" by default. How can I change the default to "Comma" ...
- 825
38
votes
9
answers
206k
views
How to export selected columns into csv file
I want to export specific number of columns from excel into .csv file. I have around 10 columns like lname, fname, phone, address, email and so on. What should I do to export only certain columns like ...
- 381
31
votes
6
answers
112k
views
How to convert Excel file with multiple sheets to a set of CSV files?
I have an Excel file with 20 sheets on it. Is there a way to quickly convert the file into 20 CSV files - one for each sheet?
I can do it manually of course, but I'll have to be processing these ...
- 18.8k
29
votes
8
answers
181k
views
How do I stop Excel from converting value 0503E000 to 5.03E+02 automatically?
Excel converting value 0503E000 to 5.03E+02 in any cell automatically in CSV
I tried to convert it to text number and general but after i save it and reopen it again
it goes back to 5.03E+02
How do I ...
- 411
28
votes
3
answers
87k
views
How can you change Mac excel 2011 to separate using commas, not semicolons?
I have Excel 2011 on my Mac, and when I try to export a .xls file into .csv I end up having a semicolon separated file instead of .csv.
p.s. The System preferences for my keyboard input is Italian
...
- 397