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

learn more… | top users | synonyms

1
vote
1answer
194 views

Delete cell content in Libre (Open) Office based on the cell value

I have a huge csv file (tens of thousands of rows) that I need to filter based on different criteria. After trying to find a proper CSV editor, I decided to use LibreOffice Calc. CSVed is great, but ...
7
votes
4answers
2k views

Sorting numerically in a comma-delimited file with Unix

I've got a comma-separated file that looks like this: 100,00869184 6492,8361 1234,31 200,04071 I want to use sort to sort this file numerically by the first column only. Desired Result: ...
1
vote
2answers
507 views

Filter a CSV file using Windows batch file

I have a file with 12 columns separated by ? I need to export column number 12 (NetBIOS Name) and append the whole row to a CSV file. Skip the first line that is the column description. The first 4 ...
1
vote
1answer
176 views

How to use the current date as an argument?

I have a batch script which extract SQL data to CSV file: bcp Database.dbo.MyTable out C:\Reports\Output.csv -s ServerName -T -c I need the name of the output file to contain the current date. For ...
2
votes
0answers
446 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 ...
3
votes
1answer
433 views

Word 2007 prompts twice for “Opening this document will run the following SQL command” for Mail Merge

I am trying to figure out why my mail merge in the a Word document is prompting me twice for seemingly two different data sources. Both prompts look like the following: . The first prompt points ...
1
vote
0answers
152 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 ...
8
votes
8answers
5k views

Notepad++ - Removing the first column in a comma separated file

I have a large CSV file that I need to remove the first column of data. I cannot open it in Excel because Excel converts some of the values in the columns to scientific numbers. I am using Notepad++, ...
1
vote
1answer
419 views

Spider/crawl a website and get each URL and page title in a CSV file

I am moving from an old ASP shopping cart site to a Drupal/Ubercart site. Part of this move is to ensure that old links will redirect to the new ones. To do that all I need is some way to get a list ...
0
votes
2answers
650 views

Joining CSV files in Ubuntu

I'd like to join csv files in Ubuntu. file_A.csv: ID_a, ID_b, a, b, c key_a, A, a1, b1, c1 key_a, B, a2, b2, c2 key_b, A, a3, b3, c3 file_B.csv: ID_a, ID_b, d, e, f key_a, A, d1, e1, f1 ...
0
votes
0answers
243 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 ...
3
votes
2answers
3k views

Compare two spreadsheets and get missing records

I have 2 CSV documents. one has 10.000 rows with 50 columns, first row is a unique SKU. Now I have a second document with 9.500 rows using the same identifiers. I simply want to create a third ...
3
votes
3answers
789 views

Why does Excel 'green tag' random cells in a csv file?

I have two CSV files, test_a.csv and test_b.csv. The green-tag info-box highlights "Inconsistent formula". Why does Excel green tag A4 in test_b.csv? How can I prevent Excel from green tagging my ...
6
votes
2answers
80 views

Importing first line of TXT files to a spreadsheet

