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
3answers
3k views

Fast way to export data out into different excel files based on Column

There's some data like this (with over 500,000 entries) Name | State ---- ----- Billy Utah Sue California Joe Utah Sally California John Michigan ...
2
votes
2answers
36 views

Why does Excel display these CSV files differently? One with Quotes One Without

I have two csv files and they appear the same when I look at them in a text editor like notepad++. However, when I open them both in Excel (2003 at this moment) one of them shows double quotes in ...
0
votes
0answers
15 views

Matching 3 or more words from fields in seperate csv files.

I have two csv files: This is csv1: 11, The Sun Still Shines in Reading, 64312, 464566 13, You and Me Together Again London, 564564, 131355 12, What's the Story Now Your Gone, 4545646, 1124545 17, ...
2
votes
2answers
918 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
0answers
28 views

Default character encoding for Excel Text Wizard?

A large part of my job is to run an SQL query, save the results as a UFT-8 encoded csv file then import it into Excel for further manipulation and distribution. When I import the csv file into Excel ...
0
votes
3answers
3k 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

Getting Excel to handle CRLF's correctly in CSV

I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them ...
13
votes
8answers
50k 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 only certain columns like ...
3
votes
3answers
3k views

excel: export csv file with japanese character

In my excel file, the Japanese character is shown correctly, while when I export it as csv, the character become question marks How should I output so that the character can be shown correctly?
0
votes
1answer
10 views

How to link csv file in Libreoffice 5

In previous versions of Libreoffice Calc, it was straightforward to import and link csv files through [Import] -> [Sheet from file...], as per the instructions on this page. This allowed me to refresh ...
0
votes
0answers
28 views

How to sanely export CSV in Microsoft Excel 2010

I need to export a sheet that has data in columns A:N but if I open it in Excel it has columns O:XFD that are just blank. When exporting to CSV Excel exports everything in those columns, thus the ...
0
votes
2answers
17 views

