How do I always open a CSV file in Excel with columns?

ResRequest sends data as CSV files and these are best viewed in Excel so you probably want to set these files to open automatically in Excel. We’ll guide you through this simple set up to save you time!

Table of Contents Show

Download Workbook
3 Methods to Open CSV File with Columns Automatically in Excel
Method-1: Using From Text Option
Method-2: Using Data Tab to Open CSV File in Excel
Method-3: Open Multiple CSV Files in Excel at Once
How to make Excel open csv files and automatically split the comma delimited column?
How do I convert a CSV file to Excel with columns?
How do I stop Excel from auto formatting my CSV file?
How do I change the default CSV separator in Excel?

CSV files are text documents where the data is separated by a delimiter, or a character used to specify the boundary between fields, such as comma. ResRequest will use a comma to define different fields of data in it’s system but this is difficult to read if you open it in a text editor and so displaying in columns such as Excel makes mapping this data easier to read.

Setting these files to open by default in Excel is simple – let’s get started.

How to set Excel as the default program on a PC

Click on Start in the Taskbar on your Windows desktop.

Choose Default Programs in the left menu.

Click ‘Associate a file type or protocol with a program’.

Scroll through the list of file types until you locate the CSV option, then click it once to highlight it in blue.

Click the ‘Change program’ button at the top of the window.

Click the Microsoft Excel option under ‘Recommended Programs’, then click the OK button.

From the list of ‘Recommended Programs’, choose Excel.

Any CSV file you click to open with now open in Excel automatically. If you don’t want to open it in Excel, right click on the file and choose ‘Open with’ to select a different program.

How to set Excel as the default program on Mac

Right click on the CSV file in your Downloads folder.

Choose ‘Get Info’

Under ‘Open With’ choose ‘Excel.

Click ‘Change all’ and confirm your decision.’

How to set Excel as the default program on Windows 10

Step One: (Windows Key + S) opens up windows search. Search for Control panel. Once it pops up in the search, select it.

Step Two: Select default programs.

Step Three: Select Associate a file type.

Step Four: Scroll down until you find CSV, once you have found the CSV file format on the left-hand side of your screen, you will need to make sure that Excel is selected. If not you, will need to select Excel from the list.

We hope that this will help you to easily open and read all your ResRequest attachment downloads, but please don’t hesitate to contact our

There are several methods to open a CSV file in Excel with columns automatically. Among them, we will demonstrate to you 3 methods to do the task effortlessly.

Table of Contents hide

Download Workbook

3 Methods to Open CSV File with Columns Automatically in Excel

Method-1: Using From Text Option

Method-2: Using Data Tab to Open CSV File in Excel

Method-3: Open Multiple CSV Files in Excel at Once

Conclusion

Download Workbook

Open CSV File.xlsx

CSV File – Book1.csv

3 Methods to Open CSV File with Columns Automatically in Excel

We have a CSV file where the following Employee List table shows Id No, Name, Age and Salary columns. We want to convert this CSV file in Excel with columns automatically by using 3 simple and easy methods. Here, we used Excel 365. You can use any available Excel version.

Method-1: Using From Text Option

In this method, we will use the From Text option to open a CSV file.

➤ First of all, we will open a worksheet in Excel > go to the Data tab > select From Text/CSV option.

➤ After that, we will select our Book1, and click on Import.

Now, we can see a Book1.CSV window appears.

➤ We will select Delimiter as Comma.

➤ Now, we will click on Load > Load To.

An Import Data window will appear.

➤ We will select Existing worksheet > click on the up arrow to give a location > click OK.

Now, we can see the table in the Excel column.

➤ Here, we re-arrange this table by deleting Column1, Column2, Column3, and Column4.

Finally, we can see the table in Excel.

Read More: How to Open CSV File with Columns in Excel (3 Easy Ways)

Method-2: Using Data Tab to Open CSV File in Excel

➤ First of all, we open a blank worksheet > select Data > click on Get Data.

➤ After that, select From File > select From Text/CSV.

Now, our CSV file will appear.

➤ We select Book1, and click Import.

Now, a Book1.CSV window will appear.

➤ We will select Comma as Delimiter > select Load > select Load To.

After that, an Import Data window will appear.

➤ We will select Existing worksheet > click on the up arrow to select the location > click OK.

Now, we can see the table in our Excel columns.

➤ Here, we re-arrange this table by deleting Column1, Column2, Column3 and Column4.

Finally, we can see the table in Excel.

Read More: How to Open Notepad or Text File in Excel with Columns (3 Easy Methods)

Method-3: Open Multiple CSV Files in Excel at Once

In this method, we can open multiple CSV files in Excel.

Here, we want to open 2 CSV files in Excel.

➤ First of all, we will open a workbook > select the File tab.

➤ Then, we will select Open.

Here, we can use the keyboard shortcut CTRL+O to get the Open option.

We will now choose our files from our required folder.

➤ Now, we will choose Text Files > we will choose Book1, and Book2 > click Open.

We will see a Text Import Wizard window appear for Book2.

➤ After that, we will click on My data has headers > Click Next.

➤ We will mark Comma and Tab > click Next.

After that, we can see the preview of the data.

➤ Click Finish.

Finally, we can see the table of Book2 in our Excel columns.

After that, another Text Import Wizard window appears for Book1.

➤ Now, we will select My data has headers, and click Next.

➤ We will mark on Tab and Comma > Click Next.

we can see the Data preview.

➤ After that, we will click on Finish.

Finally, we can see the table in Excel columns.

Read More: Excel VBA to Read CSV File Line by Line (3 Ideal Examples)

Conclusion

Here, we tried to show you 3 methods to open a CSV file in Excel with columns automatically. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, feel free to know us in the comment section.

How to make Excel open csv files and automatically split the comma delimited column?

Using the "From Text" feature in Excel Select the CSV file that has the data clustered into one column. Select Delimited, then make sure the File Origin is Unicode UTF-8. Select Comma (this is Affinity's default list separator). The preview will show the columns being separated.

How do I convert a CSV file to Excel with columns?

Steps to convert content from a TXT or CSV file into Excel.

Open the Excel spreadsheet where you want to save the data and click the Data tab..

In the Get External Data group, click From Text..

Select the TXT or CSV file you want to convert and click Import..

Select "Delimited". ... .

Click Next..

How do I stop Excel from auto formatting my CSV file?

In the "Data preview", scroll to the far right, then hold shift and click on the last column (this will select all columns). Now in the "Column data format" select the radio button "Text", then click "Finish".