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

learn more… | top users | synonyms

4
votes
1answer
776 views

Custom CSV (.csv) filter for OpenOffice.org or LibreOffice?

Is it possible to create a some kind of 'custom CSV filter' for OpenOffice.org or LibreOffice spreadsheet program. What I need is to have the program to use predefined CSV settings for loading and ...
3
votes
1answer
956 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 * ...
3
votes
1answer
337 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
1answer
69 views

What is the “sep=” metadata you can adds to CSVs?

While trying to find out how to get CSVs to open correctly in Excel on a Spanish PC (belonging to a customer) I found many answers recommending using sep=, at the top of the file: Easiest way to ...
2
votes
1answer
182 views

Print from CSV file, row by row

I have a CSV file. I need to print this file row by row. For example, each row contains name, surname, email, profession and so on, many columns. First row contains the column titles. I would like to ...
2
votes
1answer
289 views

read excel sheet into jagged array

I am a programmer but recently new to both powershell and vba. I found this simple but effective command in powershell to read in a csv file and you can then immediately access "columns" by their ...
1
vote
1answer
16 views

excel grid to columns

I have data in an array/grid like this: Name | Group | A1 | A2 | A3 name1 | Group1 | 14.95 | 19.95 | 0.00 name2 | Group2 | 4.95 | 9.95 | 12.95 name3 | Group2 | 49.95 | 0.00 | 0.00 And I need a way ...
1
vote
1answer
47 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 ...
1
vote
1answer
573 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" ...
1
vote
1answer
476 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 ...
1
vote
1answer
23 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
1answer
953 views

Merge CSV files to one Excel file in different sheets

I want to merge CSV files to one Excel workbook in different sheets. I want each file in one sheet with the CSV file name as sheet name.
1
vote
1answer
282 views

Macro to import CSV file into Excel 2010 without losing leading zeroes or cell formatting

We have a UI based application that exports data out of a form into a CSV file. The data entered may have leading zeroes in some numeric fields and/or text with line feeds in other fields. ...
2
votes
0answers
188 views

IE9 not prompting to save downloaded CSV file, opens in Excel

I am accessing a website that generates CSV files when I click a "download" link. Instead of prompting to "save or open", IE 9 is going right ahead and trying to open the returned file in Excel. Since ...
2
votes
0answers
186 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: $ ...
2
votes
0answers
109 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, ...
2
votes
0answers
477 views

I'm exporting contacts from Outlook 2007 to CSV file and getting question marks instead of characters

