MS- Excel 2007 Import and Export Files

MS- Excel 2007 Import and Export Files The Microsoft Office Excel 2007 is one of the most use in our computer program especially in our working offices . Used for any calculations using the worksheets or spreadsheets applications . Each of our computer files with different sources of origin and one from its database program or any reports or records came from your Internet accounts . MS- Excel application has two types of files that can bring either Exporting or Importing the files with the files called . Txt or . CSV (comma separated values).

There are two ways to import data from a text file by using Microsoft Office Excel : You can open the text file in Excel , or you can import the text file as an external data range ( external sets of data : a set of data that is delivered in a worksheet but that originates outside of Excel , such as in a database or text file . Excel , you can format the data or use it in the calculations as you would any other data . ) . To export data from Excel to a text file , use the Save As command .

1. There are two commonly used text file formats:

Delimited text files (.txt), in which the TAB character (ASCII character code 009) usually separates each field of text. Comma separated values text files (.csv), in which the comma character (,) usually separates each field of text.

You can change the separator character that is used in both delimited and .csv text files. This may be necessary to make sure that the import or export operation works the way that you want it to.
You can import or export up to 1,048,576 rows and 16,384 columns.

2. Import a text file by opening it

You can convert a text file that you created in another program to an Excel workbook by using the Open command.
  1. Click the Microsoft Office Button , and then click Open.
  2. The Open dialog box appears.
  3. In the Files of type box, select Text Files.
  4. In the Look in list, locate and double-click the text file that you want to open:
  5. If the file is a text file (.txt), Excel starts the Import Text Wizard.
Follow the instructions in the Text Import Wizard. Click Help  for more information about using the Text Import Wizard or see Text Import Wizard. When you are done with the Wizard, click Finish.

If the file is a .csv file, Excel automatically converts the text file and opens it.When Excel opens a .csv file, it uses the current default data format settings to interpret how to import each column of data. You may want more flexibility in converting columns to different data formats by using the Import Text Wizard. For example, the data format of a data column in the .csv file may be MDY, but Excel's default data format is YMD, or you want to convert a column of numbers with leading zeros to text so you can preserve the leading zeros. To use the Import Text Wizard, you can change the file type to .txt before you open it, or Import a text file by connecting to it.

3. Import a text file by connecting to it

You can import data from a text file as an external data range (external data range: A range of data that is brought into a worksheet but that originates outside of Excel, such as in a database or text file. In Excel, you can format the data or use it in calculations as you would any other data.
  1. Click the cell where you want to put the data from the text file.
  2. On the Data tab, in the Get External Data group, click From Text.
  3. In the Look in list, locate and double-click the text file that you want to import.
    Follow the instructions in the Text Import Wizard. Click Help  for more information about using the Text Import Wizard, or see Text Import Wizard. When you are done with the Wizard, click Finish.
  4. In the Import Data dialog box, do the following:
    Optionally, click Properties to set refresh, formatting, and layout options for the imported data.
    Under Where do you want to put the data?, do one of the following:
    To return the data to the location that you selected, click Existing worksheet.
    To return the data to the upper-left corner of a new worksheet, click New worksheet.
  5. Click OK.

Excel puts the external data range in the location that you specify.
If Excel does not convert a column to the format that you want, you can convert the data after you import it.

4. Export data to a text file by saving it
  1. You can convert an Excel worksheet to a text file by using the Save As command.
  2. Click the Microsoft Office Button , and then click Save As. The Save As dialog box appears.
  3. In the Save as type box, choose the text file format for the worksheet.
     Note: The different formats support different feature sets. 
  4. In the Save in list, browse to the location where you want to save the new text file.
  5. In the File name box, review the name that Excel proposes for the new text file, and change it if necessary.
  6. Click Save.
  7. A dialog box appears, reminding you that only the current worksheet will be saved to the new file. If you are certain that the current worksheet is the one that you want to save as a text file, click OK. You may save other worksheets as separate text files by repeating this procedure for each worksheet.
  8. A second dialog box appears, reminding you that your worksheet may contain features that are not supported by text file formats. If you are only interested in saving the worksheet data into the new text file, click Yes.

5. Change the delimiter that is used in a text file

For a delimited text file, you can change the delimiter from a TAB character to another character in step 2 of the Text Import Wizard. In step 2, you can also change the way that consecutive delimiters, such as consecutive quotes, are handled.
  1. Change the separator in all .csv text files
  2. Click the Windows Start menu.
  3. Click Control Panel.
  4. Open the Regional and Language Options dialog box.
  5. Click the Regional Options tab.
  6. Click Customize.
  7. Type a new separator in the List separator box.
  8. Click OK twice.

Note:After you change the list separator character for your machine, all programs use the new character. You can change the character back to the default character by following the same procedure.

That’s all. “End”








MS- Excel 2007 Import and Export Files Arnel Cartoneros 5 of 5
The Microsoft Office Excel 2007 is one of the most use in our computer program especially in our working offices . Used for any calculati...
Share on Google Plus

About Arnel Cartoneros

Arnel is a Blog creator and writer, A founder and publisher of www.combinebasic.com and www.nuggetro.info. Part time Computer Instructor, Computer And Electronic Technician, And performing job as Biomedical Machine Specialist. I'm an avid fan of social media and very interested in Technical information and innovation.

    Blogger Comment
    Facebook Comment