All Questions
Tagged with microsoft-excel csv
141
questions with no upvoted or accepted answers
1
vote
1
answer
1k
views
How to export full data from excel as a csv using macro?
I want to export an excel file as a csv using macro, but my code is only exporting the header only. How to export the full data?
Here's my code:
Sub CSVFile()
Dim My_filenumber As Integer
Dim ...
- 11
1
vote
1
answer
454
views
Open .csv file with template from XLSTART
I'm testing the program which would create a large .csv file and need to open it with minimum clicks (saving my hands) during testing. The file contains 20+ columns of counters, no formatting ...
- 11
1
vote
1
answer
134
views
excel grid to columns
I have data in an array/grid like this:
Name | Group | A1 | A2 | A3
name1 | Group1 | 14.95 | 19.95 | 0.00
name2 | Group2 | 4.95 | 9.95 | 12.95
name3 | Group2 | 49.95 | 0.00 | 0.00
And I need a way (...
- 11
1
vote
1
answer
2k
views
Excel 2010- long number corruption
I have a set of data, received in .csv format, in which I have a set of long UPRN numbers. I am involved in data matching processes related to new IER voting regulations.
When I open the .csv file the ...
- 11
1
vote
1
answer
1k
views
excel 2010 is appending a space to the end of currency field when saving a csv file
Create an Excel spreadsheet with one cell. Put "$1,234.56" (WITHOUT the quotes) in the first cell. Save it as test.csv. Open test.csv file in a text editor, Notepad.exe will work. The file contains "$...
- 11
1
vote
0
answers
257
views
Is there a text file format that Excel supports opening and saving directly?
I want to edit simple table data in Excel 2010, which is to be stored only in a flat text format (i.e. not a binary format like XLS or XSLX) which is viewable with notepad and can be read by a simple ...
1
vote
1
answer
3k
views
Can I output results of a MySQL query to a csv file via Putty?
I've typed the following code to output the csv file , but it shows an error
mysql> SELECT *INFO OUTFILE 'd:/student.csv' FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\...
- 11
1
vote
1
answer
2k
views
Having formatting problems when exporting table from phpMyAdmin
I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format.
...
- 797
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 ...
- 804
1
vote
2
answers
644
views
Formatting of output .csv file generated by a software
I've been using a software which gives the output in .csv format automatically. In my .csv output file "." is used as a decimal separator. In my colleague's computer, the same software outputs the ....
- 1,715
1
vote
1
answer
8k
views
Export CSV with values enclosed with double quotes
How do I export a CSV file where the values and fields are both enclosed in double quotes (") from Excel 2004 (Mac)?
E.g.
"Name","Telephone"
"John Doe","555-5009"
- 522
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 ...
- 181
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.
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
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....
