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

learn more… | top users | synonyms (1)

48
votes
4answers
24k views

Is it possible to paste CSV formatted data into Excel 2007?

I want to copy and paste CSV formatted text into Excel 2007. Is there a way of doing this without saving it to a temporary file first? I'm sure in previous versions of Excel there was a way to ...
46
votes
4answers
33k views

How can I stop Excel from eating my delicious CSV files and excreting useless data?

I have a database which tracks sales of widgets by serial number. Users enter purchaser data and quantity, and scan each widget into a custom client program. They then finalize the order. This all ...
36
votes
7answers
49k views

How to open semicolon delimited CSV-files in US-version of Excel

When I double-click on a .csv file, it is opened in Excel. The csv-files have columns delimited with semicolons (not commas, but also a valid format). Using a German Windows/Excel setup, the opened ...
27
votes
7answers
67k 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?
21
votes
14answers
14k views

Querying a CSV file

Does anyone know of a simple tool that will open up a CSV file and let you do basic, SQLesque queries on it? Like a graphical tool of sorts, one that is easy to use. I know I could write a small ...
19
votes
7answers
39k 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", ...
18
votes
3answers
72k views

How do you change default delimiter in the Text Import in Excel?

I want to import a CSV file to Excel. The CSV file has comma separated data (go figure), but the delimiter in the Text Import Wizard is set to "Tab" by default. How can I change the default to "Comma" ...
17
votes
4answers
84k 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 ...
15
votes
3answers
15k views

Lightweight CSV viewer for Mac? [closed]

I need to view (large) CSV files on my Mac. I could use something like OpenOffice, but unfortunately it's pretty big and slow. I'm wondering if there's a Mac equivalent of some of the Windows tools ...
14
votes
3answers
16k 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 ...
13
votes
14answers
2k views

What is an alternative to Excel for editing spreadsheets?

I often have to manipulate Excel and CSV spreadsheets to prepare data being imported into MySQL. I need to do things like find and replace values, insert and remove columns, sort rows, etc. I ...
12
votes
4answers
6k views

How to join two CSV files?

Suppose you have one CSV file with 2 fields: ID and email. You have another file with 2 fields: email and name. How can you produce a file with all three fields joined on email?
12
votes
1answer
17k views

Saving a file in a CSV type in Excel always removes the BOM

I've been trying to find a reasonable solution/explanation (unsuccessfully) to find out why Excel defaults to removing the BOM when saving a file to the CSV type. Please forgive me if you find this a ...
11
votes
5answers
19k views

Formatting a comma-delimited CSV to force Excel to interpret value as a string

Searching around for a while trying to figure out how to format a CSV file in such a way to force Excel to interpret the values as a string and not try and convert them to numbers or dates. e.g... ...
11
votes
2answers
5k views

True difference between Excel CSV and Standard CSV

What is the true difference between an Excel CSV and a standard CSV? For example, when handling columns with line breaks inside one cell, how do they encode it differently?
10
votes
8answers
7k 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++, ...
10
votes
2answers
18k 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?
9
votes
1answer
10k 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 ...
7
votes
4answers
4k views

Light text editor for CSV file? [closed]

Could anybody suggest a light (small, fast) text editor that can handle columnar view of csv files? save quote character to all fields, even if not 'necessary' OpenOffice Calc is bit big for my ...
7
votes
3answers
3k views

Transforming CSV file using sed

In order to be able to import some data into a certain tool, I have to transform a CSV file from this format "data","data","data data","data","123" into this format data;data;data data;data;123 ...
7
votes
4answers
3k 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: ...
7
votes
2answers
2k views

How do I get excel to not mess around with the formatting of a .csv file

I have two issues with a csv file that occur when I try and edit it in Excel. I have an ISBN column that gets reformatted to scientific format every time I save the file The encoding for the file is ...
7
votes
1answer
15k 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.
7
votes
1answer
2k views

Looking for a very fast to load lightweight csv viewer [duplicate]

Possible Duplicate: light text editor for csv file? (on windows) I frequently need to open csv files just to have a look at what is inside and what its structure is. I also may need to find ...
7
votes
3answers
7k views

Saving filtered results from an Excel workbook to a CSV file

I have an Excel workbook with a lot of rows in it. I filter it using the values of one column and then I want to save the filtered results to a CSV file. When I do "Save as..." I get all the rows. I ...
6
votes
2answers
18k views

Why does excel always say “..may contain features that are not compatible with CSV” when saving a CSV file?

Every CSV I've ever tried to save from Excel (2010, anyway) says filename.csv may contain features that are not compatible with CSV (Comma delimited). Do you want to keep the workbook in this format?. ...
6
votes
4answers
5k views

Unix command-Line CSV viewer

Is there a convenient command-line csv viewer, possibly a unix tool or a mod of some tools (e.g. vim or python)? I find it easy to simply edit CSV files by writing it manually (since all you need to ...
6
votes
1answer
3k views

break up a large CSV file

I have a large CSV file (about 6,000 rows) that I want to break up into smaller CSV files (about 100 rows each). Is there an easy way to do that?
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
5
votes
5answers
35k 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 ?
5
votes
2answers
20k 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. ...
5
votes
6answers
8k 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 ...
5
votes
2answers
2k views

Importing CSV into Excel with commas in quoted fields

I have a CSV file that contains a text field that can have commas in it. When importing it into Excel, it's picking up these commas as field separators. I have the field in quotes, and I've tried ...
5
votes
1answer
2k views

Copy value in Open Office Calc

I have a handful of cells in several spreadsheets that contain =AVERAGE(<some range>) and when I try to copy them into another spreadsheet I just copy the function and get #REF!. Is there any ...
5
votes
1answer
1k 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 ...
5
votes
1answer
347 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 ...
5
votes
2answers
3k views

Importing multiline cells from csv file into excel

I have a csv file (comma delimited and quoted). When csv file is opened directly from explorer excel correctly interprets the cells that are mutliline, but it messes up the character encoding (utf-8). ...
4
votes
11answers
23k 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 ...
4
votes
5answers
2k views

Excel 2007 is converting CSV fields into formulas

I have a problem with a CSV file which has telephone numbers stored in their internationalized format (+1-800-555-1234). When opening this CSV in Excel 2007, it converts that data to a formula and ...
4
votes
1answer
359 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?
4
votes
2answers
1k views

Excel 2007 save import steps on csv file?

I have a csv file that constantly needs opened into Excel and then have the data copied over to a separate workbook. I find the process of having to click through all of the dialogs, setting the text ...
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 ...
4
votes
2answers
9k 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 ...
4
votes
6answers
1k views

Transform Fixed Width to CSV?

I have a whole bunch of data files with different content but identical layout. I need to convert them to CSV before importing them into a CRM application. I usually open the tab-delimited file in ...
4
votes
1answer
2k views

Saving to CSV file always adds quotation marks in OpenOffice

I'm trying to use OpenOffice Calc for editing CSV files with TAB as delimiter. No matter what I do, Calc is insisting on adding quotation marks (") to the strings. If a cell content is number only, ...
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 ...
4
votes
1answer
777 views

Custom CSV (.csv) filter for OpenOffice.org or LibreOffice?

Is it possible to create a some kind of 'custom CSV filter' for OpenOffice.org or LibreOffice spreadsheet program. What I need is to have the program to use predefined CSV settings for loading and ...
3
votes
3answers
361 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. ...
3
votes
3answers
988 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 ...
3
votes
3answers
593 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 ...