All Questions
Tagged with csv microsoft-excel
495
questions
1
vote
2
answers
7k
views
How to I export filenames, filepath and properties of a directory tree to CSV?
I have a hard drive full of backups that I need to detail on a spreadsheet quickly and in the following specific way. I'm hoping there's an easy way to do what i need via some sort of .bat or .cmd ...
0
votes
1
answer
5k
views
Excel VBA save to CVS file
I have an excel file which has a macro which saves the file as a .CSV file. I have a program that calls on the CSV file but the program only recognizes the .CSV file if I open it manually and save it. ...
125
votes
20
answers
555k
views
How do you force excel to quote all columns of a CSV file?
Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?
0
votes
0
answers
47
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 ...
0
votes
3
answers
7k
views
Need a batch script to copy data from A.csv to B.xls
I'm a newbie to batch scripting and need help.
I want to copy the contents of a csv file A.csv to the first worksheet named "GenData" in a existing XLS file B.xls.
B.xls contains some macros in it's ...
0
votes
0
answers
47
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.
1
vote
2
answers
4k
views
How to plot 3D graphs in Excel from CSV data?
I have data formatted like this in a csv file:
a, 1, 4, 6.0
a, 2, 42, 16.0
a, 5, 14, 69.3
a, 11, 4, 7.0
b, 1, 45, 6.0
b, 2, 45, 1.9
b, 9, 2, 4.4
b, 11, 4, 7.9
lines with first parameter a is one set ...
12
votes
7
answers
65k
views
Why is Excel removing leading zeros when displaying CSV data?
I have a CSV text file with the following content:
"Col1","Col2"
"01",A
"2",B
"10", C
When I open it up with Excel, it displays as shown here:
Note that Cell A2 attempts to display "01" as a number ...
0
votes
1
answer
108
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
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 <...
2
votes
1
answer
18k
views
Default character encoding for Excel Text Wizard?
A large part of my job is to run an SQL query, save the results as a UFT-8 encoded csv file then import it into Excel for further manipulation and distribution.
When I import the csv file into Excel ...
2
votes
1
answer
15k
views
How to automatically import data from csv file and append to existing Excel table
I have a .csv file and a master excel file. The master file contains a table and I would like to automatically append the data in the .csv file to the existing table. The data has the same headers and ...
0
votes
4
answers
10k
views
Imported CSV file into Excel but cannot convert the numerals from TEXT to a usable number format in order to calculate sums
I've imported a CSv file into excel - but the numbers are in a TEXT which I cannot use in calculations
How can I convert the numerals into a usable format to complete calculations ?
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, ...
-1
votes
3
answers
1k
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 ...