98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel word powerpoint courses london - CSV or Comma Delimited?
excel word powerpoint courses london - CSV or Comma Delimited?
Resolved · Low Priority · Version Standard
CSV or Comma Delimited?
What is the difference between CSV files, (Comma Separated Values), and Comma Delimited files?
RE: CSV or Comma Delimited?
Answer to the question:
Both are Text files to which your Excel Spreadsheet can be saved, enabling you to share data with non Excel Users. To undertake the task choose File, Save As and from the Save In drop down option choose either Text Delimited or Text CSV.
When you import a delimited Text file, Excel will open the Text Import Wizard enabling you to follow various steps to successfully import the text into a spreadsheet format. However in respect of the CSV file; The Text Import Wizard is not displayed. Instead, the text file is parsed into separate columns, using commas as delimiters.
If you want the Text Import Wizard to be displayed for files with a .csv extension, rename the text file so that its file name extension is .txt.
Note that the file icon type is also different.
Importing and Exporting are covered on the Excel Advanced Course.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Turn off AutoComplete in ExcelYou may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete. |