Tagged Questions

Comma-separated values: a widely-supported and easy-to-parse rudimentary plain-text spreadsheet which is commonly used for exchanging data between programs

learn more… | top users | synonyms

2
votes
2answers
44 views

Merging columns in Excel with “;” separator

I'm new here and I hope to seek for your assistance on converting data format of my excel to csv. This is my raw data in excel in different row and cells: A B C D E F 1 2 3 4 5 6 ...
0
votes
2answers
50 views

Notepad++/Regular Expression to find line with same beginning, different ending

So, I've read a bit and found NotePad++ doesn't use "normal" regex (starting to think I'll just go back to SciTE), but here's my question: I've got an exported list of data with some redundant data ...
1
vote
1answer
52 views

Excel: change data source with macro

I'm using a CSV file (generated by a thing party program) as an external datasource, and I'd like to change its path from a macro... How can I do that ? Another acceptable answer to my problem would ...
1
vote
1answer
84 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.
2
votes
3answers
51 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 ...
0
votes
2answers
54 views

How to export file from excel (or other excel like software) to .CSV

I have 2 questions Question 1. Why is it when I try to export to csv file from excel 2007 I get a file that has a type of "Microsoft Office Excel Comma Separated Values File (.csv)"? I choose "Csv ...
0
votes
2answers
66 views

Export to CSV From Excel

I frequently use Excel to prepare data to load into a table. I create a CSV file from it and use that file for data loading. I generally find myself creating the CSV file multiple times. My current ...
0
votes
1answer
41 views

how to plot data from csv file?

I'm looking for a way to plot data imported from a .csv file much like the pivot chart view of an Microsoft Access table. I'm just having problems with Microsoft Access 2010 and was wondering if ...
0
votes
1answer
28 views

Export google document as csv without quotation marks

I have a google document spreadsheet that I want to export as csv. The problem is, that some cell get their content included on quotation marks: 1,1,"I don't want quote",Mee too but I'm lucky,1 To ...
0
votes
0answers
63 views

Importing a CSV table into Libreoffice Base

I'm trying to import a large CSV table into a Libreoffice Base database. From a google search it sounds like the way to do this involves opening the CSV in calc, select all + copy, paste into Base. Is ...
1
vote
0answers
36 views

Use one csv file to delete duplicates in another one

Basically the title says it all. I have a csv list that includes one e-mail address per line (and some other stuff). I want to seek those email addresses in a different csv file (also with 1 mail ...
1
vote
1answer
63 views

Change line endings and delimiter format (permanently) when saving to CSV from Excel

I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to "," Is ...
0
votes
1answer
43 views

User Friendly CSV to MSSQL import with column match

Hi before I reinvent the wheel I'm trying find something to allow a user to take .csv files and graphically match the columns in the database table to the columns in the csv file. I know this can be ...
2
votes
2answers
117 views

How to break a spreadsheet containing CSV into multiple columns?

I'm working on preparing data for export, and the client has put all of the data into a spreadsheet. Each field of data should be its own column. The problem is that the client erroneously put ...
0
votes
1answer
96 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
61 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
58 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
0answers
40 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
174 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. ...
0
votes
2answers
111 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
15 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
76 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
66 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
1answer
74 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?
2
votes
1answer
150 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
124 views

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

Excel always says ...may contain features that are not compatible with CSV when saving CSV files. Can this be disabled, specifically in Office / Excel 2011 on Mac?
0
votes
1answer
46 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 ...
1
vote
0answers
48 views

Searching a CSV or Excel file for terms from one column of another Excel file [closed]

I have a column of data in an Excel file. I want to use it to search the contents of another CSV or Excel file and return / highlight all of the matches. How can I do that using Google Docs, Open ...
3
votes
6answers
99 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 ...
0
votes
0answers
28 views

Automated Emailing Application [closed]

I'm looking for a solution that will enable me to automate/schedule an email to individuals listed on a CSV file. I want to be able to embed data fields from the CSV into the message. In other words, ...
2
votes
1answer
92 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 ...
0
votes
1answer
167 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). ...
2
votes
2answers
256 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
87 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
0answers
101 views

Excel 2010 Get External Data with a carriage return

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 ...
1
vote
2answers
90 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 ...
1
vote
2answers
108 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 ...
0
votes
0answers
95 views

csv file utils on linux besides csvfix that can work on large csv file

besides csvfix, is there a utility on linux that allow me to various manipulation of csv file including counting the number of rows?(note this is not trivial since each row can span multiple lines in ...
4
votes
1answer
203 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
68 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
75 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
81 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
1answer
92 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
125 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 ...
5
votes
3answers
2k 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
120 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 ...
4
votes
1answer
156 views

Copy value in Open Office Calc

I have a handful of cells in several spreadsheets that contain "=AVERAGE()" and when I try to copy them into another spreadsheet I just copy the function and get "#REF!" Is there anyway to copy ...
1
vote
1answer
138 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
177 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
833 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 ...

1 2 3