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

learn more… | top users | synonyms (1)

0
votes
2answers
32 views

Reference cells in column of .csv from command line

I have a column B in my.csv in which each cell references the filename of a document in a directory source_directory/. I'd like to grab each of those names so I can use them as args for other shell ...
0
votes
0answers
57 views

Libre Office Calc Issue: Summarizing columns with too many rows

I'm writing a script that reads data taken from a database. THe data is modified (de-duplicated) and put into a .csv file I have a problem as I want to find the sum of a particular column in excel. ...
1
vote
1answer
1k views

How can you change Mac excel 2011 to separate using commas, not semicolons?

I have Excell 2011 on my Mac, and when I try to export a .xls file into .csv I end up having a semicolon separated file instead of .csv. p.s. The System preferences for my keyboard input is italian ...
0
votes
0answers
76 views

Capturing the MAC addresses of associated clients of a specific access point

I am trying to capture the MAC addresses of associated clients of specific access points as an experiment to see which type of device (by way of OUI lookup) most commonly connects to different access ...
0
votes
0answers
27 views

Spline drawing to CSV

I am trying to generate a csv file for a spline curve drawn on LibreCAD. I see that the drawing can be saved as dxf/dwg, but not as point data. I was wondering if anyone has managed to export into ...
0
votes
1answer
40 views

Split name column to csv file

How can I easily transform columns information to CSV line or file output? Input (From file or excel column): ABC1 ABC2 ABC3 ABC4 Output (To file or excel line): ABC21,ABC2,ABC3,ABC4 I don't ...
0
votes
1answer
43 views

Preserve existing tags in Anki CSV import/batch-add tags

I have downloaded the complete 2012 HSK vocabulary from here, where it is available as an excel file. I have then converted it to .CSV and changed it to this form: 爱;HSK:1 … 做主;HSK:6 The first ...
0
votes
1answer
21 views

Similar Excel Extensions as CSV

This query is related to Mainframes & Excel. If we have to transfer a file from mainframes to excel and it is .CSV, then automatically excel delimits the contents with comma. I need to know how to ...
0
votes
1answer
55 views

Why is Excel (sometimes) changing casing of a text in an imported file?

So this is a bizarre problem some users of ours are seeing, that I've been able to confirm, and that makes absolutely no sense to me. Basically, I work on an application that will export files in CSV ...
1
vote
1answer
33 views

Generate CSV from NS Zone File

I have a large file that contains records in multilines. ex: domain1 NS ns1 domain1 NS ns2 domain1 NS ns3 domain2 NS dnsx What might be the fastest way to generate a CSV of the form ...
2
votes
0answers
186 views

PowerShell Script to Rename - Copy - Move

I am trying to write a PowerShell script to do the following. step 1 Rename files in source (FTP folders) directories with it's "current_name_datetime.csv" as per a source file "Source_list.csv" ...
0
votes
1answer
82 views

Transform a CSV with Notepad++

Suppose I have a CSV file like this: 1,"abc",,,, 2,"def",,,"ghi", 3,,"jkl",,,"mno" Now I need to transform it in 3 steps: Replace all empty spaces with the String NULL Add at the beginning of ...
-8
votes
2answers
208 views

How to create a batch file to ftp files in the directory with the name realated to yesterday? [closed]

I have a set of directories with encoded in their names the date. Inside those directories there are files named files.csv. The directories have a standard name as, for example, ...
1
vote
1answer
553 views

How can I make Excel save a .csv using commas and quotes?

I am trying to save file as a .csv, however, Excel is not using the standard comma separator and quotes. Here is an example of what I want: "0","70","0","4/29/2012 ...
0
votes
0answers
39 views

Most reliable or widely used standard for CSV file formatting

I'm wondering what are the most common standards for CSV file, and is there any OFFICIAL one ? I just did several searches on google, SO and other sources, and the best I found is Wikipedia : No ...
3
votes
3answers
585 views

How to export a spreadsheet to a UTF-8 .csv from Excel 2016 on mac?

