Tagged Questions

1
vote
1answer
26 views

Trouble opening CSV files in Excel and keeping rows distinct

I have an Excel .csv file that is semicolon separated, but it won't open properly. So I tried a few things: changing language/regional settings, changing the list separator from a comma to semicolon, ...
-1
votes
0answers
31 views

Transport values from another excel document automatically with button

I want to transport an some values copy (B3 in Product.xls) to another excel document (B18 in BI-Sales.csv) in the different cell at a click of a update button. I don't have any idea about excel Vba. ...
1
vote
2answers
26 views

Merge CSV files to one Excel file in different sheets

I want to merge CSV files to one Excel workbook in different sheets. I want each file in one sheet with the CSV file name as sheet name.
-1
votes
1answer
35 views

Possible to move the title of a “group” to another column for each item in the group?

This is related to a question I asked the other day, but I figured out a simpler way to solve it. I have groups of data, as outputted by a spreadsheet program that consists of the following columns: ...
1
vote
1answer
42 views

How to get Excel to interpret the comma as a default delimiter in CSV files?

I have a number of .csv files. Some of them are comma delimited, some are tab delimited (maybe they should be called .tsv ...) The csv extension gets associated with Excel when Excel is installed. ...
0
votes
1answer
18 views

Having formatting problems when exporting table from phpMyAdmin

I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format. ...
2
votes
1answer
61 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 ...
0
votes
1answer
36 views

Unintelligible result opening csv in excel

When I open a .csv file in excel this is what is showing up: Maxtor Encryption ver 2.0.1.1.0 ³§o rkDV’)cÿA®T7B‡LôŠì£\% i¼r1 ØÕë—„×½é¿wjd ´Íâ¿…Öö?HÐ)vM!W«Va<žÒ LåRpµI©ô ...
2
votes
2answers
172 views

Excel CSV import treating quoted strings of numbers as numeric values, not strings

I've got a web application that is exporting its data to a CSV file. Here's one example row of the CSV file in question: 28,"65154",02/21/2013 00:00,"false","0316295","8316012,8315844","MALE" ...
0
votes
0answers
38 views

Using excel to translate product names in a csv file

So I have a product list say in Chinese saved as .csv files along with other data (price, expiry date etc). I import this into an excel workbook which also contains a table that has Chinese to ...
0
votes
0answers
28 views

XML column shows #s instead of the content in Excel, even when exporting as CSV

I have a very large XML file of over 650,000 lines, and when I open it in Excel 2007, some cells (multiple line ones) are shown as a series of #s. When I double click on them the content appears, when ...
0
votes
0answers
158 views

Excel csv encoding default

Ok here's the deal I exported a csv in UTF-16 format via PHP and open it in excel...All the encoding works perfectly. My question is, suppose I edit this csv and then just hit save in excel and ...
1
vote
2answers
846 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
196 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 ...
1
vote
2answers
183 views

Edit csv file with Excel without reformatting

I have some csv data file that looks like this 1,2,3 5,6,7 I open it with Excel 2010, do some change (change some value, delete a column, or anything), and then re-save the file still as csv. But ...
1
vote
2answers
183 views

Open a .csv file in Excel and have it update whenever .csv file changes

Hi I'm working with some web scrapping and the data on my csv files will be constantly changing. I want to open these files on Excel to view and also have it refresh whenever the csv source changes ...
0
votes
4answers
229 views

How to prevent the number increase in the excel for Autofill?

I want my column to look like number 30/31/32/33/34 30/31/32/33/34 30/31/32/33/34 30/31/32/33/34 ...... eg: The content in each cell is 30/31/32/33/34. I want to fill all of the cells in the column ...
0
votes
2answers
62 views

Is there any way of preventing .csv files being converted into excel format

I'm trying to work with an automated testing tool which can use .csv files as its data sourse. After saving a notepad file containing a number of fields and data seperated by commas as .csv it ...
2
votes
1answer
132 views

read excel sheet into jagged array

I am a programmer but recently new to both powershell and vba. I found this simple but effective command in powershell to read in a csv file and you can then immediately access "columns" by their ...
0
votes
1answer
45 views

How to clear up all commas after deleting all the data in CSV in Excel software?

I have this raw item.CSV file: Name,Price,date "item1",10,2012-11-21 "item1",10,2012-11-21 "item1",10,2012-11-21 I open it in Excel, it looks correct: Then I clear all the data except the ...
2
votes
1answer
130 views

CLI program for xlxs -> csv conversion?

Is there an foss command line program that can convert between Excel (.XLXS) and Comma Separated Value (.CSV) files?
0
votes
1answer
253 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 ...
1
vote
1answer
301 views

