All Questions
Tagged with microsoft-excel csv
495
questions
0
votes
0
answers
45
views
Can't save CSV file from Excel (Windows 11, MS Office Home and Business 2019) to WSL 2 folder
I have an Excel file (MS Office Home and Business 2019, running under Windows 11) that I want to save as CSV file in a WSL folder underneath my WSL home folder. WSL is running as version 2 with Ubuntu ...
- 181
0
votes
0
answers
46
views
How to append multiple .csv into one .csv (not multiple sheets .xlsx)?
Looking to do something like this:
Is there a script that can do that? I've tried searching and the scripts are either 404'ed or they merge them into a single .xlsx with multiple sheets.
0
votes
0
answers
70
views
Excel treats a date in format (dd-MMM-yy) differently if typed or pasted
This was discovered when opening a file in CSV format that has a column of dates in the format dd-MMM-yy (e.g 20-FEB-24). When opening this file in Excel (Excel 365 desktop) if the 2 year value is <...
- 101
0
votes
1
answer
99
views
Excel - how to handle custom timestamp format
I have some measurement data from a datalogging software, saved as CSV, and one column contains time stamps like this:
12.04.2024 15:11:32:684
12.04.2024 15:11:35:752
The format of this is:
dd.mm....
0
votes
1
answer
71
views
What gives Excel/csvs their formatting functionalities?
When I open a csv file by double-clicking it, it opens, and as one would expect, displays the data in a big array of cells with a ribbon of formatting options at the top (Clipboard, Font, Alignment, ...
- 3
0
votes
3
answers
41
views
Excel removes delimiters from first field of "foreign" CSVs
Here's a CSV (UTF-8 BOM encoding), with some values delimited with quote marks:
AAAAA,BBBBB,CCCCC,DDDDD
"a2",b2,c2,d2
a3,"b3",c3,d3
a4,b4,"c4","d4"
a5,"...
- 101
-1
votes
3
answers
889
views
PowerShell: Export Ping Results to CSV
I have a PowerShell loop that does effectively what I want it to. The problem is that the output is very messy. I work for an ISP and one of the most effective ways we have to diagnose network issues ...
- 11
0
votes
0
answers
24
views
Importing CSV into Excel via Data -> From Text/CSV: Can I automatically apply the Power Query column formats?
Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bit
I have an external program that creates CSVs. Some of the columns have eg. $ or %. The import query is smart ...
- 101
0
votes
0
answers
470
views
How do I save the date formatting on a CSV file please
Hi I have several date fields created in an Excel file with the formatting of yyyy-dd-mm and yyyy-dd-mm hh:mm. I need to save as a CSV file but lose the formatting when re-opening the file. Any ...
0
votes
2
answers
2k
views
How to set MS-Excel as default program to a .csv file in Windows 11 pro?
I am not able to set MS-Excel as default program for a .csv file in Windows 11 pro. I have tried many ways, but not able to do it.
I have to either choose "open with" option or first open MS-...
-1
votes
1
answer
57
views
What is causing the xcopy file from having an error in it?
I am new to xcopy. I am trying to move a file that is in excel format to a new destination and as a csv file. I have to do this so that the DMExpress ETL job can move the file and then read it. This ...
- 1
4
votes
2
answers
1k
views
How do I keep values the same when converting from XLSX to CSV? Export to CSV with expanded numbers and not scientific notation?
I have an XLSX file which I am opening with Excel 2016.
This file includes a column "Code" which contains barcode values. The column has a number format of General.
Looking at this column, ...
- 143
0
votes
0
answers
29
views
Excel exporting to CSV. Can I use another character than " to enclose text? [duplicate]
(there is a similar question in How to avoid double quotes when saving Excel file as Unicode?, but the case described below has an issue with single doublequotes. Usually used for inch values like 3&...
- 91
0
votes
1
answer
365
views
Can I make an excel template that will save as CSV automatically?
I want to make an excel template xltx that will automatically save the resulting workbook as a .csv.
Open template -> blank workbook (and template data) -> Save ->
CSV format already set.
I ...
- 222
0
votes
0
answers
204
views
Managing utf8 CSV on Mac
I use Excel on macOS and when I try to combine CSV files downloaded from SaaS platforms, it messes things up on the first lines. I don't have this problem when using Excel with Windows.
For now, I ...
- 1