All Questions
Tagged with microsoft-excel csv
495
questions
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 ...
7
votes
1
answer
15k
views
Space or tabs as separator in CSV
I usually put "sep=," or "sep=;" as first line on my csv files so i can easily open them with excel. But is there a way to use this with space and tab separated files?
6
votes
3
answers
94k
views
Excel adds double quotes on csv export [duplicate]
I am experiencing a weird unknown behavior in excel. The sheet I want to export to a csv file consists of 4 columns with data like this:
site.aspx|de|lblChanges.Text|some text that will be used ...
6
votes
3
answers
69k
views
How to make excel open CSV files and automatically split the comma delimited column?
I get these reports everyday in CSV format. In the previous version of excel (2007) when I opened these files they were already split into columns. Now with the latest version it isn't. Where is this ...
6
votes
3
answers
9k
views
How to split a CSV file into multiple files based on a text string?
I have multiple text files (CSV) with a structure similar to this:
funkiana,23.55,-99.866
funkiana,24.634,-98.701
funkiana,24.717,-98.901
geminiflora,22.25,-104.6166667
geminiflora,21.21666667,-104....
6
votes
4
answers
33k
views
excel: export csv file with japanese character
In my excel file, the Japanese character is shown correctly,
while when I export it as csv,
the character become question marks
How should I output so that the character can be shown correctly?
6
votes
5
answers
55k
views
Edit csv file with Excel without reformatting
I have some csv data file that looks like this
1,2,3
5,6,7
I open it with Excel 2010, do some change (change some value, delete a column, or anything), and then re-save the file still as csv. But ...
5
votes
5
answers
168k
views
How to set a character limit and remove characters over that limit excel 2007
I have to provide a CSV file for a telephone system with names and numbers on for a directory. The numbers cannot contain any spaces, and the names must be 20 characters max.
I have a list of names/...
5
votes
2
answers
30k
views
Export to CSV From Excel
I frequently use Excel to prepare data to load into a table. I create a CSV file from it and use that file for data loading. I generally find myself creating the CSV file multiple times.
My current ...
5
votes
5
answers
94k
views
How to write "NULL" into CSV from Excel for blank fields
How do I write "NULL" for blank fields when I export a CSV file from Excel 2007? Is there a feature to do that?
5
votes
1
answer
21k
views
Semicolons when creating a CSV file instead of colons
When creating a CSV file from an XLSX workbook with the new Excel for Windows 8, I get a file filled with semicolons instead of colons.
How can I change that? I even had to reopen the file with ...
5
votes
1
answer
29k
views
Force Excel to save files with .TSV file extension
I am using Microsoft Excel to work with tab delimited files. Although I can import tsv files without an issue, I can't save them with the TSV extension. Instead, I have to
1. Import the TSV file ...
5
votes
4
answers
14k
views
Mass Convert .xls and .xlsx to .txt (Tab Delimited) on a Mac
I have about 150 .xls and .xlsx files that I need converting into tab-delimited. I tried using automator, but I was only able to do it one-by-one. It's definitely faster than opening up each one ...
5
votes
1
answer
3k
views
Excel 2010 - Get CSV wizard to open by default
I'd like to set Excel 2010 to open the import wizard each time I double click on a CSV file rather than have Excel open the file without the wizard. Previous versions of Excel did this but 2010 ...
5
votes
2
answers
19k
views
How to prevent Excel to round a number at opening? [duplicate]
I have a question regarding Excel.
We generate automatically a CSV file everyday, containing stuff looking like :
column1;column2;...;columnx
text;date;text;249316479917397279
The issue is that the ...