All Questions
Tagged with csv microsoft-excel
495
questions
4
votes
4
answers
5k
views
Export to csv options using Numbers
I'm using Numbers on my Mac at the moment and exporting to a CSV file. Is there a way to enclose every value with ""?
For example I'm getting the csv file like this:
1,2,3,4,5,6,7,8,9
When I want ...
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 ...
3
votes
3
answers
29k
views
Automate Excel Text Import Wizard?
I receive files on occasion in a fixed width format. I need to import them into Excel but Excel doesn't perfectly pick up the columns. I can do it manually each time with the Text Import Wizard, but I'...
1
vote
4
answers
828
views
XY Diagram/Data Browser for mid-sized CSV files
I have a set of CSV files with about a 100k records in them. The records need to be visualized in an x-y diagram.
Specifically, I'm looking for:
Seamless zooming in and out of the data
Navigation ...
125
votes
20
answers
555k
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?
2
votes
2
answers
4k
views
Excel to CSV comma delimited
When I try to save a long list in Excel as a CSV comma delimited it works for the first 17 rows and then stops. Why and how I can fix it?
It puts commas after the data in the first 17 rows and then ...
8
votes
1
answer
5k
views
Break up a large CSV file
I have a large CSV file (about 6,000 rows) that I want to break up into smaller CSV files (about 100 rows each). Is there an easy way to do that?
1
vote
4
answers
7k
views
CSV to Excel sheet again
I have a problem.
I know it's possible to make from a excel sheet a csv file delimited by comma's. But is there a way to transfer it back to a normal excel sheet with having back the same table ...
1
vote
1
answer
164
views
What filename extensions open in Excel on Windows?
If I save a text file on Windows as "foo.csv", it shows up with an Excel-style icon (with an "a," on it), and if I double-click it, it opens in Excel. This is really handy!
Unfortunately, it doesn't ...
18
votes
3
answers
6k
views
Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format?
I work with many CSV files, and am constantly annoyed by the Excel dialog that pops up when I try to save a file:
"[your spreadsheet] may contain features that are not compatible with CSV (Comma ...
16
votes
3
answers
32k
views
Saving filtered results from an Excel workbook to a CSV file
I have an Excel workbook with a lot of rows in it. I filter it using the values of one column and then I want to save the filtered results to a CSV file. When I do "Save as..." I get all the rows. I ...
2
votes
2
answers
2k
views
Program to display CSV nicely from clipboard
I'm occationaly dealing with CSV files. I was wondering if there's a program that displays the CSV nicely in an Excel-like format (bonus for enabling sorting and searching) on the fly without saving ...
17
votes
9
answers
104k
views
How do I get Excel to import a CSV file with commas in some of the content fields?
How do I get Excel to import my CSV file?
File
I have a file claiming to be CSV. It contains 10 fields, all of which are surrounded by double quotes (yes, even the dates and numbers.) 2 or 3 of these ...
22
votes
5
answers
32k
views
How can you make Excel 2007 stop formatting large numbers as scientific notation?
Kind of the inverse of this question.
I frequently download CSVs from outside sources as part of my programming work. I like to examine their data in Excel because, let's face it, Excel is an ideal ...
7
votes
5
answers
7k
views
Excel 2007 is converting CSV fields into formulas
I have a problem with a CSV file which has telephone numbers stored in their internationalized format (+1-800-555-1234). When opening this CSV in Excel 2007, it converts that data to a formula and ...