Questions tagged [csv]
Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.
1,010 questions
1
vote
0
answers
47
views
Powershell, reading from CSV, cell contains parentheses [closed]
Windows 11 24H2
PowerShell 5.1.26100.7019
Attempting to read from CSV file with PowerShell and count values contained within a specified cell. However, it appears if a cell contains parentheses, the ...
- 251
0
votes
1
answer
166
views
How to import into Excel a UTF-8 encoded CSV file containing line breaks within fields?
Importing CSV files containing line breaks within fields is tricky and the usual import methods as described for Excel do not work. Only opening a file directly with "File -> Open..." ...
1
vote
2
answers
110
views
Consolidate csv lines
I need to take multiple line items of a csv file and consolidate them into fewer lines while maintaining the information, as in the tables shown below:
Turning this:
Fave Fruit
Student
Apples
Dave
...
- 45
2
votes
2
answers
202
views
CSV file entirely in one row incorrectly in Excel 2021
Running Microsoft Excel 2021 MSO (Version 2509 Build 16.0.19231.20138) 64-bit at home. It will not display a CSV file correctly. All the data just goes into one row instead of 4 columns and any ...
- 313
12
votes
2
answers
4k
views
How can I color the columns of a CSV file differently in Notepad++?
How can I color the columns of a CSV file differently in Notepad++?
Example:
1
vote
1
answer
865
views
Import CSV weight data into Garmin
I've used a Smart Scale since 2020 with its own app which eventually became Zepp Life.
Having acquired a Garmin a while ago, would be a pity to lose all that data.
The good news is that we can pull ...
- 1,507
5
votes
3
answers
657
views
Saving Excel as csv file imports display value of percentage column
Question: My Excel file has a column, say, PercentageColumn, that is formatted with data type as percentage. For example it displays 13.4526961728569 as 13.45%. How can we make sure that when saving ...
- 241
0
votes
0
answers
89
views
Periodic copying, synchronizing, forwarding and merging of SQL database tables with MSSQL?
There is a modification project in our Process Plant related to SCADA application (Process Automation System) and I am looking for reliable advice/ suggestions from experienced members related to SQL ...
-2
votes
1
answer
123
views
Need values in column B to appear as a list (now CSV value) and the value corresponding it (value from column A) to be filled correspondingly
I have a category name in column A, and its corresponding attributes in column B as comma separated values. I need the attribute values to appear as a list and the value corresponding it (value from A)...
2
votes
0
answers
488
views
Why is Excel suddenly showing leading quote/apostrophe when opening a CSV? This apostrophe trick recommended by Microsoft seems to no longer work
Our application generates CSV files, which are typically opened by users in Excel. In order to format a certain column as "Text", we prefixed values with a single quote/apostrophe (eg ...
- 121
2
votes
2
answers
271
views
How to extract IP address and port from column in csv file using awk?
My goal is to use awk to parse tcpdump cvs file to extract network tracking and reporting information from columns #22 and #23 (columns and sample data) below:
1,2,3,4,5,6,,....,,22,23,,...
20-09-24,...
- 41
0
votes
0
answers
51
views
Merge and edit documents function in Word is asking permission for all records
I have successfully set up a conditional merge in Word linked to a csv file. It has always worked easily in the past by asking one time to approve the data source. All of the sudden when I go to ...
0
votes
0
answers
132
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
137
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
335
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