How to Import, Export or Convert Text or Data Files to Excel

como exportar datos de texto en excel desde la pc

How to Import, Export or Convert Text or Data Files to Excel

Excel is a Spreadsheet that is integrated into the Microsoft Office suite. Thanks to your ease of use and powerful tools calculation, is widely used by students and professionals around the world.

Due to the numerous set of formulas that it brings, it is very useful to do work where calculations are required, since it will allow you to have considerable time savings and thus you can obtain very precise results, also, it is ideal for making basic graphics. Its formulas are grouped according to the following categories: financial, mathematics and trigonometric, statistics, database, among others.

When a job is done in this program, when it is automatically stored it is saved in the default format that will only be recognized by Excel. Nevertheless. When storing it, a specific format can be established in such a way that the information can be recognized by other applications.

Instructions to export Text files in Excel

This option is widely used by Software Developers because it allows converting the information to a universal Text format which is recognized by practically all Programming Languages, so here, we show you the steps you must execute to be successful in this task.

Read This Now:   How to Format Windows 10 - Navigaweb.net

The first step you must follow is to enter the program and create a new document, if you already know the basic formulas and functions that the program has, excellent. Next, you must save your document and for this, you have to go to the top left of panel and look for the File option, where you must place Save as.

Doing this will open Windows Explorer, so you will have to find the location to save your file. Being there, you will locate the box that says Type and you can observe all available formats.

Next, you must take the option enclosed in the box “CSV (delimiter by commas)”, click on “Save”And the document will be saved in a plain text file as they are also called.

It should be noted that after performing these steps, the name of the originated file will end with the extension “csv”. Also, this generated text will only contain the numerical and text information.

So all the ornaments that the table had (borders, font, bold, formulas) will disappear, that is why it is important to first save the information in the default Excel format and then export the information, that way we will have the 2 versions of the data.

Read This Now:   How to Send a Telegram Video to a WhatsApp Contact - Share Multimedia

On the other hand, it can be seen that Excel uses the “,” sign as a separator between one cell and another when converting the file. This sign will indicate the different Programming Languages the beginning and end of each of the cells. In this way, the Database that we are feeding with this data will interpret the beginning and end of each of the Fields that constitute it.

way to import text files from excel office program

The correct way to import Text files into Excel

Now that you know the ideal formula to export files from the Excel program, it is important that you learn how to import them correctly. Since, any Text file can also be imported without any problem.

  • To do this, you must choose the “Open” option and then you can proceed to click on the arrow pointer that appears next to the box that says All the files.
  • Next, a window will be displayed showing all the types of files that can be opened with Excel. There, you will select the option shown in the “Text Files” box.
  • When you do this, only the files that meet the condition of being “Text Files” will be shown in the window, so you will have to select the one you want to open, by clicking “Open” to display the information stored in that file.
Read This Now:   Why isn't Photoshop working on a Chromebook PC? - How to solve it

Once the information from a Text file is imported, we can use all the possibilities that Excel offers us. We can change the fonts of the letters, place special effects, borders, colors, do any type of calculations using the different formulas available.

Likewise, we tell you that you can perform all these steps if you have a Samsung Galaxy mobile device, downloading Office in Spanish.


Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /home/gamefeve/bitcoinminershashrate.com/wp-includes/functions.php on line 5373

Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /home/gamefeve/bitcoinminershashrate.com/wp-includes/functions.php on line 5373