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

learn more… | top users | synonyms (1)

-1
votes
1answer
109 views

Extract chart data from Word document to CSV files automatically

I have lots of charts in a Word document in docx format. If I click on Edit data, I get an Excel window which displays the data. From there, it's easy to export it to CSV. How is it possible to ...
1
vote
0answers
14 views

How can I tell the creation date and creator of a file inserted into a MS Word document? [duplicate]

If I have a Word document and a CSV file was inserted inside the Word document, how can I tell the creation date of the CSV file and the person who created it when I open the CSV file up from within ...
0
votes
2answers
199 views

How to open CSV file with Russian Excel?

Comma is used as decimal separator in Russian locale. This is probably the reason, why Russian Excel is unable to open CSV files: As you see, all data went to first column.
1
vote
1answer
312 views

batch converting from XLS to windows CSV on a mac

I'm using OS X and have lots of these XLS files that I need to format as a batch operation. I need them in "Windows CSV" format, but I can only seem to get them batch converted to Mac CSV... I am ...
0
votes
2answers
68 views

Change number in last row in data seperated with commas in NotePad++

I have rows of data all separated with commas. How can I replace the last numbers after the last commas with the number 5 in NotePad++? For example: How do I replace 9, 17 and 124 with 5 in the below ...
0
votes
1answer
876 views

How to get plain text, colon separated file into spreadsheet with data separated into columns

I received a digest of registrations for events. The fields are separated by colons and in plain text. Can I copy and paste this info into libreoffice spead and get it displayed in columns?
0
votes
3answers
2k views

Splitting a 7 million row CSV by a specific column

How would I go about splitting a very large (7 million rows) CSV file into several different sheets/files by a specific numerical column. It should split into about 10 different files.
1
vote
2answers
2k views

Data Validation of a Comma Delimited List

I need a simple way of taking a comma seperated list in a cell, and providing a drop down box to select one of them. For Example, the cell could contain: 24, 32, 40, 48, 56, 64 And in a further ...
0
votes
2answers
1k views

How to save messages from Gmail to csv file?

I want to know how to save messages from Gmail to one csv file or each message to separate csv file. Txt file is also acceptable. The messages I need have a certain label in Gmail. An example: I ...
0
votes
1answer
55 views

Can I create a cell with enumerated values in a csv file

Can I create a cell with enumerated values in a csv file? For example, I want a cell that can only get the values: a) "value1" b) "value2" c) "value3" Is this possible? PS: I have used this ...
0
votes
2answers
865 views

Delete empty column from csv file with bash script

Looking for some way to look at a csv file and delete columns including the header that have no values in the subsequent lines that follow. Perhaps if I wanted to delete column Test03 from below ...
0
votes
1answer
781 views

Batch file to search for and delete lines containing specifc text in a csv

I have a bat file that searches a directory for specific .csv files names, and copies and amends the lines into a new .csv file. However, some of the lines of the original .csv files are not ...
0
votes
2answers
388 views

CSV File Import Error - Question Marks / Brackets Everywhere

I have a few .csv files that were sent to me, but when I try to import them either as .txt files or as .xml files I only get blocks of question marks (?) and brackets (CONTENTS) of the type that would ...
-2
votes
1answer
328 views

How to convert many .csv files into 1 .xlsx file with multiple tabs [closed]

I have multiple .csv files that need to be in a single .xlsx file, each on it's own tab. I know how to do it manually. is there an automated way do do this? I'm going to need to do this on a monthly ...
1
vote
1answer
59 views

Convert tab separated to a human readable aligned column headers

Let's say I have a spreadsheet with the following example data: I need to display this in plain text but still human readable. When saved in a tab separated format (tsv) it will output something ...
0
votes
1answer
94 views

Control CSV import in excel 2010 [duplicate]

I have a csv with values like this: "a very long value, with a comma","387621937291732193" The number, despite being enclosed in quotes gets turned into a number in excel and shows up in scientific ...
0
votes
1answer
252 views

Importing an excel sheet with many empty cells into R

I have a big excel sheet that have lots of empty cells. I'd like to import it in R. I'm fine if in R, all the empty cells are replaced by "NoData". Replacing all empty cells by "NoData" on Excel and ...
1
vote
1answer
135 views

phpmyadmin CSV files import and export

When I try to import CSV files in phpmyadmin, I get message in green that says "0 rows" but it is nevertheless a success message. I know my data is correct, as it importing fine on another computer. ...
1
vote
4answers
4k views

How to read values in a particular column of a CSV file in Batch?

I am planning to write a batch script wherein I need to scan the values from a particular column of a CSV file one by one and store them in a variable for further processing. Say, following is the ...
0
votes
2answers
217 views

Creating Comma Separated Values in Batch Scripting

