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
308 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. ...
1
vote
1answer
1k views

Excel puts a comma-separated set of values in one column

I have a file which is clearly comma separated but when I open it in Excel 2007 it puts all the data in a single column. I think the problem is with my Windows localization (set to Dutch) but I am not ...
6
votes
2answers
27k views

How to get Excel to interpret the comma as a default delimiter in CSV files?

I have a number of .csv files. Some of them are comma delimited, some are tab delimited (maybe they should be called .tsv ...) The csv extension gets associated with Excel when Excel is installed. ...
3
votes
3answers
277 views

regex help - ignore a char if it's in quotes

We have a web-based app at work where you can enter a regex into a search box and it returns the matches from a database Here's a sample of what the database entries might look like. They're comma ...
1
vote
1answer
155 views

Generate CSV/TXT file from named zone file

I am in need of generating a csv/txt file from a zone file on a named DNS server. For examples I would like to generate a list of the hostname and IP from the zone file From this monkey A ...
0
votes
1answer
759 views

Having formatting problems when exporting table from phpMyAdmin

I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format. ...
2
votes
1answer
136 views

Any way to have Excel 2010 treat a quoted value “08540” as text not number when opening a CSV

I have a CSV with data like this: "08540",1,"PRINCETON","NJ" I know that it is possible to specify "Text" when using the Import Wizard and defining columns. But is there a way to tell Excel to ...
0
votes
1answer
119 views

Unintelligible result opening csv in excel

When I open a .csv file in excel this is what is showing up: Maxtor Encryption ver 2.0.1.1.0 ³§o rkDV’)cÿA®T7B‡LôŠì£\% i¼r1 ØÕë—„×½é¿wjd ´Íâ¿…Öö?HÐ)vM!W«Va<žÒ LåRpµI©ô ...
0
votes
1answer
397 views

Using Command Prompt to create Retina Vulnerability Report CSV

I have scanned several computers on my network which have been flagged as needing certain fixes. I am able to generate reports in Retina fine using the GUI report view, however, I would like to be ...
1
vote
1answer
116 views

Database workflow advice? [closed]

I've got a product database that I need to update a couple of times a week and am looking for some advice on what workflow I should setup. I can export my database from my online store as a CSV, I ...
2
votes
2answers
169 views

Split view of a CSV in Bash

I'm trying to view large CSV files in a terminal (not huge; simply more than can be displayed in the terminal window at once). The best solution I've currently got is this: column -s, -t -n < ...
1
vote
3answers
107 views

Generate an alphabetic index from a spreadsheet

I have a text file of lecture topics from my physics class that looks like this: 1/14,Galilean relativity,Einsteinian relativity,Minkowski space,Henri Poincare,, 1/16,Lorentz transformations,Velocity ...
2
votes
1answer
9k views

How can I convert a .txt file to .csv format without using Excel?

I have a .txt file consisting of very long paragraphs, with a single newline character separating each paragraph. I would like to convert this to a .csv format so that the file effectively has one ...
-3
votes
1answer
327 views

Deleting the first column of csv via batch commands [duplicate]

Is there a way to delete the first column of a csv using a batch command file? I have data in this first column but I want to get rid of it and output a new file starting at the 2nd column. Thanks!
1
vote
0answers
538 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 ...
0
votes
2answers
2k views

How a batch file overwrite contents of output each time?

Basically I have this batch file below, which will return the first x rows from the input .csv file parameter. However, the only issue now is that this batch file will be called several times to ...
2
votes
3answers
4k views

Excel CSV import treating quoted strings of numbers as numeric values, not strings

I've got a web application that is exporting its data to a CSV file. Here's one example row of the CSV file in question: 28,"65154",02/21/2013 00:00,"false","0316295","8316012,8315844","MALE" ...
1
vote
1answer
676 views

Adding Multiple users from .CSV via batch file

