All Questions
17
questions
18
votes
1
answer
42k
views
Excel save behaviour of CSV file with UTF8 encoding vs UTF8-Bom encoding
My original csv files are encoded with UTF8-BOM, this is so Excel can recognise the Unicode charcters (If its just encoded with UTF8 then Excel does not recognise the unicode characters).
My issue ...
- 283
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 ...
- 191
3
votes
0
answers
117
views
Excel csv-import into table referenced by name
I have a worksheet called raw_data where I import some data via the Data-Import Wizard. This created a new name-referenced range called abc.csv.
However if I try to create a table on another ...
2
votes
1
answer
17k
views
Excel How to make Text Qualifier editable or add a new entry in the existing list?
I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote.
Example:
"col1","col2","col3"
"...
- 753
2
votes
3
answers
6k
views
Fast way to export data out into different excel files based on Column
There's some data like this (with over 500,000 entries)
Name | State
---- -----
Billy Utah
Sue California
Joe Utah
Sally California
John Michigan
...
- 95
2
votes
0
answers
2k
views
Is it possible to make Excel auto-filter case sensitive?
I have a CSV file I opened with Excel 2013 because I wanted to find errors in a specific column.
Here is an extract of data:
"ID";"LANGUAGE";"TYPE";"NAME";"ACTIVE";"CITY";"POSTAL_CODE";"...
- 753
1
vote
3
answers
20k
views
How to convert a Excel row to a single csv text cell (inverse of "Text to Columns)
I have a POS program that allows me to import stock items from a csv file. The problem is that it only accepts a certain csv format.
I have a Excel spreadsheet that saves my stock in different ...
- 129
1
vote
1
answer
27
views
Excel Unable to Display or Distinguish Text Strings
I created a simple CSV file with only this exact text (quotes included):
"-2**31-1","-2**31"
How can I open this CSV file in Excel and get it to display exactly:
A B
1 -2**...
- 13
1
vote
1
answer
797
views
Why does Excel only invoke the Text Import Wizard for .txt files?
Excel ignores comma delimiters in .csv files, but invokes the Text Import Wizard for .txt files that "appear delimited". Surely it should behave the same way for .csv files?
- 2,651
0
votes
2
answers
51
views
Excel incompatible with itself
So I have a csv I created with excel in this format:
col1;col2;col5
a;b;c
d;e;f
I want to change it to the more usual " and , how can I do that as of now every change either changes the encoding or ...
- 446
0
votes
1
answer
40
views
Excel 2013 showing only certain dates in a European format
I have a CSV file where all dates are in a U.S. format (dd/mm/yyyy):
However, Excel shows some - but not all - of the cells in mm.dd.yyyy format:
This is on a server in Germany.
Does anyone know ...
0
votes
2
answers
237
views
How to deal with lines starting with '=' in Excel?
I want to obtain a simple CSV file that looks like this:
Filename,Value1,Value2
filename1.ext,0.38,0.44
filename2.ext,0.60,0.50
...
However, -unfortunately- some of my filenames start with = and ...
- 589
0
votes
2
answers
2k
views
Excel Formats Numbers as Dates
I have several very large .csv files that I need to work with, and Excel makes this very easy (obviously). One of the fields is in the format 10/3/2013 19:00, and Excel automatically converts this to ...
- 1,299
0
votes
0
answers
110
views
Excel is placing commas where it shouldn't
I'm working with climatic data from a bunch of counties around the country. The data is originally on the .csv format, and when I open it, I get a different result than my co-workers. Apparently my ...
- 111
0
votes
0
answers
39
views
Excel converts comma delimited to tab delimited when saving [duplicate]
I create data in Excel 2013 and save it as .csv. We have an application that imports files of type .address so after saving the file as customer.csv, I change the extension to customer.address. This ...
- 101