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

learn more… | top users | synonyms

1
vote
1answer
570 views

Outlook 2011 Contact Import from CSV with Notes containing new lines / cr / lf

I'm trying to import several thousand contacts into Outlook 2011 for Mac. Everything is working well except the Notes field as I cannot figure out how to get new lines / carriage returns into it. ...
0
votes
1answer
537 views

CSV error on phone number

On my website I generate a CSV file from a database of users. When I view the CSV file in my browser all the information comes up as it was submitted by the users, but when I download the CSV file ...
1
vote
3answers
1k views

Convert ZIP code to state in OpenOffice

I'm trying to move data from two of our old systems into a new system. Problem is, somewhere along the line the 'state' column of our DB was corrupted. I have a column of ZIP codes I need to ...
0
votes
1answer
167 views

Export CRM 4.0 workflows to csv or txt

Is anyone aware of a method to export the steps of a CRM 4.0 workflow to a csv file or text document? I need to document a lot of workflows, and I'd rather not do it all by hand!
1
vote
1answer
5k views

How to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X

I have a CSV file which I can open and view the column with Chinese letters normally with TextMate. However, when I try to import this file into Excel 2011, the field comes with unreadable fonts. ...
1
vote
1answer
6k views

Export CSV with values enclosed with double quotes

How do I export a CSV file where the values and fields are both enclosed in double quotes (") from Excel 2004 (Mac)? E.g. "Name","Telephone" "John Doe","555-5009"
0
votes
0answers
90 views

Getting Access 2000 to output CSV with quote “only where needed”

Does anyone know how to get Access 2000 to output a comma-delimited file in this format: Good> Cat, "John, Doe", 32, $3.44, "Denver, CO", 1234 NOT like this: Bad> "Cat", "John, Doe", "32", ...
1
vote
1answer
747 views

Batch XLS to CSV Converter

Using Windows, I need a script to convert all the (xls) files of a directory to csv.
1
vote
2answers
693 views

How to copy lines in Excel file that contain a value from a list

Description I have a CSV file with 6000+ lines in it. I have a list of about 300 words that each appear in only one row of the CSV file. Problem How do I extract only the rows that contain a word ...
0
votes
3answers
2k 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?
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, ...
2
votes
0answers
264 views

Can I disable Excel's warning when saving CSV files? [duplicate]

Possible Duplicate: Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format? Excel always says ...may contain features that are not ...
0
votes
1answer
222 views

AWK CSV stream editing, merge third columns for identical first columns when second column >= 0

I'm on Windows and have only heard of linuxes awk etc so I can only imagine that this is possible without actual scripting: I have data like .. 162 42 A single serving 162 62 of ...
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 ...
2
votes
1answer
511 views

Formatting a tab-delimited CSV/TSV to force Excel to interpret value as a string

I had a followup question to this related post - Formatting a CSV to force Excel to interpret value as a string (not date or number) I was wondering how does one escape text starting with " using ...
3
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). ...
11
votes
5answers
12k 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... ...
0
votes
1answer
444 views

Example users list for import into windows server 2008

I am in a process of learning a microsoft course AD DS for win server 2008. In order to practice i need at least 1000 users to import into my server so i wander is there somewhere an example .csv list ...
0
votes
2answers
527 views

Get External Data with carriage returns

I am trying to find a way to properly import a text file into excel that contains a carriage return using the Get External Data option. The file has a text qualifier and is pipe delimited. Here is ...
5
votes
2answers
1k 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 ...
6
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 ...
10
votes
1answer
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?
0
votes
1answer
607 views

Export data from ODBC to CSVs or similar

I have a SQL Anywhere 5 database which I can currently access through ODBC. I managed to open it with Access but when I used Access to export text files it would truncate the data. Is there a way ...
3
votes
2answers
856 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 ...
1
vote
3answers
4k views

How to set a character limit and remove characters over that limit excel 2007

I have to provide a CSV file for a telephone system with names and numbers on for a directory. The numbers cannot contain any spaces, and the names must be 20 characters max. I have a list of ...
0
votes
2answers
4k views

How can I export a Windows Contact Group to CSV?

