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
0 answers
16 views

Importing CSV into Excel via Data -> From Text/CSV: Can I automatically apply the Power Query column formats?

Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bit I have an external program that creates CSVs. Some of the columns have eg. $ or %. The import query is smart ...
Scott's user avatar
  • 1
0 votes
3 answers
65 views

Replace X linebreaks with comma and delete every Nth linebreak

I have records in a text file formatted in the following way: Record1 Record1 Record1 Record1 Record2 Record2 Record2 Record2 ... I need to convert this file to CSV by replacing the first 3 line ...
Hashim Aziz's user avatar
  • 12.7k
0 votes
0 answers
56 views

How do I save the date formatting on a CSV file please

Hi I have several date fields created in an Excel file with the formatting of yyyy-dd-mm and yyyy-dd-mm hh:mm. I need to save as a CSV file but lose the formatting when re-opening the file. Any ...
Gwen Taylor's user avatar
-1 votes
0 answers
22 views

How to force Excel to export data to CSV with all cells quoted? [duplicate]

Are there options in MS Excel to use single or double quotes for every cell exported to a CSV? This is an issue for anyone exporting CSV files from excel, but there does not appear to be an option to ...
J. White's user avatar
0 votes
1 answer
47 views

How to speedup video with FFmpeg based on timestamps from CSV?

There are already questions with regard to speeding up a video with FFmpeg, like this one. My question is: Is there also a way to specify multiple sections which shall be speedup via an external CSV. ...
tim's user avatar
  • 350
0 votes
2 answers
247 views

How to set MS-Excel as default program to a .csv file in Windows 11 pro?

I am not able to set MS-Excel as default program for a .csv file in Windows 11 pro. I have tried many ways, but not able to do it. I have to either choose "open with" option or first open MS-...
Ajay Kumawat's user avatar
-1 votes
1 answer
35 views

What is causing the xcopy file from having an error in it?

I am new to xcopy. I am trying to move a file that is in excel format to a new destination and as a csv file. I have to do this so that the DMExpress ETL job can move the file and then read it. This ...
Sevanna's user avatar
4 votes
2 answers
834 views

How do I keep values the same when converting from XLSX to CSV? Export to CSV with expanded numbers and not scientific notation?

I have an XLSX file which I am opening with Excel 2016. This file includes a column "Code" which contains barcode values. The column has a number format of General. Looking at this column, ...
Jay Bee's user avatar
  • 143
0 votes
0 answers
29 views

Excel exporting to CSV. Can I use another character than " to enclose text? [duplicate]

