0
votes
1answer
23 views

Importing multiple CSV files

I have to run a daily stock analysis where I pull multiple .csv files, and then have to go through an annoying task of deleting unnecessary fields from the .csv's. Only then can I start compiling the ...
0
votes
1answer
21 views

Excel - Find a specific column in a CSV file, and copy to the current sheet

I get a regular data export in a CSV format, which I like to pull into excel and report on via helper columns and pivot tables. I do this by linking to the csv file, and copying the cell contents ...
0
votes
1answer
27 views

CSV File saving as Creo Pro Versioned File

This is an odd one, I'm saving an Excel file as a CSV file, which is the required format I have to send this data in as. However when I save the file, it shows in the Directory as a Creo Pro Versioned ...
1
vote
3answers
39 views

Excel: How to skip specific rows when importing a CSV

I want to skip the header and last rows when importing a CSV into Excel, just like I can skip specific columns. Is there a way to do this?
0
votes
1answer
37 views

Postbox/Outlook 2013: Strange Contact Import Behaviour

I'm experiencing a very strange error with regards to importing contacts that were exported from the Postbox 3 address book. The CSV file itself is fine - everything maps out nicely in Excel, but ...
1
vote
2answers
38 views

Changing DateTime format in multiple CSV files

I've got multiple csv files with this structure: text, text, 01/27/2001 01:00:00 PM I need to update ALL csv files with this datetime format: text, text, 27-Jan-2001 13:00:00 Is there a known ...
2
votes
2answers
40 views

Best way to search for a string (text) in >10 large CSV files (250mb each)

I am wondering what's the best way or tool to search for a specific text or string in more than 10 large .csv files. Each file is 250mb in size. My idea was to write a powershell script, since I ...
0
votes
1answer
17 views

Open .csv file with template from XLSTART

I'm testing the program which would create a large .csv file and need to open it with minimum clicks (saving my hands) during testing. The file contains 20+ columns of counters, no formatting ...
1
vote
1answer
23 views

excel grid to columns

I have data in an array/grid like this: Name | Group | A1 | A2 | A3 name1 | Group1 | 14.95 | 19.95 | 0.00 name2 | Group2 | 4.95 | 9.95 | 12.95 name3 | Group2 | 49.95 | 0.00 | 0.00 And I need a way ...
0
votes
0answers
63 views

How to make my loop omit empty Excel cells while converting to .csv - Powershell

I have some empty cells in my Excel worksheets.How to make a proper statement to make my loop omit them? I tried to do a if(){}else{} loop but it doesnt work properly.I have a powershell v2 so I ...
0
votes
1answer
30 views

CSV compabtility issue in excel

I download a .csv from database and use the file to generate a PDF using a PDF conversion service. However, for specific files, the conversion fails and the request times out. I checked the file type ...
0
votes
1answer
29 views

Excel 2010- long number corruption

I have a set of data, received in .csv format, in which I have a set of long UPRN numbers. I am involved in data matching processes related to new IER voting regulations. When I open the .csv file the ...
0
votes
1answer
18 views

excel 2010 is appending a space to the end of currency field when saving a csv file

Create an Excel spreadsheet with one cell. Put "$1,234.56" (WITHOUT the quotes) in the first cell. Save it as test.csv. Open test.csv file in a text editor, Notepad.exe will work. The file contains ...
1
vote
2answers
118 views

Excel save-as CSV options — possible to change comma to pipe or tab instead?

Is there a way to tell Excel which delimiter to use when producing a CSV, e.g. tab or pipe?
0
votes
3answers
58 views

Excel - take two csv files and map them

I have two csv files. 1 has a list of emails, another has a longer list of emails with first names, last names, address, etc. What I am looking to do is take both of these files and map the emails ...
0
votes
0answers
22 views

How do I change the EOL character when importing a CSV file into Open Office Calc?

I've got a CSV file that has enclosed newline (\n and \r, mixed) characters in its data. Because the consumer of that file is not able to handle that correctly (out of my control) we decided to use ...
0
votes
1answer
114 views

Using multiple data sources in a scatter graph

I have a script that runs something in a loop and writes its duration into a .csv file on a share. The file looks like this: "timestamp","duration","ComputerName" "7/8/2014 2:56:03 ...
1
vote
1answer
36 views

Excel column headers export to csv

Just wandering how I can export excel files to csv while retaining the multicolumn headers? I realize that csv does not support this however, I'm hoping that I can have the header name duplicated for ...
1
vote
2answers
47 views

How to convert a Excel row to a single csv text cell (inverse of "Text to Columns)

I have a POS program that allows me to import stock items from a csv file. The problem is that it only accepts a certain csv format. I have a Excel spreadsheet that saves my stock in different ...
0
votes
1answer
45 views

What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?

I have a .csv file which was exported from a proprietary electronic health records database system. I was a subscriber to their service but upon ending my subscription this is how I get to keep my ...
0
votes
2answers
101 views

Exporting CSV file to VCF

I got a CSV file on Excel/Open Office and would like to import them on my iPhone but is proving an almost impossible task. Some people suggested to send the file to myself via e.mail but, when ...
2
votes
0answers
571 views

IE9 not prompting to save downloaded CSV file, opens in Excel

I am accessing a website that generates CSV files when I click a "download" link. Instead of prompting to "save or open", IE 9 is going right ahead and trying to open the returned file in Excel. Since ...
2
votes
1answer
87 views

What is the “sep=” metadata you can adds to CSVs?

While trying to find out how to get CSVs to open correctly in Excel on a Spanish PC (belonging to a customer) I found many answers recommending using sep=, at the top of the file: Easiest way to ...
0
votes
2answers
64 views

Make a formula column for a column in an external data (csv) sheet - How to extend to proper number of rows?

I have an excel file that relies on an external CSV file which I reload from time to time. The csv is loaded into a sheet and a different sheet is used to perform calculations. My question is - How ...
-5
votes
2answers
268 views

How do I convert a .csv file to a database?

I have an 8GB .csv file with 6 columns and 202,176,000 rows. How would I convert that to an OpenOffice database(.db) file?
0
votes
2answers
65 views

How to open CSV file with Russian Excel?

Comma is used as decimal separator in Russian locale. This is probably the reason, why Russian Excel is unable to open CSV files: As you see, all data went to first column.
0
votes
1answer
41 views

Can I create a cell with enumerated values in a csv file

Can I create a cell with enumerated values in a csv file? For example, I want a cell that can only get the values: a) "value1" b) "value2" c) "value3" Is this possible? PS: I have used this ...
0
votes
2answers
164 views

