Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.

learn more… | top users | synonyms (1)

-5
votes
1answer
988 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
340 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 ...
4
votes
3answers
5k 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 ...
3
votes
1answer
3k 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
460 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
274 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 ...
2
votes
2answers
4k 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
7k 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
131 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
217 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
143 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
701 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
2k 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
338 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
58 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
270 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
2answers
275 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 ...
5
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
686 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 ...
0
votes
2answers
851 views

Microsoft Excel maintain formatting when importing

I am using a CSV to import data. The column of data has different and sometimes multiple numbers in one field. For example... 2924,2925, 2926 in one field 2927,2928, 2929 in another field. I ...
1
vote
1answer
179 views

excel truncating phone number

I have a csv file that contains cells such as "+1.8882789780". When viewed in Excel, it loses the last digit possibly due to excel truncation. Is there a way to either change the setting in Excel to ...
3
votes
4answers
5k views

How do I export only visible cells from Excel to CSV?

I am running Excel 2010. At the top of my spreadsheet I have about 10 hidden rows. When I export to CSV, how do I export only visible cells?
0
votes
1answer
5k views

Comma Separated Values in Excel 2010

Comma separated values are shown in my Excel file in a single cell. I tried by changing the following value at Control Panel --> Regional and Language Options --> Regional Options --> ...
1
vote
0answers
237 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
1answer
248 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
5k 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
798 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
320 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
558 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
742 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 ...
2
votes
0answers
200 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 ...
10
votes
8answers
8k 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
607 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
1k 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
304 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 ...
5
votes
2answers
8k 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
1k 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
81 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
67 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
770 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
3answers
2k 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
90 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
3k 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
121 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
342 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: ...