Comma-separated values: a rudimentary plain-text spreadsheet.

learn more… | top users | synonyms

1
vote
0answers
72 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
344 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 ...
0
votes
2answers
854 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
60 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 ...
1
vote
0answers
62 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 ...
0
votes
0answers
55 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 ...
0
votes
1answer
455 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
117 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
162 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
277 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
161 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
24 views

Need help on zipping .csv files in SSIS

I have .csv files from some system, loading periodically into a .csv folder. I need to build the SSIS process, which will be checking all day/hour the files and compressing them into .zip files. ...
0
votes
0answers
56 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 ...
2
votes
1answer
2k 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
97 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
184 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 ...
2
votes
0answers
164 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
152 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
100 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
431 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
77 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
288 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
0answers
54 views

Merge CSV files with Excel

Every day, I run a report that generates a .csv file of items that need to be purchased for the company that I work for. The fields look something like this: ...
0
votes
0answers
36 views

How to bulk import Contacts to Google with thmbnails/avatars

I am importing multiple contacts (say 200 odd) into a Google account from a csv file. And this works perfectly with respect to email ids, phone numbers and addresses. My question is, is there a way to ...
0
votes
2answers
155 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
1answer
79 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
210 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
67 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 ...
1
vote
1answer
1k 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
36 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
433 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
119 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
65 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
79 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
741 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
29 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
98 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
345 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
21 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
19 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
363 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
86 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. ...
0
votes
1answer
101 views

Set CSV as default import into a spreadsheet

In Libreoffice I can import a CSV file into a spreadsheet by simply double-clicking on the text file. In Openoffice 4.0 I have to click once on the text file to select it, then in the file type ...
0
votes
2answers
102 views

How to parse Wikipedia lists' source to a .csv file?

I was answering this question when the need arose for a good presentable data set. I settled for using random things but my first thought was to use a Wikipedia list, such as this List of longest ...
4
votes
1answer
283 views

Space or tabs as separator in CSV

I usually put "sep=," or "sep=;" as first line on my csv files so i can easily open them with excel. But is there a way to use this with space and tab separated files?
0
votes
1answer
102 views

Drawing Tables with scripts or programs in lotus notes

I need to send our report on daily basis. is there any way I can automate it? It was about 10 csv file, all I need to do is to get the first line of all of them and make a table and send to a ...
0
votes
0answers
66 views

Saving excel as csv without messing the formula

I have an Excel workbook with 55 sheets. I would like to save the sheets as csv files (file name is the name of the excel sheet). When I run the macro, the files are created as desired but the macro ...
3
votes
1answer
320 views

How can I easily split a CSV into two Excel worksheets with PowerShell?

I recently found out that PowerShell can be used to write Excel documents. The first use I thought of for this was to (at least partially) automate parsing of some CSV reports that I regularly have to ...
2
votes
0answers
104 views

Importing .csv into Google Calendar

I have been trying to import a .csv file into Google calendar and made sure to format it correctly and the file is well under the 1 MB limit. The first time I tried to import, it was successful, ...
0
votes
1answer
51 views

Create images using a template and table of data

How to create many images from a template and table of data? E.g., many business cards from a CSV file containing names, positions, and contacts? I realize there're ways of doing it by writing a ...