I need to create a CSV file that includes my Outlook 2007 contacts. The contacts include English and Hebrew (UTF-8) characters as well. When I export the contacts into a CSV file (Windows - with ...
2
votes
0answers
168 views

How to setup a CSV web datasource

In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...
1
vote
0answers
46 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 ...
1
vote
0answers
81 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?
1
vote
0answers
78 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
102 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
191 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 ...
1
vote
0answers
91 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 ...
1
vote
0answers
21 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
0answers
281 views

Converting a DWG/DXF to CSV or Excel

I'm using ZWcad and i need to get the coordinates of hundreds of blocks into a excel sheet or .CSV file so i can import that into the GPS hardware. I know there are plenty of tools for autocad, i ...
1
vote
0answers
129 views

What is the best way for inexperienced users to browse and filter data in large CSVs?

I'm looking for a way to browse through some CSV unicode-encoded files. These files have relatively large number of rows (2-3 millions) and 10 columns tops, with columns being numerical, small text ...
1
vote
0answers
38 views

How to make just one text column be unquoted in final CSV?

I'm using OO calc and i have one column with phone numbers that have leading 0s, which are vital for the number to be valid. I can format the cell as text but i do not want the numbers to be quoted ...
1
vote
0answers
463 views

Import a CSV File in a database w/ powershell jobs

I am trying to import a CSV file into a database with PowerShell but so far I have no luck. This is my code (based on this source): Start-job -Name 'ImportingData' ` -InitializationScript ...
1
vote
0answers
202 views

When I try to export Outlook 2010 tasks, Outlook crashes

When I try to export tasks from the Tasks folder of Outlook 2010 to either a tab-delimited or a comma-separated file, Outlook starts to export and then crashes with the options of trying to find a ...
1
vote
0answers
86 views

Creating a script to make a CSV dump usable

So, let's say I have a raw CSV dump. And I want to make a spreadsheet/script to take said CSV dump, take a certain username, and the calls they made, and pipe those calls to a mathematical formula, to ...
1
vote
0answers
186 views

Use one csv file to delete duplicates in another one

Basically the title says it all. I have a csv list that includes one e-mail address per line (and some other stuff). I want to seek those email addresses in a different csv file (also with 1 mail ...
0
votes
0answers
8 views

How to customize default CSV format in LibreOffice?

Every time I export my data to CSV (and I do it often) I have tick the "Edit filter settings" checkbox, choose UTF-8 for the encoding, and semicolon for the fields separator manually. I do this ...
0
votes
0answers
8 views

Images in CSV file don't show up in Anki

I'm trying to import a CSV set of notes that include image references into Anki. I have a file with Cloze substitutions and in one note I am using an image in the text: <img src=”duck.jpg”> ...
0
votes
0answers
36 views

How to make my loop omit empty Excel cells while converting to .csv - Powershell

I have some empty cells in my Excel worksheets.How to make a proper statement to make my loop omit them? I tried to do a if(){}else{} loop but it doesnt work properly.I have a powershell v2 so I ...
0
votes
0answers
13 views

How do I change the EOL character when importing a CSV file into Open Office Calc?

I've got a CSV file that has enclosed newline (\n and \r, mixed) characters in its data. Because the consumer of that file is not able to handle that correctly (out of my control) we decided to use ...
0
votes
0answers
43 views

Batch Script related issue

I have written following script which works absolutely fine on my system. @echo off setlocal enabledelayedexpansion FOR /F %%i IN ('wmic /node:%1 computersystem get Name') DO SET A=%%i FOR /F %%i ...
0
votes
0answers
61 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
0answers
28 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
64 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 ...
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
40 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
0answers
74 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 ...
0
votes
0answers
68 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 ...
0
votes
0answers
831 views

Cannot import CSV file to WEKA

I got a very large data set from a access log.I converted it to CSV file using 'Vim'.I want to use "WEKA"(Data mining tool) to analyse this data set.But when i try to open this CSV file it gives me an ...
0
votes
0answers
76 views

Excel 2013 CSV converting to Dates

I have searched high and low for this answer. Everything I have read says to format the field to 'text' and that simply does not work. Ok, when saving my excel sheet in .csv, it decides to convert my ...
0
votes
0answers
256 views

Excel csv encoding default

Ok here's the deal I exported a csv in UTF-16 format via PHP and open it in excel...All the encoding works perfectly. My question is, suppose I edit this csv and then just hit save in excel and ...
0
votes
0answers
268 views

replace comma with colon in csv file

In CSV file all other delimiters are comma except for 1 colon. While saving this CSV, excel replaces this colon to comma. How can I overcome this? or Later how can I replace those particular comma ...
0
votes
0answers
97 views

Getting Access 2000 to output CSV with quote “only where needed”

Does anyone know how to get Access 2000 to output a comma-delimited file in this format: Good> Cat, "John, Doe", 32, $3.44, "Denver, CO", 1234 NOT like this: Bad> "Cat", "John, Doe", "32", ...
-1
votes
0answers
28 views

delete all values in a .csv file besides the name “EC_Customers” and “EC_Leads”

I have a .csv file that has a column for contact tags. In this column, I have a whole bunch of separated tags. I want to delete all of the tags besides "EC_Customers" and "EC_Leads" How do I go ...