I have written a piece of code in Batch script which is somewhat like : ( wmic.exe /node:x.x.x.x computersystem get name wmic.exe /node:x.x.x.x computersystem get domain wmic.exe ...
1
vote
1answer
3k views

Excel How to make Text Qualifier editable or add a new entry in the existing list?

I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote. Example: "col1","col2","col3" ...
2
votes
1answer
3k views

How to import csv file from url into Google Docs (Drive)

I have a CSV file on a server, available via http. I want to import this into Google Docs to analyse it. Is there a way to do it directly? Trying to do it via iPad, no PC. Trying to avoid the ...
0
votes
2answers
661 views

Can MS Excel use non-printable characters as field separators in CSV files? If so, how?

I've just discovered that many of the character encodings have non-printable characters designed to separate different pieces of information, e.g., ASCII character 31 is the "unit separator". It ...
5
votes
2answers
4k views

Unix command to get number of lines in a CSV file

I have to get the count of lines from incoming CSV files. I have used the following command to get the count. wc -l filename.csv Consider files coming with 1 record I am getting some files with * ...
1
vote
1answer
1k views

Run Command to open csv file in excel

My first question on the site, so hopefully I'm doing this right. I use file juggler on my windows machine. The program can watch for new files and trigger run commands. When a new csv file arrives ...
2
votes
5answers
71 views

Edit file with Excel without reformatting

I use a program which only imports csv files, but the first 5 columns must be empty, without any data in it. When I'm editing the file to add or change some data, and save csv file, the mandatory ...
1
vote
0answers
169 views

Why is libre office calc inserting a ' at the beginning of the cell?

This is the most ridiculous thing i've encountered.. I've imported a csv, I end up with nice neat clean rows of numbers, no formatting, nothing weird, no " or ' left over, just numbers. When I go to ...
2
votes
1answer
289 views

Excel inconsistent date conversion

I'm running Excel 2007. I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: ...
-1
votes
1answer
333 views

How to extract MD5 data from a CSV file

I have been sent a csv file that contains a list of emails that i'm told has MD5 encryption on it. I want to be able to extract the email addresses from the file. If i double-click it opens in Excel ...
0
votes
2answers
2k views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
2
votes
1answer
734 views

Reversing Excel's Text Import Wizard for CSV Export

I have a CSV file that I want to import to excel, edit, and save back as CSV. The problem that I encounter is with Text Import Wizard: I open a new Excel file, then Data > From Text, and in The text ...
1
vote
0answers
168 views

How to restore Eclipse shortcut keys from exported .CSV?

You can simply export your shortcuts settings in Eclipse going to Window > Preferences > General > Keys > button Export CSV... But how to restore shortcuts from this csv?
0
votes
1answer
1k views

Deleting entire row in excel if missing data in certain column or columns?

I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...
3
votes
2answers
4k views

LibreOffice is saving CSV files with tabs as separators

I just opened a CSV file in LibreOffice, made a small change and hit save, saying "yes, keep using CSV". The file is now filled with tabs instead of commas. My scripts (using Python's CSV lib) won't ...
0
votes
1answer
118 views

Display-only Column Formatting in Vim for Character-Separated Value Files

I would like to be able to nondestructively align columns when I am editing csv files in vim. I know of various ways to tabularize/align columned data in vim, but they all modify the file itself ...
3
votes
0answers
176 views

Default font and cell padding when opening files in LibreOffice/OpenOffice Calc

I've seen solutions for setting a default font when creating new files. What about a default font (and cellpadding) when opening an existing CSV file? LibreOffice seems to always default to Liberation ...
1
vote
0answers
125 views

Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc

Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...
3
votes
1answer
2k views

Disable prompts in Microsoft Excel when saving a CSV file [duplicate]

I have to download multiple csv reports from the Internet throughout the day, make a tiny change to them, and save the change. Excel adds 3 completely unnecessary dialogs to what should really be a ...
-1
votes
1answer
196 views

Invalid date value in csv file

I export data in csv format from sql server database. It contain 5 column. one column have date and time value. When i checked the date -time value i found date time value is in wrong format. I add ...
2
votes
3answers
1k views

How to help Excel parse my CSV automatically

I'm generating CSV files from a script and then want to look at them with Excel. I noticed Excel does a smart job of identifying money (by the $) and dates, and formats those cells accordingly. ...
0
votes
1answer
766 views

Macro to Import CSV files into Excel

I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the 'Import from Text' tool by typing the name of the file into a cell. I then need to format all of the data ...
2
votes
1answer
588 views

grep the string lines from the file

csv file. 1,2,3,abc 2,3,4,def 3,4,5,abc 3,4,2,def 6,7,9,abc. I need to read that file and get the lines of file containing abc.
0
votes
0answers
154 views

OpenOffice Calc with csv file produces Err:520

I'm loading a csv file into OpenOffice Calc (version 4.0.1) and in only 1 column I get 'Err:520' as the cell value. I checked under Tools->Options->OpenOffice Calc->View->Display to check whether ...
7
votes
1answer
9k views

Can I create an Anki deck from a .CSV file?

Can I convert my CSV file into an Anki deck? I can't find any options in the program.
1
vote
0answers
128 views

I want to be able to have a daily task run showing the times users log on and off

GOAL: I want to be able to have a daily task run showing the times users log on and off ENVIRONMENT: Windows 2008R2 domain ACTIONS SO FAR: I have enabled Account Auditing via: start -> ...
1
vote
0answers
400 views

Get rid of warning for external data connection

In Excel 2011 for Mac, I'm using an external data link to collect data from a CSV file generated by a third party application. The CSV is continuously filled, so I want to update the data every time I ...
3
votes
1answer
324 views

Open only the first 10 lines of large CSV file in LibreOffice Calc

I will start receiving many large CSV files, of which only the first few lines are of interest to me. I was hoping to open them by piping only the first few lines to Calc, but this doesn't work: $ ...
0
votes
1answer
914 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.
1
vote
1answer
1k views

How to convert two columns into one column of CSV?

This is how my columns currently look. There are two columns, each having a name. I want something as shown below in the expected section, for better processing of a parsing task. Current Col A ...
1
vote
4answers
1k views

How to split CSV files as per number of rows specified?

I've CSV file (around 10,000 rows ; each row having 300 columns) stored on LINUX server. I want to break this CSV file into 500 CSV files of 20 records each. (Each having same CSV header as present in ...