Regarding .CSV files

G

Guest

Generally I have installed with windows XP , when I download and open the
files with extension .csv, all the data gets opened in column A itself, even
though delimeter is specified.

But this works perfectly fine when I select "Save As" option it has selected
"csv". In fact, if I proceed with that and save as csv, and then open the
saved file, Excel works just fine!

What must be problem while opening the file in .csv

Please do suggest as soon as possible
 
D

David Biddulph

If you open the original file in Notepad, what delimiter does it have?
If you open your csv (as saved from Excel) in Notepad, what delimiter does
that have?
What delimiter is specified in Windows/ Regional Options?
What happens if you rename your original csv as .txt, and try to import to
Excel that way?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel CSV Files; Creating Of 3
.csv Commas ? 2
Files saved as csv files are actually saved as text files? 4
Open csv file with Leading Zeros 1
Option for opening Excel .csv in text vs. general 5
CSV Tab Delimited 4
["\r\n" new line command in CSV file] 1
Saving as CSV File 2

Top