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
2 votes
1 answer
15k views

How to automatically import data from csv file and append to existing Excel table

I have a .csv file and a master excel file. The master file contains a table and I would like to automatically append the data in the .csv file to the existing table. The data has the same headers and ...
0 votes
4 answers
10k views

Imported CSV file into Excel but cannot convert the numerals from TEXT to a usable number format in order to calculate sums

I've imported a CSv file into excel - but the numbers are in a TEXT which I cannot use in calculations How can I convert the numerals into a usable format to complete calculations ?
0 votes
1 answer
61 views

What gives Excel/csvs their formatting functionalities?

When I open a csv file by double-clicking it, it opens, and as one would expect, displays the data in a big array of cells with a ribbon of formatting options at the top (Clipboard, Font, Alignment, ...
-1 votes
0 answers
20 views

ForFiles export file

I would like to run the following and hopefully be able to see the total size of all of the data being deleted. forfiles /p "C:\randomfilepath" /s /m *.* /D -180 /C "cmd /c echo @file @...
2 votes
2 answers
5k views

Why does LibreOffice Calc change CSV file Character Set?

I have a .csv file export (actually printed to csv file) made on a Windows 10 machine. Working in Libreoffice Calc on Archlinux, Why can Calc open a file using settings Character Set: Western Europe (...
-1 votes
3 answers
107 views

PowerShell: Export Ping Results to CSV

I have a PowerShell loop that does effectively what I want it to. The problem is that the output is very messy. I work for an ISP and one of the most effective ways we have to diagnose network issues ...
0 votes
3 answers
34 views

Excel removes delimiters from first field of "foreign" CSVs

Here's a CSV (UTF-8 BOM encoding), with some values delimited with quote marks: AAAAA,BBBBB,CCCCC,DDDDD "a2",b2,c2,d2 a3,"b3",c3,d3 a4,b4,"c4","d4" a5,"...
3 votes
2 answers
10k views

Formatting date in excel for csv upload

I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy. Is there a way to ...
0 votes
1 answer
3k views

How to automatically update Google Calendar from shared csv file

I am creating a regular snapshot csv file from a proprietary calendar program. The CSV file is formatted so that it can be imported into Google Calendar. I'm wondering if there is a way to put this ...
1 vote
2 answers
2k views

How to add double quotes around data in tables using Calc

I am trying to load my data into a CRM, but am having a lot of trouble. The data simply wont load at the same time, but all the files work fine individually. Support advised that I make sure I'm using ...
0 votes
1 answer
30 views

How to I extract the autocomplete email addresses stored in Outlook for general use?

Many people at my org don't use Outlook's contacts features, so they have none to export. Instead they rely on the autocomplete list. I'm not asking about how to transfer this list as-is, e.g. when ...
0 votes
1 answer
36k views

How to enable the 'Save and Open' option in Internet Explorer

I've recently upgraded to Internet Explorer 11 and when I try to download/open a *.csv file I get the following options in IE. The Save and Open option is greyed out. Is there a setting I can change ...
12 votes
7 answers
64k views

Why is Excel removing leading zeros when displaying CSV data?

I have a CSV text file with the following content: "Col1","Col2" "01",A "2",B "10", C When I open it up with Excel, it displays as shown here: Note that Cell A2 attempts to display "01" as a number ...
1 vote
1 answer
4k views

Parse csv file and for each object set as a variable

What I'm trying to do is parse a csv file that has server names and ipaddresses and assign these to variables I then run commands using each set of variables. So if the cvs file, test.csv, looks like ...
0 votes
0 answers
20 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 ...
1 vote
2 answers
6k views

How to I export filenames, filepath and properties of a directory tree to CSV?

I have a hard drive full of backups that I need to detail on a spreadsheet quickly and in the following specific way. I'm hoping there's an easy way to do what i need via some sort of .bat or .cmd ...
2 votes
2 answers
4k views

Import-CSV with powershell using a variable path

I am trying to import a CSV file with powershell in a database, with the path defined in a variable. But it doesn't seem to work. $path = "C:\Users\Admin\Desktop\TestFolder\file.txt" Import-CSV -...
0 votes
3 answers
92 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 ...
0 votes
1 answer
4k 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. ...
0 votes
1 answer
59 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. ...
0 votes
0 answers
85 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 ...
0 votes
2 answers
4k views

How to configure internet explorer to block download prompt for csv files

How to configure internet explorer to avoid save or cancel prompt while downloading .csv file and download the csv file.
0 votes
1 answer
92 views

Excel and CSV is converting my telephone number to not have +

I have tried several tricks and none of them are working I have telephone numbers +4 55 555 555 555 and in Excel the cells that have the little green triangle warning sign, they loose the +4 and then ...
3 votes
2 answers
3k views

Anki - Import one CSV, create mulitple decks and import into them

I have a big CSV file with Latin vocabulary with a unit number Like this: latin word;german word;Unit 01 ... latin word;german word;Unit 02 ... How can I create multiple decks import the ...
0 votes
3 answers
7k views

Need a batch script to copy data from A.csv to B.xls

I'm a newbie to batch scripting and need help. I want to copy the contents of a csv file A.csv to the first worksheet named "GenData" in a existing XLS file B.xls. B.xls contains some macros in it's ...
0 votes
2 answers
623 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-...
4 votes
9 answers
172k views

Excel saves a file in .csv but it keeps the columns and the rows as they were in the original sheet

I have a problem converting an Excel sheet in a *.csv file. I've searched all day for solutions, but nothing seems to work. After I select the sheet and save it as "CSV(Comma delimited)", pressing OK ...
0 votes
2 answers
5k views

replace space and empty cells in csv file

I have a csv file that has 7 columns. It has empty cells and some spaces between cells. How can I replace the empty cells with NA and remove extra spaces? Thank you very much! Here is what my file ...
0 votes
1 answer
4k views

BASH converting txt to csv

BASH/scripting newbie here. sed 's/ \+/,/g' output3.txt > output.csv This one gave me so many delimited. I only one to delimit the "pipe" | symbol and leave the rest as it is. So ...
-1 votes
1 answer
43 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 ...
4 votes
2 answers
905 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, ...
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 ...
0 votes
3 answers
2k 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
2 answers
2k views

Filezilla not transferring files completely

We use Filezilla FTP client for transferring very high volume CSV files to our client sites. For example: 883MB file. The CSV on our end shows 883MB. The CSV at the receiving end after transfer ...
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&...
0 votes
1 answer
4k views

Deleting rows in Excel using powershell

I have a csv file which has a series of pin-codes in column A but the first row/cell (A1) is empty and I need to delete the whole row using Powershell, any ideas? I have tried this but it did nothing!...
0 votes
1 answer
5k views

How to export a registry key to a CSV?

I'm currently looking to find out all SolidWorks license information on the network. I need help writing a script for PowerShell to look at a list of hosts that are on a CSV/TXT file then execute the ...
2 votes
1 answer
18k views

Default character encoding for Excel Text Wizard?

A large part of my job is to run an SQL query, save the results as a UFT-8 encoded csv file then import it into Excel for further manipulation and distribution. When I import the csv file into Excel ...
0 votes
1 answer
93 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 ...
0 votes
1 answer
243 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 ...
2 votes
3 answers
2k views

How to set field seperator in Emacs csv-mode?

Can I set the field seperator(s) for the current buffer in Emacs 23?
124 votes
20 answers
548k views

How do you force excel to quote all columns of a CSV file?

Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?
20 votes
2 answers
98k views

What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited)

What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited) file types in excel 2010? They are all listed as a save file type, but ultimately are Comma Separated Value files.
1 vote
1 answer
859 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 ...
0 votes
1 answer
523 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....
4 votes
4 answers
6k views

Excel and tab delimited files, using Carriage Return and Line Feed

How do you introduce a CR and LF into a cell so when it is saved as a Tab delimited text file, the importing program will recognize the CR and LF?
18 votes
1 answer
41k views

Excel save behaviour of CSV file with UTF8 encoding vs UTF8-Bom encoding

My original csv files are encoded with UTF8-BOM, this is so Excel can recognise the Unicode charcters (If its just encoded with UTF8 then Excel does not recognise the unicode characters). My issue ...
0 votes
1 answer
136 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 ...
2 votes
2 answers
2k 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
0 answers
154 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 ...

1
2 3 4 5
20