2
votes
0answers
30 views

Newlines in description of imported csv in Outlook Calander

I have exported a list of birthdays from excel to csv. Now I want to import them in Outlook as calander items. Everything works fine exept I can't do newlines in the desciption. I've already tried to ...
0
votes
1answer
31 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
32 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 ...
2
votes
0answers
684 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 ...
0
votes
2answers
75 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 ...
-1
votes
1answer
45 views

Extract chart data from Word document to CSV files automatically

I have lots of charts in a Word document in docx format. If I click on Edit data, I get an Excel window which displays the data. From there, it's easy to export it to CSV. How is it possible to ...
1
vote
1answer
643 views

Data Validation of a Comma Delimited List

I need a simple way of taking a comma seperated list in a cell, and providing a drop down box to select one of them. For Example, the cell could contain: 24, 32, 40, 48, 56, 64 And in a further ...
0
votes
1answer
60 views

Control CSV import in excel 2010 [duplicate]

I have a csv with values like this: "a very long value, with a comma","387621937291732193" The number, despite being enclosed in quotes gets turned into a number in excel and shows up in scientific ...
-1
votes
1answer
143 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 ...
0
votes
2answers
263 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
86 views

CSV Files - Text Import Wizard - Comma not recognized as delimiter [duplicate]

I have an issue with opening a CSV File in Excel. Every time i open it, i have to run the text import wizard, specify comma as a delimiter and then only i am able to view the file in proper format. ...
3
votes
1answer
403 views

How can I easily split a CSV into two Excel worksheets with PowerShell?

I recently found out that PowerShell can be used to write Excel documents. The first use I thought of for this was to (at least partially) automate parsing of some CSV reports that I regularly have to ...
1
vote
1answer
134 views

How can I auto import a csv to a growing list in excel?

Everyday I receive a report in a .csv format, and on a daily basis I will copy the data into an "INPUT" tab on my spread sheet. The data on this input tab keeps on growing every day with the ...
4
votes
2answers
11k 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 ...
0
votes
2answers
1k views

excel: merging to data sets based on a common field

I have two excel .csv files that have a single numerical field in common, FIELD_A. What I'd like to be able to do is to leverage this common field in order to merge data between the two, so that I ...
1
vote
1answer
302 views

Macro to import CSV file into Excel 2010 without losing leading zeroes or cell formatting

We have a UI based application that exports data out of a form into a CSV file. The data entered may have leading zeroes in some numeric fields and/or text with line feeds in other fields. ...
2
votes
1answer
136 views

Any way to have Excel 2010 treat a quoted value “08540” as text not number when opening a CSV

I have a CSV with data like this: "08540",1,"PRINCETON","NJ" I know that it is possible to specify "Text" when using the Import Wizard and defining columns. But is there a way to tell Excel to ...
1
vote
1answer
115 views

Database workflow advice? [closed]

I've got a product database that I need to update a couple of times a week and am looking for some advice on what workflow I should setup. I can export my database from my online store as a CSV, I ...
0
votes
1answer
224 views

Get unique comma separated values from list of comma seperated values

I have a list of csv in a single cell, and I need to get the unique values from that list and put them in another cell. For example, in one cell I would have: DIV-154, FOD-371, UDL-913, DIV-154 And ...
2
votes
3answers
4k views

Increase size limit of data import from csv into Excel

I have a load of data in a csv file that I'm importing into Excel, most of it is fine, but one of my columns contains up to 1000 characters of data. Unfortunately, Excel has taken it upon itself to ...
2
votes
1answer
2k views

Export Office Excel table to csv using a macro

I'm using Excel Tables in Excel 2010. I would like to quickly export the contents of these tables to *.csv. My current workflow: 1. Select table manually 2. Copy the contents into a new workbook ...
0
votes
1answer
1k views

Set row delimiter in Excel

How can I use row delimiter other than \n? CSV fields contain \n and the row delimiter is \n\n\n\n, to separate line breaks in fields from the row delimiter. I'm using Excel 2010, and in need to ...
3
votes
4answers
4k views

How do I export only visible cells from Excel to CSV?

I am running Excel 2010. At the top of my spreadsheet I have about 10 hidden rows. When I export to CSV, how do I export only visible cells?
0
votes
1answer
4k views

Comma Separated Values in Excel 2010

Comma separated values are shown in my Excel file in a single cell. I tried by changing the following value at Control Panel --> Regional and Language Options --> Regional Options --> ...
0
votes
2answers
2k views

How can I keep leading zeroes in a comma delimited, double-quoted fields csv file when viewing in Excel 2010?

Yes, I've researched the question here, here, and at stackoverflow and I know this seems like a duplicate question. Therefore, I'm making my question more specific: "How can I keep leading zeroes in a ...
29
votes
9answers
51k 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", ...
10
votes
2answers
19k 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?
1
vote
2answers
7k 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 ...
7
votes
2answers
3k 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 ...
2
votes
1answer
4k 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 ...
0
votes
2answers
7k 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 ...
2
votes
1answer
179 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 ...