I wrote the following in a batch file start cmd.exe /k net user test1 1qaz2wsx!QAZ@WSX /add /y But I have to add a large number of users and passwords. I have them all in an excel file, is there ...
1
vote
4answers
4k views

Can I use a batch file to remove blank columns in a .csv

I have nine columns in my current .csv file, however, the 2nd and 3rd columns are blank and I want to get rid of them. Is there a way to use batch commands to remove these empty columns from my .csv ...
2
votes
2answers
561 views

Import-CSV with powershell using a variable path

I am trying to import a CSV file with powershell in a database, with the path defined in a variable. But it doesn't seem to work. $path = "C:\Users\Admin\Desktop\TestFolder\file.txt" Import-CSV ...
0
votes
1answer
641 views

Export the first three rows of a .csv into another .csv using batch commands

I have a .csv file with a number of rows but I only want the first three rows and none of the rest. How can I use a batch file to export those top 3 rows of my .csv file into another file .csv file? I ...
0
votes
1answer
227 views

Get unique comma separated values from list of comma seperated values

I have a list of csv in a single cell, and I need to get the unique values from that list and put them in another cell. For example, in one cell I would have: DIV-154, FOD-371, UDL-913, DIV-154 And ...
2
votes
1answer
506 views

How to display/monitor the tail of a growing CSV file in tabular format?

I am looking for a way to display an open, "live" CSV file under Windows 7. For example, I have a proprietary program running that is generating log data in CSV format. I'd like to keep an eye on what ...
3
votes
2answers
8k views

Import CSV file into Exchange Mail Contacts using powershell without duplicates

The Problem: A good number of people's info was added to my "Mail Contact" list in Exchange Management Console, but not all. Summary: I'm attempting to add a list of several hundred people from a ...
2
votes
6answers
6k views

Editing CSV files in Ubuntu

What is a good way to edit CSV files in Ubuntu? The files look something like this: This,is,data,with,a,header 2,2,3,4,, 1,,3,,6,6 ,5,3,5,5,6 1,2,,,, 1,2,3,4,8,6 1,,9,,5,9 -1,,3,4,5,6 1,2,0,4,5,6 ...
0
votes
2answers
3k views

How to configure Windows to open CSV files directly in the browser?

How can I configure Windows and/or Internet Explorer so it opens online CSV files (files on the internet) directly in the browser without asking to download them? I want the same behavior of TXT ...
-5
votes
1answer
750 views

How can I upload my CSV file and keep fonts and bold lettering [closed]

Every time I save my CSV file it deletes the fonts / underlines etc. In my website I would like to have bold lettering, underlines preserved. I'm using CSV Import PRO and all the options i have are: ...
0
votes
0answers
297 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 ...
3
votes
3answers
4k views

Increase size limit of data import from csv into Excel

I have a load of data in a csv file that I'm importing into Excel, most of it is fine, but one of my columns contains up to 1000 characters of data. Unfortunately, Excel has taken it upon itself to ...
2
votes
1answer
2k views

Export Office Excel table to csv using a macro

I'm using Excel Tables in Excel 2010. I would like to quickly export the contents of these tables to *.csv. My current workflow: 1. Select table manually 2. Copy the contents into a new workbook ...
0
votes
2answers
390 views

windows text editor that allows csv/tsv data column sorting

I thought I remember reading that there is a text editor that exists for windows that allows the sorting of data, treating the csv/tsv similar to how it is treating when one sorts in excel. Any ...
1
vote
2answers
2k views

Edit csv file with Excel without reformatting

I have some csv data file that looks like this 1,2,3 5,6,7 I open it with Excel 2010, do some change (change some value, delete a column, or anything), and then re-save the file still as csv. But ...
2
votes
1answer
238 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 ...
0
votes
3answers
2k views

Batch script to append record to csv files

I have a bunch of stock data in csv's that I am backtesting trading strategies on. The problem is that my strategy buys the open market price if a signal was found yesterday, unfortunately my data is ...
1
vote
2answers
3k views