Hoping you can help me out with this one... For my work, I've been assisting a DBA for the last few weeks and we've now been given the task of uploading a very large spreadsheet which has several ...
0
votes
1answer
132 views

Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected. Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular ...
3
votes
2answers
102 views

Which delimiter allows major spreadsheet programs to open CSV files by double-clicking?

I'm writing an iOS 8 app that allows you to export data to be sent as an email attachment. Currently, I'm exporting the data to a CSV file with 7 columns and x number of rows. When I first created it, ...
1
vote
2answers
1k views

UTF-8 File is not showing Chinese characters in Excel

I am creating a CSV file with UTF-8 encoding. It displays the Chinese characters properly if I open it using Notepad++. It displays the Chinese characters properly if I open it using Notepad. But, ...
1
vote
1answer
67 views

How can I automatically segment a mp4 video based on a list of frames

I have a 7 hour long h.264 video made up of 1600 shorter videos and I have a csv file with a list of frames at which I need the longer video to be cut at. Is there any way that I can automatically ...
1
vote
1answer
183 views

How can I write only certain rows of an Excel worksheet to CSV?

I have created an Excel (2010) workbook that takes information from various CSV files and puts them into a format that can be understood by my office's scheduling program. Using a macro I found ...
0
votes
0answers
334 views

Losing decimal places when exporting to csv

I am exporting data from oracle table into a csv file. I have a column of varchar2 datatype and it has values like 1.1 and 1.10. When I export these to a csv file the value 1.10 becomes 1.1 and thus ...
2
votes
2answers
42 views

Delete everything in second column not in parentheses

I have a file that looks like this: gene ID protein Solyc06g062540 (Z) PYROPHOSPHATASE 3 (PTHR20889:SF0) Solyc10g075050 ALBUMIN SUPERFAMILY (PTHR33076:SF11) Solyc07g061760 ...
1
vote
1answer
55 views

Import Network Settings (wi-fi) from Windows to Mac; Bulk Import of Wifi Keychain Passwords

I have a CSV/TXT file with a list of network names and passwords (together with network/password/encryption types) that looks like this: ***Networkname1*** ESS WPAPSK TKIP passPhrase ...
6
votes
3answers
1k views

How to split a CSV file into multiple files based on a text string?

I have multiple text files (CSV) with a structure similar to this: funkiana,23.55,-99.866 funkiana,24.634,-98.701 funkiana,24.717,-98.901 geminiflora,22.25,-104.6166667 ...
0
votes
3answers
85 views

What is the delimiter for the CSV file below?

I'm having trouble importing the CSV file, below, into Excel 2007. I can't figure out what the delimiter is. ...
1
vote
2answers
291 views

Concatenate csv-files with the same name from subdirectories

I found some scripts concatenating text files from different subdirectories, but all of them produced output files like "output.txt", but didn't keep the original file name. Structure Folder_A ...
1
vote
1answer
23 views

How can I disable dates in the Calc?

I see that all spreadsheets are urgent to recognize your 13.12 as a date. Particularly, I am struggling with Calc, who is said to use English language to import dots as decimal separators. But, ...
1
vote
1answer
49 views

What has caused my csv load time to dramatically increase?

I have a monthly report formatted as a .csv file. It's file size is 90 MB. It used to take around 10 seconds to open. Now it takes 4-5 minutes. When I convert it to an .xlsb, it takes 10 seconds. ...
1
vote
1answer
1k views

Invalid field count in CSV input on line XX in phpmyadmin?

I have a 16MB CSV file with 50,000 lines that I want to import into my database. I go to the PHPMyAdmin-Interface, choose IMPORT and set the correct options. The import fails with the error Invalid ...
1
vote
0answers
293 views

feed XML to google calendar [closed]

I have an XML file with seminars that I would like to feed to google-calendar. The XML file is maintained by someone else and is updated regularly, so I would like to do this in a way that google ...
1
vote
1answer
395 views

CSV Input for Merged Columns in Microsoft Excel

