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

UNIX - Surround all Column values of CSV with double quotes

I have data in following format : productType , Description Oven , Accurate Preheat, good start for the day hairDryers , Comes with extended warranty , 50% off Desired Output: "productType" , "...
1
vote
3answers
3k 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 ?
-2
votes
0answers
18 views

Difference between two rows of one column, add new row in between if different. (CSV)

I have multiple CSV files with similar data. which is retrieved from an automation module, I want to compare two adjacent Time Stamps and if they are less than 15 min apart add a new time stamp (row) ...
8
votes
5answers
83k views

Difference between CSV and XLS files?

What are CSV and XLS(Microsoft or OpenOffice) files ? What is the main difference between these two files ?
51
votes
14answers
186k 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
1answer
26 views

cannot find any saved .csv files

I did search through many of the .csv realated topics that the search returned so I hope this is an appropriate new question... I am trying to setup an excel spreadsheet using a .csv file as the data ...
0
votes
0answers
27 views

Delete column from csv file with only cmd [duplicate]

Looking for some way to delete specified columns from csv file using only batch command file
1
vote
0answers
37 views

Excel Text Import Wizard Default Delimiter

Within the Text import Wizard, the default delimiter is TAB. Is it possible to permanently modify this default to be a comma? Don't be tempted to think that this is a duplicate question. Neither this ...
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 ...
-1
votes
0answers
24 views

How to import data (csv) into s health?

I'm trying to migrate from iOS to Android and looking for a way to transfer Apple Health data to Samsung S Health. I've found the way to export data from Apple Health into comma separated value (.csv)...
0
votes
1answer
22 views

excell & csv is converting my tell no to not have +

I have tried several tricks and none of them are working i have tellephone numbers '+4 55 555 555 555 and in excell the cells that have the little green triangle warining sign, they loose the +4 and ...
2
votes
1answer
2k views

How do I suppress the “file format and extension of MyFile.csv” do not match."?

I'm opening a lot of csv files using Excel recently and am repeatedly receiving the warning:- The file format and extension of MyFile.csv do not match. The file could be corrupted or unsafe. ...
0
votes
3answers
4k 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 ...
28
votes
2answers
116k 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. ...
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
2answers
27 views

How to deal with lines starting with '=' in Excel?

I want to obtain a simple CSV file that looks like this: Filename,Value1,Value2 filename1.ext,0.38,0.44 filename2.ext,0.60,0.50 ... However, -unfortunately- some of my filenames start with = and ...
0
votes
2answers
19 views

Libreoffice Calc Saving TSV as CSV without asking

Create a tab-separated file saved as test.txt. Open in text editor and save: 1 2 3 4 This is a test (Those are tabs) Open it with Libreoffice Calc Click "Save" Libreoffice asks "Are ...
1
vote
5answers
33k 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 ...
12
votes
3answers
22k 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
3answers
3k views

Excel saves a file in .csv but it keeps the columns and the rows as they were in the original sheet

I have a problem converting an Excel sheet in a *.csv file. I've searched all day for solutions, but nothing seems to work. After I select the sheet and save it as "CSV(Comma delimited)", pressing OK ...
0
votes
1answer
45 views

How to `cut` (extract a subset of columns) a CSV file that contains quoted strings`

I have a CSV file and want to discard a couple of columns. So let's say this is a sample file: column a, column b, column c value a, value b, value c value a, "quoted, b", value c And now let's ...
0
votes
0answers
24 views

ping results exported to .csv to multiple rows and columns

I have a script that I run to ping multiple Ip addresses. It works just fine with everything that I have in it the way I want it. The problem is the export. I need "Router" to Start in Column "A" ...
2
votes
2answers
3k 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 ...
7
votes
8answers
23k 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 ...
3
votes
4answers
663 views

How to export a spreadsheet to a UTF-8 .csv from Excel 2016 on mac?

Hoping you can help me out with this one... For my work, I've been assisting a DBA for the last few weeks and we've now been given the task of uploading a very large spreadsheet which has several ...
0
votes
1answer
31 views

Excel: format first/last name to “lastname.firstinitial” format

I have exported a CSV of a list of employees. In cell A1 (the name format is the complete first name, space and then the complete last name). How do I make a cell with complete last, underscore then ...
37
votes
5answers
187k views

How to set character encoding when opening Excel

Is it possible to set the default encoding for Excel (any version, e.g. 2010) when opening files like csv files (like you can in Open Office Calc)? I When I try to open a csv file encoded in Japanese ...
1
vote
1answer
70 views

Merging Multiple Text File Data, but Specific Lines to Another

I have several Textfiles with a header of no interest and some relevant data. I want a new file with all the important data: Example: File1 has text: Created on 02.02.2016 Country: Chile Figure of ...
14
votes
2answers
16k views

How can you make Excel 2007 stop formatting large numbers as scientific notation?

Kind of the inverse of this question. I frequently download CSVs from outside sources as part of my programming work. I like to examine their data in Excel because, let's face it, Excel is an ideal ...
0
votes
1answer
42 views

Editing CSV file in Excel always converts number column to scientific notation [duplicate]

I have a CSV file that I'm editing in Excel 2013. In the file there is a column that contains numbers e.g 688087123456789. Everytime I open the CSV file in Excel, it converts the number to scientific ...
0
votes
1answer
17 views

getting only the names of the contacts when importing .csv file to my yahoo contacts?

i have been trying to import my contacts from my personal computer by converting them the .xlsx to .csv format and only the contact names are imported instead of the whole contact.my excel file is ...
6
votes
5answers
11k 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 ...
2
votes
2answers
47 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
19 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
929 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
42 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 ...
14
votes
8answers
54k 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 ...
4
votes
3answers
4k 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
25 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
31 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
22 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
100 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
52 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)? =HYPERLINK("https://elicense.ct.gov/Lookup/...
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 ...
0
votes
0answers
13 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
13 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 ...
0
votes
1answer
71 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, 2,...
0
votes
0answers
95 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 ...