CSV File Import Error - Question Marks / Brackets Everywhere

I have a few .csv files that were sent to me, but when I try to import them either as .txt files or as .xml files I only get blocks of question marks (?) and brackets (CONTENTS) of the type that would ...
0
votes
1answer
105 views

Importing an excel sheet with many empty cells into R

I have a big excel sheet that have lots of empty cells. I'd like to import it in R. I'm fine if in R, all the empty cells are replaced by "NoData". Replacing all empty cells by "NoData" on Excel and ...
1
vote
1answer
971 views

Excel How to make Text Qualifier editable or add a new entry in the existing list?

I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote. Example: "col1","col2","col3" ...
0
votes
2answers
298 views

Can MS Excel use non-printable characters as field separators in CSV files? If so, how?

I've just discovered that many of the character encodings have non-printable characters designed to separate different pieces of information, e.g., ASCII character 31 is the "unit separator". It ...
3
votes
2answers
1k views

Unix command to get number of lines in a CSV file

I have to get the count of lines from incoming CSV files. I have used the following command to get the count. wc -l filename.csv Consider files coming with 1 record I am getting some files with * ...
0
votes
1answer
315 views

Run Command to open csv file in excel

My first question on the site, so hopefully I'm doing this right. I use file juggler on my windows machine. The program can watch for new files and trigger run commands. When a new csv file arrives ...
2
votes
1answer
104 views

Excel inconsistent date conversion

I'm running Excel 2007. I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: ...
0
votes
2answers
487 views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
2
votes
1answer
438 views

Reversing Excel's Text Import Wizard for CSV Export

I have a CSV file that I want to import to excel, edit, and save back as CSV. The problem that I encounter is with Text Import Wizard: I open a new Excel file, then Data > From Text, and in The text ...
0
votes
1answer
680 views

Deleting entire row in excel if missing data in certain column or columns?

I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...
0
votes
1answer
743 views

Disable prompts in Microsoft Excel when saving a CSV file [duplicate]

I have to download multiple csv reports from the Internet throughout the day, make a tiny change to them, and save the change. Excel adds 3 completely unnecessary dialogs to what should really be a ...
-1
votes
1answer
136 views

Invalid date value in csv file

I export data in csv format from sql server database. It contain 5 column. one column have date and time value. When i checked the date -time value i found date time value is in wrong format. I add ...
2
votes
3answers
334 views

How to help Excel parse my CSV automatically

I'm generating CSV files from a script and then want to look at them with Excel. I noticed Excel does a smart job of identifying money (by the $) and dates, and formats those cells accordingly. ...
0
votes
1answer
309 views

Macro to Import CSV files into Excel

I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the 'Import from Text' tool by typing the name of the file into a cell. I then need to format all of the data ...
1
vote
0answers
206 views

Get rid of warning for external data connection

In Excel 2011 for Mac, I'm using an external data link to collect data from a CSV file generated by a third party application. The CSV is continuously filled, so I want to update the data every time I ...
1
vote
1answer
196 views

How to convert two columns into one column of CSV?

This is how my columns currently look now. They are two columns, with each column having a name. I want something this, as shown below in the expected section, for better processing of a parsing task. ...
0
votes
0answers
63 views

Merge CSV files with Excel

Every day, I run a report that generates a .csv file of items that need to be purchased for the company that I work for. The fields look something like this: ...
0
votes
2answers
242 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
0answers
78 views

Is there a text file format that Excel supports opening and saving directly?

I want to edit simple table data in Excel 2010, which is to be stored only in a flat text format (i.e. not a binary format like XLS or XSLX) which is viewable with notepad and can be read by a simple ...
1
vote
1answer
2k views

Semicolons when creating a CSV file instead of colons

When creating a CSV file from an XLSX workbook with the new Excel for Windows 8, I get a file filled with semicolons instead of colons. How can I change that? I even had to reopen the file with ...
0
votes
1answer
37 views

Adding the date/time (DD/MM/YY HH:MM) information dynamically at the end of ZIP file

I want to add the current date/time (DD/MM/YY HH:MM) information dynamically at the end of ZIP file when backing daily via IBM cognos export. Then How can I export CSV formatted them using script? ...
1
vote
1answer
542 views

Can I output results of a MySQL query to a csv file via Putty?

I've typed the following code to output the csv file , but it shows an error mysql> SELECT *INFO OUTFILE 'd:/student.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY ...
0
votes
1answer
124 views

Excel fails to open Python-generated CSV files

I have many Python scripts that output CSV files. It is occasionally convenient to open these files in Excel. After installing OS X Mavericks, Excel no longer opens these files properly: Excel doesn't ...