I have 2000 txt files that I need to read the first line of (it should contain a person's name). Ideally I would have a spreadsheet/csv with FILENAME, FIRST LINE OF FILE
2
votes
2answers
62 views

Emails in CSV B that are not in CSV A

I have two CSV lists of email addresses (List A and B). Our marketing guys accidentally sent an email to people in List A instead of combining both lists before sending. An email needs to be sent to ...
0
votes
1answer
470 views

how to convert line-delimited txt file into a spreadsheet file as tsv or xls

I have a huge amount of phone numbers (for example), one for each line in .txt file. 202898990 909090090 909090900 ... I want to put each number in a a cell (phone numbers in the same column). I ...
0
votes
2answers
1k views

How can I keep leading zeroes in a comma delimited, double-quoted fields csv file when viewing in Excel 2010?

Yes, I've researched the question here, here, and at stackoverflow and I know this seems like a duplicate question. Therefore, I'm making my question more specific: "How can I keep leading zeroes in 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 ...
0
votes
4answers
2k views

RegEx to Remove CRLF from CSV export from Excel

I exported an Excel File to CSV and do have a lot of multi-lines within. I marked the beginning of each line with * and the end with ###. *** some text within my cell to export ### Could someone ...
1
vote
1answer
119 views

Regex to join fields in a CSV

I have a CSV with over 2 million records in it with the following format. path;name;extension;size;date;user /foo/;difacs;cgi;3,795;18-07-2011;Unix User\pads ...
0
votes
1answer
216 views

Conversion of GRIB and NetCDF to my database

I have downloaded "High Resolution Initial Conditions" climate forecast data for one day. It was a .tar.gz file so I extracted it in my local directory and I get the files as shown in the image below: ...
0
votes
1answer
332 views

Linux replace ^M$ with $ in csv

I'm working on migrating from MDaemon to Google Apps. As part of this process I'm exporting the contacts and calendars for all of our users into CSV files then reading them into a perl script and ...
2
votes
3answers
1k views

Is there a way to do an inner join in Excel between 2 csv files?

This seems like a simple concept, yet I can't figure out a way to do it without writing some code. Does Excel have a function that will let me join columns from 2 different csv files (say Orders and ...
3
votes
3answers
329 views

Importing from a CSV modifies the number format into scientific notation (1,23E+18)

Suppose I have a following string in a .csv file which I am trying to open in Excel 2010: 1073741824;1073741824;1073751824;1073741832;1152921513196781569 However, when I actually open it, the value ...
3
votes
2answers
702 views

Notepad++ replace doesn't work for Regular Expression

EDIT Proof that it should work: http://regexr.com?30pf2 I'm trying to replace all occurrences of , that are not within quotes with a ~ 20,72275,Epidurography,1 21,72285,X-Ray C/T Spine Disk,1 ...
1
vote
2answers
62 views

CSV to map/card

I have a CSV file with 500 users in it, adresses and age etc. I would love to have some graphic on that, importing this csv file into some sort of map program, then display it. I have found several ...
0
votes
1answer
156 views

Problems exporting word dashes and quotes from Excel into .csv

I'm trying to export a spreadsheet to a .csv file and when I do, it takes all of the quotes and dashes and they turn into ?'s. I realize it's trying to maintain the Microsoft standard of quotes and ...
4
votes
11answers
17k views

How to stop Excel Treating US dates as UK dates?

I'm in the UK, I've got a problem where I've got a list of dates supplied in US format. Excel seems to treat the ones that are valid in both formats as UK dates, (e.g. 03/01/2012 becomes 3rd of ...
14
votes
5answers
17k views

Easiest way to open CSV with commas in Excel

CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this: It's probably because when Excel thinks "comma-separated values", ...
2
votes
4answers
12k views

How to export selected columns into csv file

I want to export specific number of columns from excel into .csv file. I have around 10 columns like lname, fname, phone, address, email and so on. what should i do to export certain columns like ...
3
votes
1answer
560 views

Free or Open Solution for Storing and Charting CSV data

I'm presently storing CSV files, combining them, opening them in open office, creating pivot tables and then generating charts from the spreadsheet. I've looked at OOBase, but appending csv files to ...
6
votes
2answers
14k views

How to control CSV import into Excel 2010

When I open CSV files in Excel 2010 I get entire rows in cells, not distributed according comma separation. How to control this?
1
vote
3answers
738 views

Open CSV file in Excel having leading dash

I have a csv file which looks like this : Ref;Code;OtherData; "MyRef";"-arm";"something"; I think this form is valid, isn't ? When I open the file in Excel, the "-arm" is parsed by Excel as a ...
0
votes
1answer
120 views

CSV - Microsoft office for mac 2008 doesn't add all the commas?

Let's say I have 5 column headings and I only complete the first 2 values. I then save the file as CSV (Windows). It ends up looking like this: ID,Product,Name,Value,Interest 1,PC Which is no good ...
0
votes
1answer
1k views

Cyrillic export from Excel to CSV

I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document. I use Save As » CSV in order to make a CSV file, but it is not ...
1
vote
4answers
6k views

How to write null into csv from Excel for blank fields

How do I write null for blank fields when I export a csv file from Excel 2007? Is there a feature to do that.
2
votes
2answers
6k views

Merging columns in Excel with “;” separator

I'm new here and I hope to seek for your assistance on converting data format of my excel to csv. This is my raw data in excel in different row and cells: A B C D E F 1 2 3 4 5 6 ...
0
votes
2answers
1k views

Notepad++/Regular Expression to find line with same beginning, different ending

So, I've read a bit and found NotePad++ doesn't use "normal" regex (starting to think I'll just go back to SciTE), but here's my question: I've got an exported list of data with some redundant data ...
1
vote
1answer
2k views

Excel: change data source with macro

I'm using a CSV file (generated by a thing party program) as an external datasource, and I'd like to change its path from a macro... How can I do that ? Another acceptable answer to my problem would ...
5
votes
1answer
12k views

What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited)

What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited) file types in excel 2010? They are all listed as a save file type, but ultimately are Comma Separated Value files.
4
votes
2answers
1k views

How to export multi-line cells to CSV file

I have an XSLX file where some rows have multiple lines, for example: test test1 test2 When I'm trying to export (using menu "Save As") this file as CSV or Excel workbook (1997-2003), Excel ...
0
votes
2answers
644 views

How to export file from excel (or other excel like software) to .CSV

I have 2 questions Question 1. Why is it when I try to export to csv file from excel 2007 I get a file that has a type of "Microsoft Office Excel Comma Separated Values File (.csv)"? I choose "Csv ...
1
vote
2answers
6k views

Export to CSV From Excel

I frequently use Excel to prepare data to load into a table. I create a CSV file from it and use that file for data loading. I generally find myself creating the CSV file multiple times. My current ...
0
votes
1answer
1k views

how to plot data from csv file?

I'm looking for a way to plot data imported from a .csv file much like the pivot chart view of an Microsoft Access table. I'm just having problems with Microsoft Access 2010 and was wondering if ...
0
votes
1answer
1k views

Export google document as csv without quotation marks

I have a google document spreadsheet that I want to export as csv. The problem is, that some cell get their content included on quotation marks: 1,1,"I don't want quote",Mee too but I'm lucky,1 To ...
5
votes
1answer
298 views

ODBC Query cannot be executed because it is too complex?

I have a CSV file which I am using as a database with LibreOffice DB. What I'm doing is explained in detail in this answer. I can do some operations, but when I try to enter the following into the ...
1
vote
0answers
178 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 ...
2
votes
2answers
1k views

Change line endings and delimiter format (permanently) when saving to CSV from Excel

I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to "," Is there ...
1
vote
1answer
397 views

User Friendly CSV to MSSQL import with column match

Hi before I reinvent the wheel I'm trying find something to allow a user to take .csv files and graphically match the columns in the database table to the columns in the csv file. I know this can be ...
3
votes
2answers
5k views

How to break a spreadsheet containing CSV into multiple columns?

I'm working on preparing data for export, and the client has put all of the data into a spreadsheet. Each field of data should be its own column. The problem is that the client erroneously put ...