Questions tagged [csv]

Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.

Filter by
Sorted by
Tagged with
0
votes
0answers
22 views

How to make LibreOffice Calc correctly interpret the desired number format for Time

I am appending to a CSV file programmatically with Python, which currently contain timings in the format: 0:1:10 (e.g. representing 0 hour, 1 minute, 10 seconds). When I open the CSV file in ...
0
votes
0answers
24 views

How to save filtered results in Procmon to a .csv file?

I have included the entire script below. It works without this added piece at line 16. If I remove the added code at line 16, the script will complete but does not save the filtered information. /...
1
vote
0answers
19 views

Excel 2019 default encoding for csv files

Problem I'm using Excel 2019 and I have this .csv file(Multiple language) which is in UTF-8 encoding and when I try to open the file, Excel opens it in ASCII encoding — the english characters and ...
0
votes
1answer
21 views

exporting .olm file to csv on Mac

I am using outlook on mac and trying to export .OLM file and convert it to CSV file for analysis purpose. Any idea how to transform outlook .OLM file into CSV?
0
votes
0answers
13 views

How do I create a side-by-side file diff importable as a *table* by Excel, Word, or Google Docs?

diff -y file1 file2 creates output like this: I want to take this output and convert it to a CSV format where the text at left is in one column, the < or | or >, if any, is in the second ...
0
votes
0answers
11 views

.csv files adding extra commas in numbers

I have a csv file in which I am pasting the following value as text in a column. 6535,27419 However, when I save and close the csv file and open it again, it shows me the data as 6,535,27,419 ...
0
votes
1answer
34 views

When importing a csv into Excel(2016) is there a way to specify which data should be column headers?

I have a csv file user1,Donated,460 user1,GiftedT1,137 user1,GiftedT2,205 user1,GiftedT3,144 user1,Cards,123 user2,GiftedT2,123 user2,Donated,123 user2,Cards,123 Is there a way when importing the csv ...
0
votes
1answer
48 views

Convert a columns in Row into a comma separated list

I have this example : And want to convert it to this comma separated as CSV like this:
0
votes
1answer
8 views

How to delete a column using CSVed?

I need to delete a column using CSVed, actually Column 2 in this screenshot: I tried right clicking on Column 2 -> Delete selected columns However this does not work, it gives me "Select one ...
0
votes
1answer
20 views

How to Copy Text in a .CSV file using Power Shell

Looking to copy and replicate text in a .CSV file on a server and I found this piece of code which I was able to modify and use. It seems to work on my PC which has office installed but not on the ...
1
vote
1answer
78 views

How to import CSV using single quotes in Excel for Microsoft 365

My company recently upgraded from Excel 2016 to Microsoft 365. Before the change, when importing from Text/CSV the wizard would have an option for the delimiter and the quote character. Now, there is ...
0
votes
1answer
38 views

Make a copy of an Excel file as a CSV without having Excel "re-open" the file as a CSV

I have several dozen Microsoft Excel files in xlsx format. These files are the "master" copy for editing and include various formatting to make them easier to edit. However, the data from ...
0
votes
1answer
112 views

How to automatically sum columns datas of a grouped row subset with common attributes (excel csv spreadsheet)

I have a big csv file (one million rows) I imported in excel. I have to do a simple operation, easy to be done manually, but I should do it for thousands groupings so I am looking for an automated ...
0
votes
0answers
9 views

How to specify output file cell format when using ssconvert --merge-to to create ODS file from multiple CSVs?

I successfully converted a series of .csv files into a single .ods spreadsheet file, but I had a minor formatting problem: all cells with date contents ended up with date and time format. Command used:...
0
votes
0answers
64 views

SHIFT JIS encoding is missing in Microsoft Excel 2016 (MAC OS)

In Microsoft Excel 2016, if someone wishes to open or save a CSV file with SHIFT JIS encoding, the way to go would be: Create a blank CSV file. GO to Data tab. From there, select "From Text"...
0
votes
2answers
27 views

How to delete blank rows in csv files using the Miller command line tool?