How to force Excel to treat dates in CSV as text in a macro

I have a macro that lets the user select a CSV file and then manipulates it. However, it treats cells that contain things like 1/2/12 as a date. I need to keep these strings as text, not dates. I ...
1
vote
1answer
318 views

How to plot 3D graphs in Excel from CSV data?

I have data formatted like this in a csv file: a, 1, 4, 6.0 a, 2, 42, 16.0 a, 5, 14, 69.3 a, 11, 4, 7.0 b, 1, 45, 6.0 b, 2, 45, 1.9 b, 9, 2, 4.4 b, 11, 4, 7.9 lines with first parameter a is one ...
0
votes
1answer
77 views

Microsoft Excel maintain formatting when importing

I am using a CSV to import data. The column of data has different and sometimes multiple numbers in one field. For example... 2924,2925, 2926 in one field 2927,2928, 2929 in another field. I ...
1
vote
1answer
116 views

excel truncating phone number

I have a csv file that contains cells such as "+1.8882789780". When viewed in Excel, it loses the last digit possibly due to excel truncation. Is there a way to either change the setting in Excel to ...
3
votes
3answers
788 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
730 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
0answers
115 views

How to setup a CSV web datasource

In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...
0
votes
0answers
181 views

replace comma with colon in csv file

In CSV file all other delimiters are comma except for 1 colon. While saving this CSV, excel replaces this colon to comma. How can I overcome this? or Later how can I replace those particular comma ...
2
votes
2answers
1k views

Compare two spreadsheets and get missing records

I have 2 CSV documents. one has 10.000 rows with 50 columns, first row is a unique SKU. Now I have a second document with 9.500 rows using the same identifiers. I simply want to create a third ...
3
votes
3answers
410 views

Why does Excel 'green tag' random cells in a csv file?

I have two CSV files, test_a.csv and test_b.csv. The green-tag info-box highlights "Inconsistent formula". Why does Excel green tag A4 in test_b.csv? How can I prevent Excel from green tagging my ...
1
vote
0answers
70 views

Creating a script to make a CSV dump usable

So, let's say I have a raw CSV dump. And I want to make a spreadsheet/script to take said CSV dump, take a certain username, and the calls they made, and pipe those calls to a mathematical formula, to ...
0
votes
4answers
1k views

RegEx to Remove CRLF from CSV export from Excel

I exported an Excel File to CSV and do have a lot of multi-lines within. I marked the beginning of each line with * and the end with ###. *** some text within my cell to export ### Could someone ...
2
votes
3answers
896 views

Is there a way to do an inner join in Excel between 2 csv files?

This seems like a simple concept, yet I can't figure out a way to do it without writing some code. Does Excel have a function that will let me join columns from 2 different csv files (say Orders and ...
3
votes
3answers
179 views

Importing from a CSV modifies the number format into scientific notation (1,23E+18)

Suppose I have a following string in a .csv file which I am trying to open in Excel 2010: 1073741824;1073741824;1073751824;1073741832;1152921513196781569 However, when I actually open it, the value ...
0
votes
1answer
109 views

Problems exporting word dashes and quotes from Excel into .csv

I'm trying to export a spreadsheet to a .csv file and when I do, it takes all of the quotes and dashes and they turn into ?'s. I realize it's trying to maintain the Microsoft standard of quotes and ...
2
votes
3answers
4k 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", ...
0
votes
4answers
6k views

How to export selected columns into csv file

I want to export specific number of columns from excel into .csv file. I have around 10 columns like lname, fname, phone, address, email and so on. what should i do to export certain columns like ...
5
votes
2answers
7k 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
424 views

Open CSV file in Excel having leading dash

I have a csv file which looks like this : Ref;Code;OtherData; "MyRef";"-arm";"something"; I think this form is valid, isn't ? When I open the file in Excel, the "-arm" is parsed by Excel as a ...
0
votes
1answer
96 views

CSV - Microsoft office for mac 2008 doesn't add all the commas?

Let's say I have 5 column headings and I only complete the first 2 values. I then save the file as CSV (Windows). It ends up looking like this: ID,Product,Name,Value,Interest 1,PC Which is no good ...
0
votes
1answer
806 views

Cyrillic export from Excel to CSV

I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document. I use Save As » CSV in order to make a CSV file, but it is not ...
1
vote
4answers
3k views

How to write null into csv from Excel for blank fields

How do I write null for blank fields when I export a csv file from Excel 2007? Is there a feature to do that.
2
votes
2answers
3k 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 ...
1
vote
1answer
1k 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 ...
2
votes
1answer
6k 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.
4
votes
3answers
754 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
506 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 ...
1
vote
2answers
3k 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 ...

1 2 3