คู่มือผู้ใช้ Ulet

เริ่มต้นใช้งาน Ulet สำหรับ {platform}

Open a CSV and Check Its Columns on Windows

A CSV stores a plain-text table using separators and line breaks. Check the imported layout before editing, especially when a file comes from another system.

Open the sample CSV

  1. On Ulet Home, choose Open File.

  2. Select your practice copy of Riverside-Expenses.csv.

  3. Check that the first row contains Item, Amount, Category, Owner, and Status in five separate columns.

  4. Inspect the data rows and select an amount to check its formula bar value. Use the bottom Zoom slider for a comfortable view; this example is shown at 150%.

English CSV expense table imported into five separate worksheet columns

View screenshot at full size

The imported table keeps each item, amount, category, owner and status on one row.

Verify representative records

The practice file contains Paper with amount 12, Pens with amount 8, and Desk lamp with amount 45. The first two records have Complete status; Desk lamp is Planned.

If every record appears in one column, check the source separator before continuing. A comma-separated file and a tab-separated file need to be interpreted with their respective separators.

Choose the next step

Keep the original CSV when it is an input from another system. Use a separately named XLSX copy when you need a workbook for further spreadsheet work.

Practice CSV

To create the file used here, copy these four lines into a plain-text editor and save them as Riverside-Expenses.csv using UTF-8 encoding. Keep the commas and line breaks, then open that file in Ulet.

Item,Amount,Category,Owner,Status
Paper,12,Supplies,Alex,Complete
Pens,8,Supplies,Sam,Complete
Desk lamp,45,Equipment,Jordan,Planned

Ulet

ชุดโปรแกรมสำนักงานครบวงจรสำหรับงานประจำวันของคุณ

ดูฟีเจอร์