I have a csv file (on Mac) with many blank rows. I am using the Miller command-line tool for other processes and would like to remove blank rows also using that tool. I can't find anything in the docs ...
0
votes
2answers
82 views

How to merge multiple Mac excel files all with headers that are the same but out of order

I am using a Mac. My excel files have headers that match but are out of order. They all start with a header named "query" and then it gets mixed after that. Here are some header examples: ...
0
votes
1answer
76 views

Speedtest Ookla No Timestamp in CSV output

So when running the official speedtest client from Ookla and outputting to a CSV file, I've noticed the output has no timestamp field. The JSON does, but I'm not particularly savvy with jq and trying ...
0
votes
0answers
36 views

Collect Group Members & Administrator from different group on AD (PowerShell)

I need your help about a PowerShell script and I’m a newbie on PowerShell. I have to collect members and administrators of different groups from AD, in .csv format. I have a specific way for that on ...
3
votes
3answers
3k 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
0answers
18 views

Awk stopping printing at "

I'm making an awk script to convert a csv of aliases into a shell script to apply them, but I'm having an issue where awk seems to be stopping at a " in the second field. The command I'm running ...
1
vote
1answer
41 views

Splitting files in Mac and then adding .csv extension removed them?

I have been following the methods from this YouTube video. Method: cd /Volumes/Seagate/Work/Tickets/Thirdticket/Extinction/species_all.df split -b 10000m species_all.csv for i in *; do mv "$i&...
2
votes
1answer
53 views

Two different computers downloading same spreadsheet - data displays differently

I work for a company in the United States. One of my clients is in Montreal. Whenever the client tries to download a spreadsheet from our network, she ends up with a bunch of data bunched into Column ...
1
vote
1answer
21 views

to get the unique records

I have the below csv file for each day in month. I need unique count of users from this. we need monthly count. "DATE","TIME","User Type","User ID","IP ...
0
votes
2answers
182 views

How to use Power Query to import multiple CSV files into a single Excel worksheet as worksheet columns?

I have a recent version of Excel (but very little experience with Excel). From a folder containing many .csv files, I want to import a few of the files as columns to a single Excel worksheet. I ...
0
votes
0answers
47 views

CSV is not removing Emojis

I have an excel with emojis on them (a huge file of 40K records). Upon converting to csv format it used to remove my emojis automatically. Now, this feature is somehow not working and I am still ...
2
votes
2answers
92 views

Powershell script help needed for displaying network interfaces

I have a script [below] that returns information about the network interfaces in .csv format, but I also need the InterfaceAlias of each adapter returned; unfortunately, I cannot get get-wmiobject ...
0
votes
0answers
27 views

ParseExact Argument Error Despite Working Output

I am trying to import a CSV with column "RequestDate" which contains dates and convert that to datetime. To simplify the test, the only date entered in the CSV is 5/26/2021. The CSV is saved ...
1
vote
0answers
42 views

Loading UTF8 CSV files generated on a Mac into Excel on Windows: does not recognize encoding

When I generate a UTF8 CSV file in Excel (or some other way) on Windows and then open it n Excel, I expect it to ask me to choose the right encoding. I got a UTF8 CSV file that was generated on a Mac. ...
0
votes
1answer
27 views

Post-processing of multi-column CSV: remove dublicate lines + sort

I am dealing with the csv produced by the concatenation (via cat) of several CSVs: ID(Prot), ID(lig), ID(cluster), dG(rescored), dG(before), POP(before) 1000, lig40, 1, 0.805136, -5....
0
votes
1answer
25 views

Sorting lines according a column value