In Windows Vista I am using Windows Contacts. I have a contact group: C:\Users\Me\Contacts\club.group. I want to switch to use a service like MailChimp, ConstantContact, etc., those services can ...
0
votes
1answer
722 views

how to filter CSV files using batch

How to filter CSV files using batch as below: I have a file with 7 columns separated by '~' I need to check if column number 4 is in (456,987,654,123,456), If yes than append the whole row to ...
15
votes
3answers
61k 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" ...
-1
votes
2answers
484 views

join 2 csv files

How to join two CSV files? same question I want to join 2 files 1st file column 1 2nbd file column 1 except that one of the csv files has variable no of columns in every record it has a traceroute ...
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 ...
1
vote
1answer
628 views

How to automatically merge a .xls file and a .csv file to one Excel sheet?

I have an Excel sheet in .xls file. I want to merge it with a .csv file, so that the data in the .csv file will be added starting from the first empty row in .xls. I want to be able to do it ...
0
votes
1answer
587 views

How to automatically convert CSV file to XLS file with filters and formatting of the top row?

I have a big CSV file (10,000s of rows). How can I automatically convert it to an XLS file which will have Filters and some formatting (color, font) on the top row?
2
votes
1answer
3k 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 ...
17
votes
4answers
66k 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 ...
0
votes
1answer
285 views

Disable commas (,) in an entire Excel file

What's the most efficient way to disable saving of fields with commas in an entire Excel file? One approach could be to use Data Validation, and the other could be to validate all fields using a macro ...
3
votes
3answers
858 views

How to visualize/graph a massive dataset?

I have a CSV file of data collected using Performance Monitor. It collected CPU usage at 5 second intervals for two weeks. I need to be able to graph or visual the data in a way that'll help me ...
1
vote
1answer
362 views

How can I open a subset of a large (35MB) .xlsx file?

I have Ubuntu 10.04 running on a Dell Optiplex with 4GB of memory and two 3.16GHz processors. I received a 35MB spreadsheet. It opened in Gnumeric after 5 minutes with errors, and it hasn't opened ...
1
vote
1answer
548 views

Extract data from PDF document to CSV

I would like to convert a stack of financial documents, identically formated, into a CSV file. Here is an example: I have a program to do the OCR (optical character recognition) so that is not the ...
5
votes
2answers
15k 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?. ...
1
vote
1answer
355 views

Disable comma (,) in Excel Field

One of our Web Applications gives the users the ability to add multiple items to our database using a CSV file. To do this, they enter their items into an Excel template and then export to CSV. ...
4
votes
3answers
4k 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 ...
0
votes
3answers
767 views

Do multiple e-mail addresses need to be separated by a comma?

In CSV format, in an Excel spreadsheet or in a Word document, both having multiple email addresses with each address being in its own row and in a single column, is a comma REQUIRED after each ...
13
votes
3answers
13k 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 ...
0
votes
1answer
472 views

Generate PowerPoint based on template with data from csv file?

I'd like to create a simple slideshow, each slide has an image, plays an audio file, and has a title. I have the data in a csv file that looks like this: Hello,aud001.mp3,img001.jpg Any suggestions ...
4
votes
1answer
762 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 ...
0
votes
2answers
4k views

How to force Excel to open CSV files with data arranged in columns

I generate a CSV file with an extension .csv in which every piece of data in one line is separated with a comma: 1,2,3,4 1,2,3,4 The file is sent via email and I want that when a customer opens it ...
42
votes
4answers
28k 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 ...
2
votes
1answer
170 views

Excel Help: Data Input Help

Everyday I download data from a site that will have rows each filled with individual data for clients. I'm able to input the data into excel as a whole but after that I'm having trouble figuring out ...
0
votes
1answer
1k views

How can I import a CSV file into an SQLite table that doesn't allow null values?

I've been using the SQLite Manager extension for Firefox to edit my Chrome web data file in order to restore my keyword searches, and I think I have everything in place except that when I import a CSV ...
0
votes
2answers
3k views

OpenOffice ruined my CSV file - (how to save CSV on Linux with OpenOffice?)

I am running OpenOffice 3.2 on Ubuntu. I had a CSV (comma separated value) file which I had manually created. I opened it in OpenOffice, and entered about 100 items (to make use of using formulas to ...