How to Import or Convert CSV Files to Excel or Google Sheets step by step?

Excel is a spreadsheet that allows users to create tables and formats that include mathematical calculations using formulas; which can use mathematical operators such as addition, subtraction, multiplication, division, graphs, tables and any necessary mathematical operation, in short it is a complete tool when making calculations and tables.

The CSV format it is very simple and does not indicate a specific character set, nor how the bytes are located, nor the format for the line break. These points must be indicated many times when opening the file, for example with a spreadsheet. The CSV format is not standardized.

The basic idea of ​​separating the fields with a comma is very cleara, but it gets tricky when the field value also contains double quotes or newlines, CSV implementations may not handle that data, or use quotes from another class to wrap the field.

But this doesn’t solve the problem: some fields need to embed these quotes as well, so CSV implementations can include characters or escape sequences.

CSV is a common format for storing and transmitting content, including contacts, calendar appointments, and statistical data. But what if we told you that this type of file could be imported into Excel that would make things easy.

Excel reads these files by default, but in most cases, when you open a CSV file in Excel, you see encoded data that is impossible to read.

Not all the documents you need to open are in Excel format. Sometimes you get comma separated value (CSV) files. Other tabular data or even plain text files. Fortunately, Excel handles those file formats very well, In addition, with Excel we can block spreadsheets as a protection tool.

Excel contains some very useful functions for importing other types of files and turn them into spreadsheets you can work with. It is especially good with these types of files.

How to import CSV files to Excel?

Import into Microsoft Excel

1. Open Microsoft Excel.
2. Start / open a blank spreadsheet / workbook.
3. Select the tab Data on tape.
4. Select the From Text option. (If the options are grayed out, you may need to open a new worksheet / worksheet.)
5. The text import wizard will open.
6. Make sure the delimited option is selected. Click on the Next button.
7. Select Comma under Delimiters. The text qualifier should show “(double quotes).
8. Click on the Finish button.
9. You may be asked, Where do you want to put the data? Click in the upper left cell.
10. Click on the OK button.
11. Excel will display the data in your workbook.

How to import multiple CSV files into Excel?

• As you probably know, Microsoft Excel allows you to open multiple CSV files using the Open command.
• Click File> Open and select Text Files (* .prn, * .txt, * .csv) from the drop-down list in the lower right corner.
• To select adjacent files.
• Click on the first file, press and hold Shift key and then click on the last file.
• Both the selected files and all intermediate files will be selected.
• To select multiple non-adjacent files, press and hold tecla Ctrl and click each .csv file you want to open.
• With multiple CSV files selected, click the Open button.

How to import into Google Sheets?

This method is simple and fast and we could call it perfect, but for a small part, it opens each CSV file as a separate Excel workbook.

• Open an existing sheet in Google Sheets or create a new sheeta.
• Select File from the main menu, then Import.
• Select the Upload tab.
• Choose one of the options under Import Action.
• Click the Import button.
• Google Sheets displays the data on your sheet.
• Whether you are working with csv files or other text-based information.
• Excel can convert it into a usable format in your workbook.
• Syou just have to know which buttons to press.