How do you you import a csv file into Excel?

Answer 1

Version 2003 and Prior: 1. Select from dropdown: Data; Import External Data; Import Data… 2. Navigate and select the file to import (make sure "Files of type:" is listed as "All Data Sources"), 3. On the prompt that comes up leave "Delimited" selected and hit Next, 4. On "Delimiters" select "Comma", 5. Finish Version 2007: 1. From Ribbon: Data, Get External Data, From Text, 2. Navigate and select the file to import (make sure "Files of type:" is listed as "All Data Sources"), 3. On the prompt that comes up leave "Delimited" selected and hit Next, 4. On "Delimiters" select "Comma", 5. Finish

Answer 2

In Excel - Choose File, Open Use the "Files of type" drop down menu to switch to All Files Browse out to find your file, it will most likely have an Excel Icon already on it. Choose Open Excel will guide you through steps to make the CSV data appear how you would like it to in Excel

Answer 3

Reading CSV files that have embedded double quotes, commas and can include embedded line breaks is a complicated concept. I have chosen to write a regex pattern that can handle parsing the fields of a CSV with all those conditions. There are plenty of other examples of CSV parsers around, but none seem to do the trick I was looking for, which is grandly frustrating when Excel can import and export a CSV with all the listed nuances quickly and easily. So, not finding a good solution, I have written a short CSV parsing pattern. It is below. CSV-parser ^(("(?:[^"]|"")*"|[^,]*)(,("(?:[^"]|"")*"|[^,]*))*)$ Options (turned on in your language/utility): ^ and $ match at line breaks Description: below is a textual description of the regex pattern that may be helpful to programmers who want to understand what is happening in the regex. You can find all the details on this at the blog to which this was originally posted at: http://www.kimgentes.com/worshiptech-web-tools-page/2008/10/14/regex-pattern-for-parsing-csv-files-with-embedded-commas-dou.html

Answer 4

1. From Ribbon: Data, Get External Data, From Text

2. Navigate and select the file to import (make sure "Files of type:" is listed as "All Data Sources")

3. On the prompt that comes up leave "Delimited" selected and hit Next

4. On "Delimiters" select "Comma"

5. Finish

Answer 5

If document means workbook, you open it the same way you open a file with any other Windows or MAC program. If document means a word processing file or some other file, it would depend on the type of document you are trying to open.

(If this does not answer your question, ask again with more specific words indicating exactly what you want to know.)

Answer 6

File > Open then click on the filename you want to open.