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
2 answers
26 views

MS excel not coping data in correct format from csv file

I am coping data from csv file it contains tables in that table there is column name PostedDate when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -) ...
-1 votes
1 answer
54 views

Find multiple matches and place all at multiple location instance

so I have this comma delimited file that I need to import but I need to do some replacements first. A sample is as shown below; item A,<u>1 a1</u> red<u>2 a2</u> etc,content,,,,...
  • 181
0 votes
2 answers
54 views

i downloaded a csv file, but data is not separated by commas

I downloaded a dataset from kaggle. kaggle data: but all the data is in one column in excel. data in excel: I need this data for my project. how can I get this data separated?
0 votes
1 answer
33 views

Dont want particular row to be displayed in powershell

Dont want row to be displayed. $out= "C:\temp\DD2.html" $css = @' <style> * { font-family: Calibri, sans-serif; padding: 10px; margin: 0px; text-align: left; font-size: 20px; ...
0 votes
1 answer
53 views

What does "Affected items" mean in the threat report of Windows 10 Microsoft Defender scan?

After conducting a full scan on my Fujitsu Windows 10 laptop today (Nov. 01, 2022), I got informed of this threat: Trojan:HTML/CryptoExtortBTC.A (I do not do anything about cryptocurrency. This seems ...
  • 151
0 votes
0 answers
14 views

Python 3.9 on Debian Testing and Missing Attributes for the CSV module

I have two computers (a workstation and a laptop) running Debian stable and they both have Python 3.9.2 installed (it is the standard Python 3.x you get on Debian stable). I understood that the csv ...
  • 101
6 votes
2 answers
959 views

Bulk fix for Excel 97-2003 error "format does not match extension"

Context I have received around 1700 97-2003 excel files with a ton of data including some text information. I am trying to read them all into Stata before I clean and run some statistical analysis. ...
  • 63
0 votes
0 answers
14 views

Ubuntu Server Convert .xls/.xlsx to .csv Date format is being changed libreoffice/gnumeric

issue is: xls/xlsx file contains dates as d-m-Y (12-11-1997), but when i use libreoffice or gnumeric via the terminal to convert to csv, it changes the dates to d/m/Y (12/11/1997), and in some cases Y/...
0 votes
1 answer
38 views

running 2 excel versions at once, cant associate filetype to older version

I have excel 07 and the latest Excel 365 (I think thats Excel 16) both installed in windows 10. When I just had 07, I had no problem associating csv and xlsx files with that program. Now that I have ...
  • 997
0 votes
1 answer
43 views

Notepad row count inconsistent before and after enabling *and then* un-enabling word wrap

I have a CSV file that contains 10,001 rows (10,000 rows of data and one row for the headers). When opening it in Notepad, scrolling to the very bottom, and clicking on the last row, I get "3659&...
0 votes
1 answer
39 views

How to make comma elements in Excel sheet be in their own row, with identical data for other columns

What I mean is, turn this: | ID || Names | | 1 ||A, B, C| | 2 ||A, D, F| into this: | ID || Name | | 1 ||A| | 1 ||B| | 1 ||C| | 2 ||A| | 2 ||D| | 2 ||F| The data I'm trying to transform has ...
0 votes
3 answers
78 views

How to convert CSV and TSV files to PDF?

I want to convert my online store's CSV and TSV files into .PDF format. How to convert? Is there any solution?
0 votes
1 answer
144 views

How to convert a CSV’s timestamp format?

I am trying to convert a CSV file that returns the time stamp as hh:mm:s.mmm into hhmmssmmm with the added s for second. For example I pulled a CSV file in which the time came back as 10:15:7.123 but ...
0 votes
1 answer
30 views

Move lines based on ending of previous line

Looking to get some insight as I'm lost on this one. I'd like to move lines based on the ending of previous one. It's a large CSV file that has a comment column that exported in line breaks from the ...
0 votes
1 answer
54 views

Copy only CSV files from source folders to destination folders

Atm I have the following: @echo off set src_folder=V:\Property\Account data\Open Market\2022 set dst_folder=V:\Property\Account data\Open Market\2022\Monthly Upload Files for /f "tokens=*" %%...
  • 1
0 votes
1 answer
66 views

Powershell: Export into .csv | Import from .xml

I was trying to Export a .xml-File to a .csv-File (multiple .xml-Files to one .csv-File) This is my working code: $path = "C:\Temp\Cert\" $FileLogdate = Get-Date -format 'dd_MM_yyyy' $...
0 votes
0 answers
44 views

Excel: How do i delimiter or change to this format?

Current format on the top, wanted format on the bottom The data expands along the columns first from month to month beginning on January to December for each municipality (and there are many). And in ...
0 votes
1 answer
42 views

How to insert filename from cell into excel formula?

I have a bunch of .csv files that have IDs that I am trying to insert into a formula. The IDs are all listed in column F. Here is F in my sheet: F 701 684 128 701 485 701 ... Each CSV file is in a ...
0 votes
2 answers
27 views

How to Convert 2 Columns of Data to Bullet List?

I have a csv of data that exists as a hierarchy. ColumnA = Parent ColumnB = Child There may be multiple children per parent. I would like to convert the excel data to a bullet list hierarchy. (if ...
0 votes
1 answer
44 views

Manual input column with restricted allowed values in power query imported table

I'm using the Power Query Editor in Excel in order to obtain a table composed of the content of all the CSV files that I put in a specific folder. This table contains a list of bank transaction. When ...
0 votes
1 answer
203 views

Replace strings from text file with csv values

I've got a txt file (template.txt) with stuff like: Hostname from Client: !hostname . OS !windowsversion and a CSV-Export from many clients: !hostname, !windowsversion exampleName, Windows10-Pro I'm ...
  • 1
3 votes
2 answers
367 views

How can we open CSV files that are using single quotation as string delimiter in Excel?

We are working with a set of data that contains all kind of characters (comma, semi-colon, double quotation, tab, etc.). To handle this situation, we are using single quotation to surround the strings ...
  • 447
0 votes
0 answers
14 views

Facing issue with Mobile number while i save my excel sheet to csv format [duplicate]

I`m using excel 2010. I have mobile number field in one of my columns, for example: 919810236547. After completing my work, i convert my excel sheet to csv (comma delimited) format. Then, when i try ...
  • 1
1 vote
2 answers
201 views

Export Excel sheet as CSV, with regional settings

I want to export an excel sheet as CSV, with powershell. The issue I have is that the regional settings are not respected. They say to use semicolon as delimiter, but comma is used instead. If I ...
  • 194
0 votes
1 answer
34 views

data recovery empty csv file created by arduino

Last week we launched a rocket, in which an Arduino saved the data of the sensor in a csv file. Every 30s the programme used myFile.close() and a new file was created. But even if the chute deployed, ...
  • 3
0 votes
1 answer
66 views

Libreoffice calc saving all column data into one

I created a csv file with two columns in it.When I tried to open it in word,all data combined into one column. I saved file as utf-16 and field delimeter as none,string delimeter as none.
  • 1
0 votes
0 answers
45 views

How to create custom Word dictionaries from .CSV files

I work with documents that use a lot of specific words that are flagged by the spell checker in Microsoft Word, such as scientific names of insects. Ideally, I would take data in .CSV format, and be ...
0 votes
2 answers
58 views

How to turn column data into csv data?

I've got a bunch of names (around 300), they were filled out as standard text in Excel. However in order to process this data I need to turn it into a list of names separated by commas (a csv). I can ...
  • 3
0 votes
0 answers
411 views

Stop Excel from re-interpreting date format on re-opening CSV

I have many large datasets that I am saving in .csv format, the input date values are in Julian format, but the final date format I want is dd/mm/yyyy hh:mm:ss. This part is simple, I just apply a ...
user avatar
0 votes
0 answers
74 views

How to change file extension from TXT to CSV in Sharepoint Online

I have a CSV-formatted file with a .TXT extension in a Sharepoint Online document library. I am able to change the file name but not the extension via Rename or Properties menu options: I have found ...
0 votes
2 answers
2k views

Adding Header to CSV file using Powershell

I have a CSV file and data in CSV file looks like below its vertically formatted. that file is not having headers i want to add header to that file. when i tried to add using below powershell script ...
  • 21
1 vote
0 answers
48 views

Copying a file from a linux embedded system to local machine connected by a Serial connection

I am connected to my embedded system by serial connection to my laptop(windows), and using puTTy I booted it up. It is collecting data and making a .csv file of the collected data. I would like to get ...
0 votes
1 answer
20 views

Incrementing values when values changes in different column in excel

i want to change values when id values changes to different in excel like this ID ChangedId 8 1 8 1 8 1 22 2 22 2 25 3 Any help will be thankfull.
2 votes
1 answer
322 views

How do i return true/false on get-content command for each username inside C:/Users?

We want to eliminate the existence of a bad config file we've identified (and also have the manual fix for) from within every users appdata folder. The config file only exists here and there and not ...
  • 923
0 votes
0 answers
64 views

Match a set of request and response of a capture file pyshark

The problem is this: I have a capture file and a bunch of http2 requests and responses inside. What I have to do is extracting all the request and response and write it on a csv file and for that I ...
  • 1
0 votes
1 answer
247 views

How to Export List of All services and user owner stated on services.msc to csv

I want to export a list with all services and users owners "Log on as" from services.msc In services.msc i can export the details to csv but the results are getting messy. I saw THAT and ...
  • 155
0 votes
1 answer
342 views

Regex first column header csv

What would the regex be for matching the first column header in a csv file? id,field1,field2 1,n/a,n/a 2,n/a,n/a ... I just safely want to match id
0 votes
1 answer
24 views

excel 365 macro that previously worked fine is now saving tabs as CSV with 9999 rows even if the rows are empty, why would it do that?

update: I also just tried to do a plain old 'save as' on my tab manually and that also results in the comma rows appearing up to 9999. When the spreadsheet is open I see no data in the rows that end ...
0 votes
1 answer
33 views

Why is Permon data time format is reversing day and month when I open csv in excel?

I have exported perfmon logs into csv. I open the csv in excel, and the 1st column has the datetime value, so I right click on it and format to select the following custom format: dd-mmmm-yyyy hh:mm:...
  • 194
0 votes
0 answers
140 views

Excel not opening .csv files

I reorganised my folders in Windows Explorer and when I try to open some .csv files with excel I get an error "Sorry we couldn't find "xyz.csv". Is it possible it was moved, renamed or ...
  • 1
0 votes
4 answers
4k views

.csv did not save all tabs

I downloaded a database in .csv and made pivot tables in different tabs. I saved the file without complications, but when I went to open it, only the tab with the database appeared, the other tabs did ...
0 votes
0 answers
75 views

Regex: isolate 1st column of a CSV file

Long time copy-paster, first time poster. I need to get only the first column in a CSV with the following format: "device name","IP address", ""CN=Person Name" ...
  • 1
0 votes
4 answers
744 views

How do I batch delete entire rows that do not end with forward slash in CSV file?

I have a CSV file that is too large because it contains file paths as well as directory paths. I need to modify it so it only shows the directory paths but not the files themselves. I'd like to know ...
  • 923
1 vote
0 answers
151 views

Use Microsoft Excel to import and refresh data from only some columns of a CSV

I have a CSV that's 100+ MB, so it takes a long time to load. In Microsoft Excel for Mac Version 16, I'd like to use the "Get data" or a similar functionality to load data from that CSV into ...
0 votes
1 answer
650 views

Replace header row for all csv files in a specific folder and create updated file in another folder?

I will be getting csv files regularly posted to a specific folder. Whenever the files are posted, I want my batch script to modify the header values and create a new file in a separate location (...
  • 3
0 votes
1 answer
627 views

Powershell - Merging two csv files

I am trying to merge these two CSV files, but having no luck. Can someone please guide me ? The idea here is that we have a process ('Chrome' in the example below), but that gets stuck frequently on ...
0 votes
0 answers
1k views

How to force the browser to (disregard mime types and) load the file in a tab instead of downloading?

Say there is a text file or a .csv in some http/https url. I want, instead of downloading, to load it in a browser as plain text, possibly parsing html or show tables if it’s a csv, chose correct ...
  • 11
0 votes
2 answers
208 views

I have a text file that has 2 columns I need to merge all lines in column 2 before the next column 1 attribute id

Have only ever dealt with very simple text to csv data formatting. I am working with a text file with 14900 lines for a mapping project. I have tried delimiting using tab etc but cannot get a single ...
  • 3
0 votes
1 answer
2k 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. ...
1 vote
2 answers
975 views

How do you open/import a CSV file with Unicode characters encoded as numeric character references?

In Excel, I tried to import (using Data > Import) a CSV file with Chinese characters. The characters are represented as Unicode numeric character references (NCR); for example &#39321;&#...
  • 113

1
2 3 4 5
20