All Questions
Tagged with microsoft-excel csv
495
questions
5
votes
1
answer
8k
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 ...
5
votes
1
answer
8k
views
How to export Excel with Hindi script to CSV file?
I would like to know how to export an excel spreadsheet which contains, say a table of Hindi(for that matter any non-english) script words into a CSV file? I tried 'Save As' --> comma delimited, but ...
5
votes
0
answers
255
views
Excel 2007 doesn't preserve asian characters when converting to csv [duplicate]
I am trying to save a spreadsheet as a CSV file. The file consists of korean characters, and the resulting csv has those characters literally converted to question marks (0x3F).
I am running on an ...
5
votes
3
answers
7k
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 ...
4
votes
2
answers
1k
views
How do I keep values the same when converting from XLSX to CSV? Export to CSV with expanded numbers and not scientific notation?
I have an XLSX file which I am opening with Excel 2016.
This file includes a column "Code" which contains barcode values. The column has a number format of General.
Looking at this column, ...
4
votes
3
answers
8k
views
Converting a .txt file with tab as separators into a excel spreadsheet
I have lines of data in a text file where each entry is separated by tab. I want them in different columns and each line to form a separate row in Excel.
I tried using Data > Import but it all ...
4
votes
2
answers
5k
views
Excel Does Not Parse Quoted String containing comma in CSV File Correctly
I have a CSV file that with quoted string that contains comma. When I open it in excel it still uses the comma inside the strings and parse it in different columns. Can someone help?
T7, 7, "331-8463 ...
4
votes
4
answers
7k
views
How to parse Wikipedia lists' source to a .csv file?
I was answering this question when the need arose for a good presentable data set. I settled for using random things but my first thought was to use a Wikipedia list, such as this List of longest ...
4
votes
2
answers
32k
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 ...
4
votes
2
answers
17k
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 ...
4
votes
9
answers
179k
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 ...
4
votes
4
answers
5k
views
Export to csv options using Numbers
I'm using Numbers on my Mac at the moment and exporting to a CSV file. Is there a way to enclose every value with ""?
For example I'm getting the csv file like this:
1,2,3,4,5,6,7,8,9
When I want ...
4
votes
3
answers
9k
views
Convert Large HTML Table to CSV
I've got some data (basic personal details) which I need to export from an old legacy system to a newer system (MySQL DB). It's approximately 200MB split across 6 files.
The system I'm exporting from ...
4
votes
2
answers
3k
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 ...
4
votes
3
answers
13k
views
How to save double quotes and semicolon in a csv file while opening the file in excel 2010?
I receive a CSV file from sever. The data inside it is delimited by semicolon and it is in UTF-8 format.
For example, the data what we receive is:
"NL 我喜"" mutilple""我喜"
When we open it for the ...