How do I import data into Excel?

Use the Import menu item to import a text or HTML file that has just enough cells to show the data.

In Excel for Mac 2023 you can also create an Excel list from a text or HTML file.

Click File > Import. Click Import from Text File, and browse to the file that contains the data. Select the columns to import as shown. Do not include any additional blank columns.

If any cells have non-ASCII characters, you may select these cells. Then, in the File Import Options dialog, choose the Unicode (UTF-8) radio button, and then enter the code page number for your computer.

Click OK. You can now work with the imported data. Your work will include whatever was done to each cell before saving and closing the spreadsheet. You cannot undo this operation. Instead, you must import another file if you want to start over.

When you open a text file in the Open dialog, you can create an Excel table by selecting the desired text cells, clicking the Insert tab, and then using the Excel Table dialog to choose columns. A dialog appears asking what should be done with any extra blank rows and columns you need to add. Click OK and the table is created. Do not use tabs or page breaks to organize data or it could be lost in the import process.

Data conversion. Some types of data can be changed from one type to another without losing the integrity of the data. For example, when importing a comma-separated file, if the file contained no blank cells, the data would be treated as if it was already a proper text file. The same thing would happen if data had newline characters. However, if the first cell had a number in it, Excel 2023 recognizes that this represents a currency value, and interprets all the numbers in the column as numbers. Other data conversions are available, depending on the source data.

Importing from other databases. You can import a variety of different databases, such as dBase, Oracle, Access, or SQL Server files. For example, a dBase-formatted file has a lot of information, including names and addresses. It is usually a better option to import a SQL server table that includes an "id" column, a "name" column, and multiple columns that contain different kinds of information. This approach keeps the database relationships intact.

How do I import data from CSV to Excel on a Mac?

I found an easy way to do this using Google Chrome, it's a little slow but that's OK.

Install Google Chrome if you haven't already done so. Search chrome://extensions for any extensions which will work well with importing data from CSV into Excel on a Mac. Search result: Now open up your browser and search for the extension you've installed. You should now be able to view any data in CSV format directly in Excel on Mac and copy it anywhere you need to from there.