Microsoft Office is the most popular office suite, used by millions of people around the world. Within this package of applications, we find Excel, your program for making advanced spreadsheets through a user interface in the form of cells. From it we can work through values and formulas that are applied. If we want the files that we generate they cannot be manipulated or modified, they are converted into CSV . In case we receive a CSV file it is possible to convert it into Excel format to be modified, so today we are going to see how we can do it.
CSV files, what are they and what are they for?
A file with CSV format corresponds to the acronym in English of “Comma Separated Values”, which translated into Spanish means something like “values separated by commas” . In this way, a CSV file is a text file which stores the data in the form of columns separated by semicolons and the rows are distinguished by line breaks in the text. That is why CSV files are associated with the creation of tables of contents, so it is usual to read them from Excel , since it is in charge of identifying the separators and forming the table automatically.
CSV files will be of great help to us to handle large amounts of data in a table format, being able to generate a table from a text document by simply delimiting each cell with a semicolon. If we create a file with complete words, values … we can save it as a CSV file. When we open it with Excel, each word separated from the rest by a semicolon is placed in its own cell.
The main disadvantage of working with CSV files is that with these we will not be able to select table formats or colors , to view it once it is opened with Excel. We will have to deal with all these properties directly from Excel once we have our CSV file open. That is, if we have a file created in Excel with columns and colors and we save it in CSV format, when we reopen it with Excel, both the colors and the columns will have disappeared and we will only have the “raw data”.
Convert CSV files to XLS format with Excel
With Excel it is possible to convert CSV files to XLSX format in a few simple steps. The first thing to do is open the program and go to the menu, specifically to the “Data” tab. Now we click on the “Obtain external data” button and within the options that appear, we choose “From a text file”. Next, the browser will open and we must select the CSV file of our computer and click on “Import”.
Once we have selected the CSV file, the wizard to import text appears , where we must mark the “Delimited” options and click on “Next”.
In the new screen of the wizard we must select the separators “Semicolon” and “Other”, where we must write a few quotation marks (“). Later, we activate the option “Consider consecutive separators as one” and finally click on “Next” to continue.
We come to the last step of the wizard where we can select each new column that has been generated and establish the data format on it (General, Text, Date …) and click on “Finish”.
Now we only have to select in the next step how we want to see the data in the workbook , if as a new spreadsheet or an existing spreadsheet and click on “OK” to check that our CSV file has been converted into Excel format quickly and easily.
Websites to convert CSV files to Excel format
On the Internet we can also find some free web pages with which to convert from CSV to Excel format quickly.
Online-Convert
This website offers us the possibility to convert our CSV file (Comma Separated Values) to a file with XML format compatible with Microsoft Excel, quickly. For this we have to select the CSV file that we want to convert. To insert it we can drag and drop the file in the green box, or by selecting the file from our disk, Dropbox or Google Drive. We can also insert it by entering the URL of the page where it is hosted. We can also configure “Optional settings” and click on the “Start conversion” button. Once converted, we can download the file to our computer, download it as a compressed file or upload it to the cloud.
If you want to convert your CSV files to EXCEL using Online-Convert you just have to access their website .
Convertio.co
It is a complete website that allows us to carry out multiple file conversions, among which are the possibility of transferring our CSV files to Excel XLS files . The process is as simple as clicking on the “Select files” button and we indicate to which format we want to convert. We can add the files from our computer, from Google Drive, Dropbox or via URL link. Once loaded, we will click on the “Convert” button and the download button for the converted image will appear.
Convert your CSV files to Excel XLS format with Convertio.co by clicking on this link.
Onlineconvertfree.com
With this website it is a free online converter with which we can convert CSV documents to XSL, as well as a wide variety of formats. To do this, simply select a file from our computer, Google Drive, Dropbox from the “Choose file” button or drag and drop it on the page. We select XLS files or any other format from more than 100 compatible . Later, click on Convert. Once converted, we can download it or share it using a URL.
Convert your CSV files to XSL with Onlieconvertfree.com by accessing their website .
Zamzar
This website also allows the conversion of CSV files to XLS completely free of charge up to a maximum of 50 MB . For this we must click on the button “Add files …” or drag and drop it on the interface. Later we choose the XLS format and click on the “Convert now” button. We can also write our email so that they send us a copy at the end. Once the conversion is finished we can download it to our computer.
To convert CSV files to XLS quickly with Zamzar, just visit their website .
