Cara menggunakan convert spv to excel

CSV to XLS (EXCEL) Converter

Convert your csv files to xls online & free

Drop files here. 100 MB maximum file size or Sign Up

Convert to CSV

csv

Comma-Separated Values

Is a text format used for representing tabular data. Each file line is located on a separate line in the table. The values of the columns are separated by a delimiter, most often a comma. However, other symbols can be used as delimiters as well.

XLS Converter

xls

Microsoft Excel Worksheet Sheet (97-2003)

XLS format is used to refer to the documents of the program Microsoft Excel. This file is a spreadsheet. All document data distributed and stored in the cells. Each cell has a unique address, which is denoted by letters and Arabic numerals. The cell can contain fixed data, and data in the form of formulas, which bind more cells.

How to convert CSV to XLS

Step 1

Upload csv-file(s)

Select files from Computer, Google Drive, Dropbox, URL or by dragging it on the page.

Step 2

Choose "to xls"

Choose xls or any other format you need as a result (more than 200 formats supported)

Step 3

Download your xls

Let the file convert and you can download your xls file right afterwards

CSV to XLS Quality Rating

4.7 (33,314 votes)

You need to convert and download at least 1 file to provide feedback!

Steps

1. 

   1

   Open Microsoft Excel. A quick way to do this is to type excel into the Windows search bar and click Microsoft Excel.

2. 

   2

   Click the File menu. It’s at the top-left corner of Excel.

   Advertisement

3. 

   3

   Click Open.

4. 

   4

   Select Text files from the file type drop-down menu.

5. 

   5

   Select the text file you want to convert and click Open. This opens the Text Import Wizard.

6. 

   6

   Select a data type and click Next. In the ″Original data type″ section, select Delimited (if the text file contains data separated by commas, tabs, or some other method), or Fixed width (if the data is aligned in columns with spaces between each field).

7. 

   7

   Select deliminators or field width and click Next.

   • If you chose Delimited on the previous screen, check the box next to the symbol (or ″Space″ if it’s separated by a space) used to separate the data fields.
   • If you selected Fixed width on the previous screen, follow the on-screen instructions to arrange your data properly.

8. 

   8

   Select the column data format. Choose the option under ″Column data format″ that best describes the data in the columns (e.g. Text, Date).

9. 

   9

   Click Finish. The ″Save As″ window will appear.

10. 

    10

    Select Excel Workbook (*.xlsx) from the ″Save as type″ menu. It’s at the bottom of the window.

11. 

    11

    Name the file and click Save. The Notepad text file is now saved as an Excel workbook.

Advertisement

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Thanks for submitting a tip for review!

wikiHow Video: How to Convert Notepad to Excel

About This Article

Article SummaryX

1. Open Excel.
2. Open the text file.
3. Select deliminators or field width.
4. Select the column data format.
5. Save the file in the .xlsx format.

Did this summary help you?

Thanks to all authors for creating a page that has been read 268,369 times.

Is this article up to date?