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 ...
- 103
-1
votes
2
answers
246
views
MS excel not coping data in correct format from csv file
I am coping data from csv file
it contains tables
in that table there is column name PostedDate
when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -)
...
- 8,931
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 ...
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 ...
- 1,524
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 ...
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**...
- 606
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
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 ...
- 27.2k
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
...
CommunityBot
- 1
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 ...
CommunityBot
- 1
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
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
0
answers
751
views
Excel 2013 keeps removing commas from CSV at save
I'm working with data exports in CSV format. Excel originally opens the files correctly. However, I've been merging in some missing data that my original queries missed (adding four rows of additional ...
- 123
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 ...
CommunityBot
- 1
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 ...
- 6,352