I am using Excel 2010 (v14.0) on Windows 7. I would like to have a header, and subheader, where columns are merged in the header but separated in the subheader and data. I know how to merge columns ...
1
vote
3answers
363 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 ...
-1
votes
1answer
297 views

Visual Basic and Excel data streaming in real time [closed]

I'm currently working on a program that runs in visual basic (not VBA). The program collects data from sensors and produces a data file (*.csv) of the information it collected after a certain stretch ...
0
votes
1answer
485 views

Automatically format cells as currency from .CSV when importing into Excel

When I import a .CSV file into Excel, how do I get all cells which contain a number to be formatted as currency? Currently, if the value for the cell contains the dollar sign ($), it becomes formatted ...
0
votes
1answer
40 views

Is there a way to update automatically a worksheet based on a link which provided a file for download

I have created a web app which allows the user to download a csv file just by copying the link into a browser. Afterwards the user can open this file with excel. Because the csv file might change ...
0
votes
2answers
3k views

Removing Line Breaks From CSV for Proper Excel Import

So I've created a batch script that outputs some text to a CSV. When I open the CSV in Notepad, it looks like this, which is how I want it. 173030,8,2793,2821244 173032,1,2793,2820692 ...
1
vote
2answers
931 views

How to prevent Excel to round a number at opening? [duplicate]

I have a question regarding Excel. We generate automatically a CSV file everyday, containing stuff looking like : column1;column2;...;columnx text;date;text;249316479917397279 The issue is that the ...
0
votes
2answers
51 views

How does libreoffice express a linebreak when saving a csv?

I’m attempting to save a CSV using LibreOffice Calc to be imported to a MySQL database. Saving it as a CSV is pretty straightforward in LibreOffice but I don’t know how the resulting document ...
0
votes
1answer
236 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
1answer
69 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 ...
2
votes
0answers
1k views

How do I suppress the “file format and extension of MyFile.csv” do not match."?

I'm opening a lot of csv files using Excel recently and am repeatedly receiving the warning:- The file format and extension of MyFile.csv do not match. The file could be corrupted or unsafe. ...
0
votes
2answers
37 views

need help in editing data in csv file

I am in need of editing the date data in csv. I will explain with an example. I am using WPS presentation software for reading and editing csv files. If the above is not possible in that, i can ...
1
vote
0answers
232 views

MySQL csv excel greek characters

I developed an application using Bottle web framework and Python, to import some data into MySQL database. Most of the data where in Greek characters. On my application side, i didn't any further ...
1
vote
1answer
431 views

WMIC |more has extra rows when .csv opened in Excel

I am trying to output the name and version of each program installed on my system to a .csv file. I could do something more complicated with VBScript, but would prefer to keep this very simple to ...
2
votes
1answer
63 views

LibreOffice Calc/Spreadsheet – Delete unusual characters from cells so that I can export a valid CSV file

I received a spreadsheet for work and it has cells that are full of line breaks and excessive whitespace. Unfortunately, I need to export the spreadsheet to CSV format and these two are breaking the ...
0
votes
0answers
91 views

Anki fails to import from .csv file

I have created an custom note type containing 3 fields: Character, Pinyin and Definition. I have a .csv file containing a few entries. The fields are comma-delimited. Here's what I am presented when ...
1
vote
0answers
12 views

Undoing excel default / automatic delimiting [duplicate]

I have a large data export that is going through the end user for spot-checking. The data was formatted with tab delimiter, as it contains a lot of prices and measurements containing commas. The ...
0
votes
1answer
51 views

Have a very large fixed width .txt file, have column widths for the records to guide me, and need .CSV out of it [closed]

The text file is a tax roll off the tax assessor website, and it is 2.63 GB. Every program that I have tried, including UltraEdit, Convert XLS, didn't find anything helpful in excel because we're ...
1
vote
0answers
130 views

Properly extracting from an array

I have a CSV with one column, numbers formatted as 111-0000, that I'm reading in to process one at a time. I'm trying to import the column of information from the CSV, but I'm having trouble figuring ...