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

learn more… | top users | synonyms (1)

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
2k 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
578 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
3k 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 * ...
0
votes
1answer
894 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
68 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
152 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
237 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
288 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
1k views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
2
votes
1answer
685 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
148 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
3k 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
112 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
158 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
119 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 ...
2
votes
1answer
1k 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
176 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
921 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
673 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
525 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
137 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 ...
6
votes
1answer
8k 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
119 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
334 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
291 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
722 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
747 views

How to convert two columns into one column of CSV?

This is how my columns currently look now. They are two columns, with each column having a name. I want something this, as shown below in the expected section, for better processing of a parsing task. ...
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 ...
0
votes
3answers
128 views

Cannot create CON.csv or PRN.csv in Win7 [duplicate]

On Win 7 Enterprise 64bit V6.1.7601 SP1 Build 7601, I cannot create *.csv files with specific names, i.e. CON.csv or PRN.csv. This is the error I get when I try to rename: Also, if I try to rename ...
1
vote
2answers
588 views

Notepad++ Regex Help in cleaning up file

I've got a csv file (the column separator is "<;>" ,the text delimiter is the double quote and the row separator "crlf") of more than 18000 lines. However,many of the data contained within the ...
0
votes
2answers
444 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 ...
1
vote
1answer
157 views

How to set field seperator in Emacs csv-mode?

Can I set the field seperator(s) for the current buffer in Emacs 23?
0
votes
1answer
425 views

What software to use to manage/transform a 10Gb csv file (100+ million lines) [closed]

So I have this uge csv file with more than 100 million records and I want to work on. I don't want to just edit it. What I need is to use some kind of excel / basic database transformations (group ...
0
votes
0answers
97 views

Is there a text file format that Excel supports opening and saving directly?

I want to edit simple table data in Excel 2010, which is to be stored only in a flat text format (i.e. not a binary format like XLS or XSLX) which is viewable with notepad and can be read by a simple ...
3
votes
1answer
6k views

Semicolons when creating a CSV file instead of colons

When creating a CSV file from an XLSX workbook with the new Excel for Windows 8, I get a file filled with semicolons instead of colons. How can I change that? I even had to reopen the file with ...
0
votes
1answer
40 views

Adding the date/time (DD/MM/YY HH:MM) information dynamically at the end of ZIP file

I want to add the current date/time (DD/MM/YY HH:MM) information dynamically at the end of ZIP file when backing daily via IBM cognos export. Then How can I export CSV formatted them using script? ...
1
vote
1answer
821 views

Can I output results of a MySQL query to a csv file via Putty?

I've typed the following code to output the csv file , but it shows an error mysql> SELECT *INFO OUTFILE 'd:/student.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY ...
0
votes
1answer
158 views

Excel fails to open Python-generated CSV files

I have many Python scripts that output CSV files. It is occasionally convenient to open these files in Excel. After installing OS X Mavericks, Excel no longer opens these files properly: Excel doesn't ...
1
vote
1answer
100 views

How to extract a list of selected cells into a CSV file

I have a huge Excel sheet and I would like to get a small list of cell (around 200-300 cells from the same column, row) into a CSV string. Is there an Excel command to do that?. Saving the file into ...
1
vote
0answers
176 views

How to export Excel with Hindi script to CSV file?

I would like to know how to export an excel spreadsheet which contains, say a table of Hindi(for that matter any non-english) script words into a CSV file? I tried 'Save As' --> comma delimited, but ...
0
votes
3answers
1k views

Unix - Surround First Column of CSV with double quotes

I have data in the following format - 4,"abc" 8,"def" 9,"ghi" I want to surround the value of the first column by double quotes. "4","abc" "8","def" "9","ghi" How do I do that ?
0
votes
1answer
34 views

Unix - Convert Column to CSV

I have the following output from a command in Unix - "10" "30" "u" "hello" And I want it in the following CSV format without the trailing comma - "10","30","u","hello" I tried tr '\n' ',' ...
0
votes
1answer
139 views

How to transform a csv to combine matching rows?

I have a CSV file with some transaction data. Let's say date, volume, price and direction (sell/buy). Additionally there is a ID for each transaction and on each closing transaction (the newer one) ...
3
votes
3answers
396 views

What software can I use to edit CSV files?

What software can be used for editing CSV files? Notepad is gonna work smoothly? I have been using MS Excel but now I have this issue. When I put date like this: 090913 whcih represents 9th of Sept. ...
1
vote
1answer
27 views

How come using import SQL only works if the insert script is the only script in the SQL pane?

I am going to take a shot here and hope that some of you in superuser actually use SQLA (SQL Assistant). When you set File > Import Data so that you can execute insert into mydb.mytable (?,?,?,?); ...
1
vote
0answers
23 views

Spreadsheet to MySQL

I need to export spreadsheet data for import into a MySQL database. Data must be in quotes to import properly. The problem is with numbers. Is there a formula or other quick method other than copy and ...
1
vote
1answer
793 views

Excel export with specific csv settings?

I'm a newbie to excel and csv files. I have a excel file with the following structure … http://cl.ly/Rdkp user_login user_email user_pass first_name last_name display_name role Some Name ...
0
votes
0answers
90 views

CSV Files - Text Import Wizard - Comma not recognized as delimiter [duplicate]

I have an issue with opening a CSV File in Excel. Every time i open it, i have to run the text import wizard, specify comma as a delimiter and then only i am able to view the file in proper format. ...