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

learn more… | top users | synonyms (1)

0
votes
3answers
926 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
30 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
105 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
367 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
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
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
1answer
495 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
113 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
135 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
428 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
109 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 ...
3
votes
1answer
359 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
112 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
53 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
931 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
130 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
90 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 ...
4
votes
2answers
10k 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
87 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
752 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
121 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
2k 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
1k 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
330 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
231 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
303 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
130 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
1k 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
450 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
1k 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
291 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 ...
5
votes
2answers
23k 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
246 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
146 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
696 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
131 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
113 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
384 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
110 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
162 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
104 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
8k 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
294 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
492 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 ...