I need to sort all of the linnes in the csv filles according to the number contained in the second column from min to max, ignoring the first (header line): ID(Prot), ID(lig), ID(cluster), dG(...
0
votes
0answers
432 views

PowerShell returns "Failed to find the user on the channel roster" upon using Add-TeamChannelUser - Role Owner with MicrosoftTeams Module

I'm exploring PowerShell while also trying to come up with a Microsoft Team auto creation that involves Owner/Members of Private Channels being added based off .csv files. This is what I've come up ...
0
votes
2answers
122 views

awk Removing Double Quotes from CSV File Quoted Strings separated by comma

I have a csv file I would like to remove any rouge " or , in it. The problem is all my fields look something like this "***********","*********", where * = can be any ...
0
votes
1answer
55 views

In Excel, how to treat values starting with = as text and not a formula?

I have data exported from a database that's in a CSV that I need to view and manipulate in Excel. The problem is that some of the values in the cells start with an equal sign ( = ) so Excel thinks ...
1
vote
1answer
52 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
2answers
95 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 ...
28
votes
6answers
7k views

Why isn't there a delimiter character in ASCII?

My question is: Why is there no specific "delimiter" character? One that would be used for all types of delimiting. We have special characters for new line, print-settings, etc... Why do we ...
0
votes
0answers
21 views

I am searching for a way to Export a .csv in Excel on MacOS with a specific separator "$"

I am searching for a way to Export a .csv in Excel on MacOS with a specific separator "$". I don't want to open the Excel with a Text Manipulation program to search and replace ";" ...
0
votes
0answers
13 views

Check duplicate then copy $ cell next to duplicate

I have a large dataset with duplicates in multiple columns the only exception is that for every duplicate the cell (email) is different. I want to copy that email and place in the same row as the ...
0
votes
1answer
43 views

How to find/replace only numbers at the end of a row?

I have a column of course names where I'm replacing anything that isn't in Roman Numeral at the end with one. So, for example: "My Course 1" should be "My Course I". I'm using the ...
0
votes
1answer
120 views

Shuffle rows independently in a large file

I need to generate a random shuffle a very large csv (where I don't know in advance how many columns would be) in this way. So I have to go from this form 1,a,... 2,b,... 3,c,... to something like ...
0
votes
1answer
44 views

How to remove lines if they appear more than once in Notepad++? (removing both lines!)

Here's how my .csv looks : 36;Masashi MOTOYAMA 38;H. SOGAHATA 38;Hitoshi SOGAHATA 47;Masami IHARA 52;S. ONO 52;S. ONO For my project, I need to add one by one every missing id. I want to keep the ids ...
1
vote
0answers
27 views

secure file copy (scp) back and forth from remote line to Windows

Need to learn more about scp but I was able to transfer an entire directory (registry_configs) of CSV files from a remote linux machine (geb@192.168.0.106) to my Windows 10 environment with this: scp -...
0
votes
0answers
54 views

Jira -- export tempo timesheet (grid view) to Excel

Jira: How do you export tempo timesheet (grid view) to Excel -- either .csv or an ordinary excel file. I am using Microsoft Edge browser, and there is no easy link available (such as Export). I ...
0
votes
1answer
158 views

Open Semicolon Delmited Text File in Excel Via Double Click

I can make Microsoft Excel open up a semicolon separated value text file by placing "sep=;" at the beginning of the file. Then upon double clicking, it properly separates every column and ...
0
votes
3answers
85 views

Export SSL & TLS Registry Keys to XLSX

I'm currently looking to find out all SSL and TLS Registry value information on the system. I need help writing a script for powershell to look at a list of hosts that are on a csv/txt file then ...
0
votes
1answer
2k views

Importing large volume of dummy data into pgAdmin 4 by csv - Failed (exit code:1)

I am trying to upload a large amount of dummy data into my pgadmin tables. I was able to use a csv for the smaller tables however I have a larger spreadsheet of data that includes descriptions (with ...
0
votes
1answer
22 views

Excel file reopens with vertical bar symbol

When saving a file in Excel (tested as a CSV and Workbook), when reopening the file the commas have been converted into a vertical bar | (pipe symbol), and the columns have merged. What is causing ...
0
votes
1answer
676 views

Import multiple TXT files to one Excel csv sheet using Text Import Wizard macro?

I need to import data from approximately 30 individual TXT files into one CSV sheet. They are all formatted the same, so the Text Import Wizard should work. However, instead of running the Text Import ...
3
votes
1answer
65 views

Powershell - Combine two CSVs with 1 CSV Dynamic

I have created a Powershell script to send alerts based on network status' found by running a Python script to check Uplink status. The Python script creates a CSV and my Powershell script selects the ...

1
2 3 4 5
19