Viewing Tab Separated Values on the Terminal (it doesn't show the tabs)

If I have a tab separated values file, and I say cat it, it nicely renders the file for me all lined up properly. Now if I try to copy paste (using my mouse), to another text editor. The tabs become ...
0
votes
1answer
89 views

Transform a CSV with Notepad++

Suppose I have a CSV file like this: 1,"abc",,,, 2,"def",,,"ghi", 3,,"jkl",,,"mno" Now I need to transform it in 3 steps: Replace all empty spaces with the String NULL Add at the beginning of ...
0
votes
2answers
41 views

commas as text in CSV

How can i get this entire string to be imported into excel from CSV as one column (read the comma as text in the string, not a separator)? ...
0
votes
0answers
13 views

Converting CSV decimal time value in SQL select statement [migrated]

I have a CSV file I'm loading into a dataset. The time field is actually a decimal value since the type is set to General. How can I convert this time (not Date) to hh:mm format in the SQL statement. ...
9
votes
2answers
2k views

Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format?

I work with many CSV files, and am constantly annoyed by the Excel dialog that pops up when I try to save a file: "[your spreadsheet] may contain features that are not compatible with CSV (Comma ...
7
votes
8answers
21k views

How do I get Excel to import a CSV file with commas in some of the content fields?

How do I get Excel to import my CSV file? File I have a file claiming to be CSV. It contains 10 fields, all of which are surrounded by double quotes (yes, even the dates and numbers.) 2 or 3 of ...
0
votes
0answers
8 views

How to migrate artifacts fom a project to another

I am the scrum master of a project. As a newbie to Tuleap, I created a sandbox project. After experimenting in my sandbox, I want to feed my true project with artifacts like user stories or epics. I ...
0
votes
0answers
31 views

Excel converts comma delimited to tab delimited when saving [duplicate]

I create data in Excel 2013 and save it as .csv. We have an application that imports files of type .address so after saving the file as customer.csv, I change the extension to customer.address. This ...
1
vote
0answers
12 views

text qualifier of csv missing in excel

I have created a csv file with semicolon as delimiter and double quote ad text qualifier. But when I open in excel, the first double quote of the rows disappear. When I use text to column wizard ...
2
votes
2answers
4k 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 ...
0
votes
1answer
50 views

add space after nth commas in Excel, Notepad++, or emEditor?

Notepad++ 6.8.8 I want to be able to turn several lines that start like this: 0,2,3,45,67,89,01,234,567,890,123,4567,8901 0,7,8,9,0,11,12,13,14,151,162,173,184 x,z,q,r,n,f,t,a,e,f,z,n,a into 0, ...
0
votes
0answers
92 views

Create Xbox Music Playlist from excel list (csv)

I created a few playlists in Excel (just the artist & song title) that I wanted to Import into Xbox Music. Unfortunately the only way I could find was to search for each song indivdually and then ...
0
votes
2answers
27 views

Taking part of CSV file

I have a very large CSV file which I should analyze. It's too big so I can't even open it in Excel or Stata. So I want to take first few rows of it and explore the data, and then select necessary ...
0
votes
1answer
546 views

Weird glitch after copying from a CSV file?

I was doing a programming job that involved writing data to a large CSV file (700 MB). I occasionally opened the file using libre office to check the data coming in. This morning I opened the file ...
5
votes
4answers
36k views

How to avoid double quotes when saving Excel file as Unicode?

I have an Excel file with Unicode content of which some cells contain text inside double quotes, for example "text". When I save the Excel file to a text file in Unicode format, the text which ...
0
votes
0answers
3k 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 ...
0
votes
2answers
15 views

How can i change the directory in this VBA code? VBA “Excel to TXT or CSV”

I really want to change the directory of this code in Application.ActiveWorkbook.Path but i don't know where to put it. Public Sub CharacterSV() Const DELIMITER As String = "|" Dim myRecord ...
2
votes
1answer
43 views

How to specify semi colon character ';' as a line ending character when importing CSV to Excel on Mac

(Using Microsoft Excel form Mac version 15.18) Can see delimiters for the columns in the import steps, but no-where is there an option for defining what the line ending character is. I need this so ...
30
votes
3answers
35k views

Converting CSV to fixed-width in Notepad++?

Is there a way in Notepad++ to convert a comma-separated file to fixed width columns? This feature exists in UltraEdit and explained in Working with CSV files, but I am happy with my Notepad++, and I ...
9
votes
2answers
18k views

How to convert Excel file with multiple sheets to a set of CSV files?

I have an Excel file with 20 sheets on it. Is there a way to quickly convert the file into 20 CSV files - one for each sheet? I can do it manually of course, but I'll have to be processing these ...
0
votes
0answers
57 views

Exporting Outlook contacts to Unicode CSV

Background So I've been looking for this to work for some time now. I'm sure there must be a solution as I can't believe that no one in China or Japan have ever tried exporting contacts. What I've ...
49
votes
12answers
172k views

How do you force excel to quote all columns of a CSV file?

Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?
0
votes
2answers
220 views

Importing multiple CSV files

I have to run a daily stock analysis where I pull multiple .csv files, and then have to go through an annoying task of deleting unnecessary fields from the .csv's. Only then can I start compiling the ...
3
votes
1answer
893 views

Free or Open Solution for Storing and Charting CSV data [closed]

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

Export a csv file to multiple csv files with batch command

I have a 100 line csv file, with 5 values per line. I am looking for a way to export each line to its own csv file adding a 2 line header to each. I have used the split command seen elsewhere to ...
-1
votes
1answer
44 views

Removing duplicates from txt file

I have a txt file that can contain up to 13.000.000 randomly generated codes seperated with "\n" by the fputcsv function in php. What is the most effective way of removing duplicates from this file? ...
0
votes
4answers
3k views

Preventing Quotes from being used around text when exporting to TSV

In Excel, Is there an option to prevent quotes from being used on text strings when you export a sheet to TSV?
5
votes
12answers
48k 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 ...
0
votes
2answers
208 views

How to get Excel to save date fields as displayed

I have data that has date-time values that I need to convert to a different format. I have created an Excel formula that concatenates the string into exactly the format I need. I currently have the ...
3
votes
1answer
4k views

How to add time duration column total from Skype Call History CSV file in Excel 2010?

How to add time duration column total from Skype Call History CSV file in Excel 2010? These are my exact steps on how to set up my Excel spreadsheet. How to import Skype Call History CVS in Excel ...
0
votes
2answers
3k views

Removing commas from CSV file

I created an Excel .XLSX file, reformatted the columns from currency to numbers with 2 decimals and no thousands separator, then exported to a .CSV file, then to a .TXT file. Once I did that, the ...
5
votes
6answers
15k 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 ...
-2
votes
1answer
46 views

Separate fields in comma delimited fields

I am importing a comma delimited file into a ms access database that has statistical information for horse racing. The file has individual horses, dates of their races, finish position, etc. I am ...
1
vote
0answers
20 views

Notepad++ multi line copy paste in different lines

I have a csv file with: David,33,Virginia John,45,Alabama Tina,33, Texas Another file which contains: <Person> <Name>name1</Name> <Age>xx</Age> ...
0
votes
0answers
32 views

Importing Variable data sets with UTF 8 BOM japanese characters

I have an image template and have a xlsx file with Japanese characters wit two columns(PFA). I need to create images with this information by importing the CSV into variable data sets. When I convert ...
1
vote
1answer
2k views

How can you change Mac excel 2011 to separate using commas, not semicolons?

I have Excell 2011 on my Mac, and when I try to export a .xls file into .csv I end up having a semicolon separated file instead of .csv. p.s. The System preferences for my keyboard input is italian ...
2
votes
1answer
221 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 ...
0
votes
1answer
220 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©ô Ès?¿%žfÇu9ä½''üÿ¸ ...
1
vote
2answers
83 views

CSV to map/card [closed]

I have a CSV file with 500 users in it, with adresses, 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 ...