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

learn more… | top users | synonyms

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 ...
0
votes
0answers
767 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 ...
4
votes
0answers
54 views

Excel 2007 doesn't preserve asian characters when converting to csv [duplicate]

I am trying to save a spreadsheet as a CSV file. The file consists of korean characters, and the resulting csv has those characters literally converted to question marks (0x3F). I am running on an ...
1
vote
1answer
120 views

How can I auto import a csv to a growing list in excel?

Everyday I receive a report in a .csv format, and on a daily basis I will copy the data into an "INPUT" tab on my spread sheet. The data on this input tab keeps on growing every day with the ...
0
votes
3answers
82 views

Pre-pending to an output line of `tail -f file` if its contents match another file

Trying to cram all of the following into the title was hard, so this is what I really mean: I am doing a tail -F access.log to watch an Apache2 log in realtime. The first thing on each line is an IP ...
0
votes
0answers
74 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 ...
3
votes
2answers
8k views

How do I split one row into multiple rows with Excel?

I have a product database in Excel with several hundred entries, each of which has from 1 to 3 "tiers" of pricing: Standard, Deluxe, and Premium. Each tier has its own SKU (A, B, or C added on to the ...
1
vote
2answers
78 views

Unix copy multiple folders based on a specified CSV list using rsync

I have done some research and it appears that rsync is the only method that can possibly help me achieve this. I want to specify a list of folders in a CSV which can tell rsync to copy them to ...
0
votes
3answers
649 views

Search .csv from within a batch file

I am looking to create a batch file that will search a .csv for a specific number, and then use the 2nd value in the csv as the input back into the batch file. Example: csv name= IP.csv .csv ...
2
votes
1answer
116 views

Csv filename bug concerning dots in Microsoft Query (via Office Excel 2013)?

After hours of struggling it looks like I've found a bug regarding csv file processing by Microsoft Query via Office Excel 2013. I'm trying to generate a Chart from csv data. Every hour a new record ...
3
votes
3answers
1k views

Convert Large HTML Table to CSV

I've got some data (basic personal details) which I need to export from an old legacy system to a newer system (MySQL DB). It's approximately 200MB split across 6 files. The system I'm exporting from ...
0
votes
1answer
949 views

d/m/yyyy to dd/mm/yyyy

I want to change the data such as 9/4/2012(some cells with, green arrow in the right corner. ) into dd/mm/yyyy. I want to standardize all the data of such column into dd/mm/yyyy , I format the ...
0
votes
1answer
302 views

Export an entire Access (accdb) database to csv/txt

There is no option to export the whole db, rather Access only allows export of one table at a time. I'm not familiar with any VB scripting so how would I go about doing this? CSV must be exported ...
1
vote
1answer
2k views

How to apply a 'comma separated list' as a filter in Excel?

I have a stock-list of books and would like to filter the stock data only with selected publishers. Is there a way I can provide a 'comma separated list' in the filter? I tried the 'Advanced ...
1
vote
2answers
209 views

How to import this data set into excel? (column headings on each row delimited by a colon)

I'm trying to import the following data set into Excel. I've had no luck with the text import wizard. I'd like Excel to make id, name, street, etc the column names and insert each record onto a new ...
1
vote
0answers
272 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 ...
3
votes
1answer
2k views

CSV files cant store special characters?

I have read several other questions on this subject but none have an answer which fixes my problem. I have an execel file which is in russian and I need to convert it to CSV without it losing any of ...
1
vote
0answers
127 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 ...
0
votes
2answers
848 views

excel: merging to data sets based on a common field

I have two excel .csv files that have a single numerical field in common, FIELD_A. What I'd like to be able to do is to leverage this common field in order to merge data between the two, so that I ...
0
votes
1answer
396 views

How to automatically update Google Calendar from shared csv file

I am creating a regular snapshot csv file from a proprietary calendar program. The CSV file is formatted so that it can be imported into Google Calendar. I'm wondering if there is a way to put this ...
1
vote
1answer
876 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
279 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
885 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 ...
5
votes
2answers
17k 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
216 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
131 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
599 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
123 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
101 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
346 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
107 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
151 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
99 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
7k 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
269 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
447 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
1k 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
3k 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
523 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
3k 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
481 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
542 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
178 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
436 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
7k 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
5k 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
2k 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
561 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
249 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 ...