(there is a similar question in How to avoid double quotes when saving Excel file as Unicode?, but the case described below has an issue with single doublequotes. Usually used for inch values like 3&...
I grok it's user avatar
0 votes
1 answer
90 views

Windows batch filename generator not running where am I going wrong?

I'm writing a windows batch script to take a .csv as input read data in each row as variables and output unique filenames to a new .csv in Windows batch script. I'm doing this to create an inventory ...
Gamma5779's user avatar
0 votes
1 answer
196 views

Can I make an excel template that will save as CSV automatically?

I want to make an excel template xltx that will automatically save the resulting workbook as a .csv. Open template -> blank workbook (and template data) -> Save -> CSV format already set. I ...
Mike Dannyboy's user avatar
0 votes
1 answer
414 views

Value in CSV file limited to 9 decimal places

I am facing an issue which I believe is being caused by an OS or regional setting, but not sure since I can't seem to fix the issue. I have two identical .csv files both created on different computers....
Patrick Keane's user avatar
0 votes
0 answers
144 views

Managing utf8 CSV on Mac

I use Excel on macOS and when I try to combine CSV files downloaded from SaaS platforms, it messes things up on the first lines. I don't have this problem when using Excel with Windows. For now, I ...
Aymeric's user avatar
0 votes
1 answer
129 views

Can libreoffice differentiate between .txt and .csv files?

Can libreoffice differentiate between .txt and .csv files? I have two file's that have a mime type of 'plain text document' text/plain detected. One file ends in .txt and the other ends in .csv. Is it ...
turtle's user avatar
  • 101
0 votes
1 answer
519 views

Removing duplicate rows in a CSV file as compared to another CSV file

I have a CSV file named CSV1 with over 5000 rows and 3 columns - last name, first name and email address. I have another file named CSV2 with about 2700 rows with the same 3 columns. I have to remove ...
user1842329's user avatar
1 vote
1 answer
39 views

How do I use an API to extract to CSV? [closed]

Sorry, I've tried reading up on it but I just don't understand any of it. There is an organisation, ALISS.org, which has a section with their API that lets you interact with their database of local ...
Kilm's user avatar
  • 11
0 votes
1 answer
409 views

Checking multiple .csv file exist or not from folder

We have a requirement needed to be checked and ensure multiple files start with number(s) in their name with .csv files in a folder. If yes then will proceed with further steps. If any of the files ...
Soundar Raj's user avatar
0 votes
0 answers
39 views

How to create a static website from MBOX file

I have a large MBOX file (16000 emails) from a public email group which is now closed. For archival and research purposes, I would like to serve these emails on a website. How can I go about ...
misaligar's user avatar
  • 213
0 votes
2 answers
360 views

Exporting same format to CSV

The command below I took straight from Microsoft's website. It works and produces results like this: Name, PasswordLastSet, and LastLogonStamp. Now, I need to know what I have to put in to export ...
K Val's user avatar
  • 11
0 votes
0 answers
58 views

Concatenating of the strings of the each paragraph

Is there way concatenate the strings of the each paragraph in one line? For example, I have many the same paragraphs with the space between them, it looks like: Is there way to put each such ...
Timur's user avatar
  • 21
0 votes
1 answer
77 views

Why do Ratios not carry over from Xlsx to CSV format

I have an XLSX file that we have output from SAS. The column in question are results from an assay that result in a titer ratio, "NEG" or "Not Assessed". In the XLSX file the ...
Grey Clevenger's user avatar
0 votes
1 answer
447 views

Change encoding to Unicode in .csv exported from Gmail

I'd like to copy the typed-in addresses from Gmail to Outlook 2021 (Windows 10). To do this, I'm using the Google Contacts Export to Outlook CSV function and nk2edit. The problem is that the special ...
MorganInTheMorning's user avatar
0 votes
1 answer
3k views

How to export Get-ADUser results to CSV without quotes and with additional blank fields?

I'm trying to export some data from our Active Directory to a .csv file. The file needs to have certain columns (because the tool which will import the .csv file is very strict and I cannot alter it) ...
Joe's user avatar
  • 313
0 votes
1 answer
337 views

Convert (part of) XML data back to tabular data or CSV/tab separated without using scripting

Is there an easy way to convert (part of) XML data back to tabular data, so comma separated values or tab separated or Excel? I sometimes get XML log files, and for clarity and comparing it more ...
BdR's user avatar
  • 201
1 vote
1 answer
832 views

How to create a line break in Anki when importing from a csv file?

While creating a deck for Anki using the import functionality from csv, I've run into an issue getting the line breaks to function properly. Here is the situation: This is for the front card It is ...
Still Learning's user avatar
0 votes
0 answers
38 views

How can I extract two or three "parallel" XPaths on a web page to/in a format that can be imported into a spreadsheet?

How can I extract two or three "parallel" XPaths on a web page to/in a format that can be imported into a spreadsheet? Here is an example: on https://www.amazon.co.uk/s?rh=n%3A20606777031&...
d-b's user avatar
  • 814
1 vote
1 answer
368 views

How to tell Excel to change right encoding in opened file?

Can somebody tell me please how to tell Excel to set up right encoding for csv file? It seems it is not possible without any annoying steps. I would like to see something like Libre office or Open ...
Čamo's user avatar
  • 345
1 vote
0 answers
567 views

How to convert list of SBOMs to one CSV file?

I have the ability to create multiple SBOMs for many projects in Synopsys Black Duck Hub. They can be in the SPDX or CycloneDX SBOM standards in a JSON, YAML, RDF, or tag:value formats. Is there a ...
Paradox's user avatar
  • 321
0 votes
1 answer
132 views

Powershell script GPO USER LOGON not working WINDOWS SERVER 2019

I created Powershell script to collect mac address and pc name for all my domain users .. Script run correctly on local machine .. but not working via GP $wmifilter = 'PhysicalAdapter=True AND ...
Mohammed atrash's user avatar
0 votes
1 answer
405 views

Need to Split 5M Lines Text File into separate CSV files

I want to create CSV file from every 1048574 lines from a large CSV file which as 5M lines. I want to use something like Notepad++ to divide it out into different files. How can I do that ? Thanks,
Cell-o's user avatar
  • 421
1 vote
1 answer
115 views

Failure to convert JSON to CSV file

I need to extract a particular anti-virus product scan results from a JSON file and list the elements in csv format for further processing. JSON file sample as below: Contents of a file scanresults....
Sam Chan's user avatar
-1 votes
2 answers
190 views

In csv file search concern number for particular text in second column

I have main two csv files as follows: file1.csv 731,dev-servers.com.,A,192.168.0.10 598,test-servers.com.,A,192.168.0.12 599,test1-servers.com.,A,192.168.0.11 file2.csv dev-servers.com.,A,192.168.0....
user1789869's user avatar
0 votes
1 answer
350 views

Why can't I type a single quote at the beginning of a cell in LibreOffice Calc when editing a CSV file?

When editing a CSV file in LibreOffice Calc, I have found that it is not possible to type a single quote at the beginning of a cell for both numbers and strings. When attempting to do so, the quote is ...
Welgriv's user avatar
  • 133
1 vote
1 answer
696 views

Excel: How to search for values from a column within a cell that has comma seperated values

I have one column with text in seperate rows, and a cell that has comma seperated values within the singular cell, as below. One Two AB AB, EF CD ... I'd like a formula to return True if any text ...
user1784316's user avatar
0 votes
1 answer
299 views

Download CSV file with todays date from Outlook inbox and save it to a folder using powershell. My code doesnt seem to be working

I am trying to write a powershell script to download a csv emailed daily save it to a folder, and then process it using powershell/excel. I have already written the powershell to open up the file and ...
Icebreaker 808's user avatar
0 votes
1 answer
357 views

Column sort is not putting numbers in the correct order

I am uploading a .csv file into a third-party program with the following data for example: When the (third party) program sorts this data by the 'Number' column it looks like it is sorting the column ...
Dr_Xunil's user avatar
  • 336
0 votes
2 answers
643 views

Use PCRE2 Regex to group phrase before colon AND group comma separated values

I have what seems to be a simple task but isn't working for me. Using only PCRE2 Regex (nothing else), I am trying to collect a phrase before the first colon at the beginning of a line, then separate ...
Tushar Bhutt's user avatar
0 votes
2 answers
69 views

Misleading data format Excel .csv

I am generating a .csv file with data like the example below: TIME,LUX 18:00:00,30 18:00:01,30 18:00:02,30 18:00:03,30 18:00:04,30 18:00:05,30 18:00:06,30 18:00:07,30 18:00:08,30 18:00:09,30 18:00:10,...
Geisterfahrer's user avatar
2 votes
1 answer
1k views

Use REGEX only to group multiple key value pairs on line with anchoring text?

TL;DR: How can I grab a series of key:value pairs that are comma separated, but only if they start with specific strings? Hello, I have a situation where I have a block of text with multiple lines, ...
Tushar Bhutt's user avatar
0 votes
1 answer
1k views

Awk exact string match in a specific column only returns header row

I have a 6-7M row CSV file that end users wish to review with Excel or Numbers. Each user only needs to review a subset of the file, so I was hoping to offer an awk one-liner that they can use until ...
Dan Wagner's user avatar
1 vote
1 answer
499 views

Using REGEX only, copy last (delimited) word to every comma separated value?

I have a series of lines with arbitrary number of comma separated values, and then a hash marked comment. The challenge is, using only PCRE2 regex for use in PERL, to do the following: Store the ...
Tushar Bhutt's user avatar
0 votes
0 answers
789 views

How to import multiple csv-files in Excel at once with VBA

I am trying to import multiple csv-files within the same directory into my Excel sheet using VBA. The following code is working very well with just one csv-file. But I lack the knowledge to adapt my ...
Caroline's user avatar
0 votes
2 answers
861 views

Remove comma and next 3 characters from line with sed

I'm writing a shell script to send fail2ban logs to a postgres database. The event timestamps in the application log annoyingly shows the milliseconds of the event separated with a comma (like this: ...
Tom Calleja's user avatar
0 votes
2 answers
158 views

I have two cells each with comma delimited values, I want to combine these into one cell

I have two excel cells(A1 and B1) each contains comma delimited values in, I want to combine these values into one cell (C1), so that the first value from cell A1 is "linked" to the first ...
James's user avatar
  • 1
1 vote
2 answers
846 views

Add header efficiently to a large CSV file using PowerShell

I need to add headers to a large CSV file (900+MB) but PowerShell stalls for 3 hours+ on my system and sometimes even crashes. Question: Is there a way to stream the data through instead of loading ...
Re1iant's user avatar
  • 13
0 votes
0 answers
53 views

Adobe form import

I am trying to import data from a tsv into my Adobe form. I am having trouble importing my "Representative" field. Any ideas? Below is a link to the examples of the files I am working with. ...
Clay's user avatar
  • 1
1 vote
1 answer
641 views

Excel - CSV file formats Date column in different ways

I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table. The problem I am facing is that the date ...
totoro01's user avatar
0 votes
2 answers
2k views

Using CSV as source to copy files

I have a CSV file (semicolon-separated, actually) in Windows, with column header info.  One of the columns contains a partial filename; it's a filename without path or extension.  I've been trying to ...
RandomUser's user avatar
0 votes
1 answer
372 views

Strange characters inserted by Libreoffice when opening a .csv file and then saving it (on Linux)

Here is what I did: touch file.csv Open this file in Libreoffice. Pasted a tabular text from the internet. Saved it in Libreoffice in Text csv format. When I do the above, Libreoffice inserts 2 ...
user2338823's user avatar
-1 votes
2 answers
179 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 -) ...
mandarr242's user avatar

1
2 3 4 5
20