CSV Files

  • Thread starter Thread starter Susan Govier
  • Start date Start date
S

Susan Govier

Hi,

I want to open a CSV file in Excel, but Excel is opening
it without giving me the option to choose how the file is
delimited/fixed. Are there setting in Excel that I need
to alter to be able to do this?

Any help greatly appreciated.

Thanks
 
Susan,

Change the file extension from csv to txt and use the text import wizard.
This allows you to control the way in which Excel interprets the data.
 

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
text string: "91E10" in csv file auto converts to: "9.10E+11" 2
Open CSV file auto delimites using space not comma 2
.csv Commas ? 2
CSV 5
Import Multiple CSV Files from Same Folder into Open Workbook 5
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 1
Saving double-byte characters as unicode text in a CSV file 4

Back
Top