You are viewing the article How to Open CSV File at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 4,337 times.
CSV (Comma-separated values) are files that contain data from tables listed in plain text, such as email contact information. Although CSV files can be opened by many programs (such as editors), the data inside this format will be most fully displayed in spreadsheet software, such as Microsoft Excel, OpenOffice. Calc or Google Sheets (Google Sheets). You will need to select “Open” from the “File” menu, select the CSV file, and adjust the delimiter settings if the data is not displaying properly. The same steps are applicable on Google Sheets, but this requires you to upload the file to the Google servers. The working process will go more smoothly if you organize your data neatly and scientifically!
Steps
By Microsoft Excel
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/92/Open-CSV-Files-Step-1-Version-2.jpg/v4-728px-Open-CSV-Files- Step-1-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/92/Open-CSV-Files-Step-1-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-1-Version-2.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:” <div class=”mw-parser-output”></div>”}
Launch Microsoft Excel on the computer.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/86/Open-CSV-Files-Step-2-Version-2.jpg/v4-728px-Open-CSV-Files- Step-2-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/86/Open-CSV-Files-Step-2-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-2-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the “File” menu and select “Open” in the upper left corner. A file browser window on your computer will open.
- You can also press Ctrl + O (Windows) or ⌘ Cmd + O (Mac) to perform the same action.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/66/Open-CSV-Files-Step-3-Version-2.jpg/v4-728px-Open-CSV-Files- Step-3-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/66/Open-CSV-Files-Step-3-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-3-Version-2.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:” <div class=”mw-parser-output”></div>”}
Select the CSV file and click “Open”. The file will open and display in the new Excel workbook.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/44/Open-CSV-Files-Step-4-Version-2.jpg/v4-728px-Open-CSV-Files- Step-4-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/44/Open-CSV-Files-Step-4-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-4-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the “Data” tab to access the “Text to Cpumns” wizard (optional). If Excel displays the entire text of the CSV file in one column, this option will help the program analyze the data better. The Data tab is in the top menu bar and will display a data-specific set of options.
- If you only want to split into certain columns, click and drag the mouse pointer to highlight the columns to split.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fd/Open-CSV-Files-Step-5-Version-2.jpg/v4-728px-Open-CSV-Files- Step-5-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fd/Open-CSV-Files-Step-5-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-5-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click on “Text to Cpumns”. This is one of the options located in the data tab, after clicking on it the “Text to Cpumns” wizard will open.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/53/Open-CSV-Files-Step-6-Version-2.jpg/v4-728px-Open-CSV-Files- Step-6-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/53/Open-CSV-Files-Step-6-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-6-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Select “Delimited” and then click “Next”. The delimiter sets the boundaries between data points in the text file (comma in this case). [1] X Research Source
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9a/Open-CSV-Files-Step-7-Version-2.jpg/v4-728px-Open-CSV-Files- Step-7-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9a/Open-CSV-Files-Step-7-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-7-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Select the “Comma” check box and click “Finish”. All text previously separated by commas will be separated by columns. [2] X Research Source
By OpenOffice Calc
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5e/Open-CSV-Files-Step-8-Version-2.jpg/v4-728px-Open-CSV-Files- Step-8-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5e/Open-CSV-Files-Step-8-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-8-Version-2.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:” <div class=”mw-parser-output”></div>”}
Download and open OpenOffice Calc . Select your operating system from the drop-down menu and then click “Download”. Launch the installer and select The OpenOffice office product that you want to include in the installation. The only product you need to open CSV files is OpenOffice Calc.
- OpenOffice is free software.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/ce/Open-CSV-Files-Step-9-Version-2.jpg/v4-728px-Open-CSV-Files- Step-9-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/ce/Open-CSV-Files-Step-9-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-9-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the “File” menu and select “Open”. This menu is in the upper left corner and will open a file browsing window on your computer.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/75/Open-CSV-Files-Step-10-Version-2.jpg/v4-728px-Open-CSV-Files- Step-10-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/75/Open-CSV-Files-Step-10-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-10-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Select the CSV file and click “Open”. The file will open in the OpenOffice Calc spreadsheet program. [3] X Research Sources
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a5/Open-CSV-Files-Step-11-Version-2.jpg/v4-728px-Open-CSV-Files- Step-11-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a5/Open-CSV-Files-Step-11-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-11-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the “Data” menu and select “Text to Cpumns” (optional). If OpenOffice Ccalc doesn’t split the data properly then you can manually set the delimiter [4] X Research Source . The Data menu is located in the top menu bar.
- If you only want to split into certain columns, click and drag the mouse pointer to highlight the columns to split.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/40/Open-CSV-Files-Step-12-Version-2.jpg/v4-728px-Open-CSV-Files- Step-12-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/40/Open-CSV-Files-Step-12-Version-2.jpg/ v4-728px-Open-CSV-Files-Step-12-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Select the “Separate By” radio button. This option is located below the “Separator Options” heading.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/02/Open-CSV-Files-Step-13.jpg/v4-728px-Open-CSV-Files-Step-13. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/02/Open-CSV-Files-Step-13.jpg/v4-728px-Open-CSV-Files-Step- 13.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Check the “Comma” box and then click “OK”. All text previously separated by commas will be separated by columns. [5] X Research Sources
By Google Sheets
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5f/Open-CSV-Files-Step-14.jpg/v4-728px-Open-CSV-Files-Step-14. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5f/Open-CSV-Files-Step-14.jpg/v4-728px-Open-CSV-Files-Step- 14.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Access Google Sheets with a web browser and sign in with your Google account. Enter your username and password and then click “Sign in”.
- Google Sheets is free, but you need a Google account to use it. If you don’t have a Google account, click “Create Account” and follow the onscreen instructions to create a Google username and password.
- Google Sheets can also be used through its main product, Google Drive.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a1/Open-CSV-Files-Step-15.jpg/v4-728px-Open-CSV-Files-Step-15. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a1/Open-CSV-Files-Step-15.jpg/v4-728px-Open-CSV-Files-Step- 15.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Click “Open File Picker”. This button has a folder icon and is located in the upper right corner of the page. The “Open a File” window will open.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Open-CSV-Files-Step-16.jpg/v4-728px-Open-CSV-Files-Step-16. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Open-CSV-Files-Step-16.jpg/v4-728px-Open-CSV-Files-Step- 16.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Click the “Upload” tab. You will go to the CSV file upload interface.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/bc/Open-CSV-Files-Step-17.jpg/v4-728px-Open-CSV-Files-Step-17. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/bc/Open-CSV-Files-Step-17.jpg/v4-728px-Open-CSV-Files-Step- 17.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Drag and drop the CSV file into the upload window. A progress bar will appear when the upload starts.
- Or you can click the “Select file to upload” button located between the upload window and browse for the CSV file on your computer.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/eb/Open-CSV-Files-Step-18.jpg/v4-728px-Open-CSV-Files-Step-18. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/eb/Open-CSV-Files-Step-18.jpg/v4-728px-Open-CSV-Files-Step- 18.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div> “}
Wait for the CSV file to upload. When done, the file will automatically be opened by Google Sheets.
- This process may take a few seconds to several minutes depending on the file size.
- Google Sheets will automatically separate all comma-separated data in CSV files.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 4,337 times.
CSV (Comma-separated values) are files that contain data from tables listed in plain text, such as email contact information. Although CSV files can be opened by many programs (such as editors), the data inside this format will be most fully displayed in spreadsheet software, such as Microsoft Excel, OpenOffice. Calc or Google Sheets (Google Sheets). You will need to select “Open” from the “File” menu, select the CSV file, and adjust the delimiter settings if the data is not displaying properly. The same steps are applicable on Google Sheets, but this requires you to upload the file to the Google servers. The working process will go more smoothly if you organize your data neatly and scientifically!
Thank you for reading this post How to Open CSV File at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: