Comma-separated values: a widely-supported and easy-to-parse rudimentary plain-text spreadsheet which is commonly used for exchanging data between programs
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 ...
