All Questions
15
questions
-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 -)
...
3
votes
3
answers
4k
views
How can I open .csv files on Excel if Excel isn't in the list?
After my laptop got formatted, .csv files are opening only through Notepad. I want .csv files to open with Excel always.
For this, I tried changing its default app to Excel, but unfortunately got no ...
1
vote
1
answer
806
views
Csv file - User permission needs to be created after each save
For context, I'm uploading a csv file to a Postgres database via the psql command line. The cmd can only access the file after I add Everyone to its permissions and allow full control.
The weird thing ...
1
vote
2
answers
609
views
Opening csv file with notepad with two different desktop running both windows gives different results
Opening csv file with notepad with two different desktop running both windows gives different results
One of the desktop when opened, it's kind of lined nicely with newline, but somehow the other one ...
0
votes
2
answers
4k
views
CSV File doesn't look like a table
I have downloaded a csv file, and when I open it in excel, it looks like the image below.
I would like to view the data in a table format. with each field in a separate column.
1
vote
2
answers
3k
views
Splitting a xlsx/csv file based on column value
I'm aware this question has been asked previously, but I've had no luck with previous answers. My spreadsheet has around 30000 total lines.
My spreadsheet is formatted like this:
Name,colour,...
0
votes
1
answer
39k
views
Command Prompt output to CSV
I'm using the forfiles command to list files and folders (included sub folders) which is piped to a text file. My subsequent process requires this output to be in comma delimited format (.csv).
This ...
2
votes
1
answer
982
views
Create an animated plot of data points from csv
I have a large CSV File containing some data points [~3MB, example data] as a series of coordinates.
I want to create an animated plot of point where the point is moving acoording to the given ...
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 ...
23
votes
4
answers
32k
views
Excel does not honor the delimiter setting for reading or writing CSV files
When saving/opening CSV files in Excel, the default separator is a semicolon ;, as I need it to be a comma , I tried to change it by changing the Language and Regional settings following several other ...
0
votes
3
answers
8k
views
Excel - take two csv files and map them
I have two csv files. One has a list of emails, another has a long list of emails with first names, last names, addresses, etc. What I am looking to do is take both of these files and map the emails ...
4
votes
2
answers
17k
views
Run Command to open csv file in excel
My first question on the site, so hopefully I'm doing this right.
I use file juggler on my windows machine. The program can watch for new files and trigger run commands.
When a new csv file arrives ...
20
votes
2
answers
100k
views
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited)
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited) file types in excel 2010? They are all listed as a save file type, but ultimately are Comma Separated Value files.
4
votes
2
answers
5k
views
How to export multi-line cells to CSV file
I have an XSLX file where some rows have multiple lines, for example:
test
test1
test2
When I'm trying to export (using menu "Save As") this file as CSV or Excel workbook (1997-2003), Excel ...
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 ...