Open a .csv file in Excel and have it update whenever .csv file changes

Hi I'm working with some web scrapping and the data on my csv files will be constantly changing. I want to open these files on Excel to view and also have it refresh whenever the csv source changes ...
0
votes
5answers
5k views

How to prevent the number increase in the excel for Autofill?

I want my column to look like number 30/31/32/33/34 30/31/32/33/34 30/31/32/33/34 30/31/32/33/34 ...... eg: The content in each cell is 30/31/32/33/34. I want to fill all of the cells in the column ...
0
votes
1answer
124 views

universal text data format converter

I'm looking for a bidirectional file serialization format converter: xml, json, csv, sql table, excel, html, etc. I've only found tools that performs unidirectional conversion from one format to ...
3
votes
1answer
214 views

Outlook 2007 export contacts including list info

I want to export all contacts in outlook 2007 for import to gmail. Many of the contacts are members of various distribution lists, but there are no info in the exported csv-file as to which ...
0
votes
2answers
135 views

Is there any way of preventing .csv files being converted into excel format

I'm trying to work with an automated testing tool which can use .csv files as its data sourse. After saving a notepad file containing a number of fields and data seperated by commas as .csv it ...
0
votes
1answer
546 views

mongoexport csv output array values

I'm using mongoexport to export some collections into CSV files, however when I try to target fields which are members of an array I cannot get it to export correctly. command I'm using: ...
3
votes
3answers
1k views

How to edit the header of a huge CSV file in-place?

I have several huge CSV files in which I want to swap two column names. I do not want to modify/copy/rewrite the data. The operation is very cheap in C: fopen the file, fgets the header, fseek or ...
2
votes
1answer
312 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 ...
0
votes
1answer
57 views

How to clear up all commas after deleting all the data in CSV in Excel software?

I have this raw item.CSV file: Name,Price,date "item1",10,2012-11-21 "item1",10,2012-11-21 "item1",10,2012-11-21 I open it in Excel, it looks correct: Then I clear all the data except the ...
3
votes
1answer
239 views

CLI program for xlxs -> csv conversion?

Is there an foss command line program that can convert between Excel (.XLXS) and Comma Separated Value (.CSV) files?
0
votes
1answer
1k views

Set row delimiter in Excel

How can I use row delimiter other than \n? CSV fields contain \n and the row delimiter is \n\n\n\n, to separate line breaks in fields from the row delimiter. I'm using Excel 2010, and in need to ...
1
vote
1answer
1k views

How to force Excel to treat dates in CSV as text in a macro

I have a macro that lets the user select a CSV file and then manipulates it. However, it treats cells that contain things like 1/2/12 as a date. I need to keep these strings as text, not dates. I ...
2
votes
1answer
226 views

Manually “draw” data for chart, output to CSV

I need a service that will allow me to draw a chart line by hand and generate data points for what I drew. This might sound crazy, but I need some data (preferably in CSV output) that will only ...
3
votes
1answer
1k views

Interactive console based CSV editor

Although spreadsheet applications for editing CSV files on the console used to be one of the earliest killer applications for personal computers, only few of them and even less documentation about ...
1
vote
2answers
1k views

How to plot 3D graphs in Excel from CSV data?

I have data formatted like this in a csv file: a, 1, 4, 6.0 a, 2, 42, 16.0 a, 5, 14, 69.3 a, 11, 4, 7.0 b, 1, 45, 6.0 b, 2, 45, 1.9 b, 9, 2, 4.4 b, 11, 4, 7.9 lines with first parameter a is one ...
1
vote
1answer
621 views

Numbers imported into Ubuntu Libreoffice calc from text or csv files are coming in as text

I working in Libreoffice 3.6.0.2 in Ubuntu. I have a text file that has some columns of text and columns of numbers. When I import them into Calc either by copying and pasting or saving as a csv and ...