#1
|
|||
|
|||
Opening the CSV file in the Excel has two different appearances!
Opening the CSV file in the Excel has two different appearances! The CSV shown in screenshot 1 and 2 opened in the Excel in two different format. In the first screenshot all the data is loaded in one column while in the second one the data are categorized in many columns. My question: how to control the appearance of the CSV file to be opened the same way as in the screenshot 2? Why does it appear sometimes as it shown in the screenshot 1? Thank you in advance, Regards Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#2
|
||||
|
||||
There are quite a few different ways to get the data from the CSV file into Excel.
When the data from the CSV file is imported, you may or may not need to tell Excel that it should use a comma delimiter. That is, each time Excel sees a comma in the CSV file, it understands that it has to put the subsequent data into a separate column. If no delimiter is used then Excel will just dump each entire line into the 1st column in the spreadsheet. If you open the file within windows explorer then the comma delimiter will automatically be used so you will get the screenshot 2 result. The same is true if you open the file in Excel by going File > Open. If you import the CSV file by going Data > From Text then you need to be a bit more careful because you have to tell it to use a comma delimiter. The text import wizard will appear -
Does that help? |
#3
|
|||
|
|||
Quote:
The problem that i sometimes get the file open as in screenshot 1 and others as in screenshots 2 knowing that i use the same way to open the file (whether from the explorer or from the File>open in excel as shown in the attached screenshots)! this is why i got confused! same way to open the file but different format obtained! sometimes! what might be behind this behavior? Just in case i get them as in screenshot 1, is there away to have them converted to be like the format in screenshot 2? regards Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#4
|
||||
|
||||
Hi Jamal,
If you're opening the same file using the same method on the same PC, it's pretty strange that the delimiter would be honoured on some occasions but not others. It could possibly be due to the list separator not being set correctly in the Windows regional settings. Quote:
|
#5
|
|||
|
|||
Quote:
That's correct that i use the same method to open the file but not the same computer! for the time being, I'm using my lab top, i'll check the setting of the "List separator" of the windows in the other PC and let you know. is this the only reason for which i got the appearance shown in the screenshot 1? regards Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#6
|
||||
|
||||
Hi Jamal,
Quote:
Quote:
|
#7
|
|||
|
|||
Quote:
Great! It worked like a charm. As you have advised, the setting of the list separator in windows affects the appearance of CSV file when it is opened. Appreciated Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Opening a file with FileDialogFilePicker | ACA | Word VBA | 2 | 08-07-2011 12:43 PM |
Issue when opening word file | msadiqrajani | Word | 2 | 05-27-2011 08:11 PM |
Opening multiple Excel files within the same Excel window. | lost9471 | Excel | 2 | 05-01-2010 01:57 PM |
File gets hanged up while opening in excel 2007 | nvsudheer | Excel | 6 | 06-11-2009 05:47 AM |
Opening MSO-2000 file in MSO-2003 | w77 | Word | 0 | 04-21-2009 03:30 AM |