View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Import .csv files to Excel

Does that mean each record in the .csv file goes into column A (A1, A2, ...,
A#)?

Or does this mean that all your data really go into A1?

If the data goes into separate rows in column A, verify that the list separator
that you specify in the control panel

Regional settings And language options|Regional options tab
customize button|Numbers tab

matches the delimiter used in the .csv file (use notepad to verify)

===
If all the data really goes into A1, then maybe there's a problem with the end
of line marker and the list separator???

HughP wrote:

When attempting to import a .csv file to Excel all of it gets dumped in cell A1
--
Hugh


--

Dave Peterson