How to copy data from website as table to Excel (video in khmer)

Hello everyone! Today i will show you how to copy data from website that have table into Excel file step by step with simple way.

When you copy table from web browser like Chrome or Edge and paste directly into Excel, sometimes font color, link, and row size look messy and broken. In this video, i show you easy trick to make data clean!

📚 Related Tutorial: Want to learn fast shortcut key? Check out Learn All Excel Keyboard Shortcuts!

🛠️ Method 1: Simple Copy and Paste (Match Destination Formatting)

1. Open website page that have data table you want to copy.
2. Highlight and select table data on web page with your mouse.
3. Press Ctrl + C (or right click and select Copy).
4. Open your Excel sheet and select cell A1.
5. Right-click on cell A1 and under Paste Options, choose Match Destination Formatting (or press Ctrl + V and click paste menu bottom right to clean format).

🛠️ Method 2: Get Data From Web (Automatic & Clean)

If website table is big or updating every day:

1. Copy the website page URL address from top of browser.
2. Open Excel workbook and go to Data tab on ribbon menu.
3. Click From Web button (or Get Data ➔ From Other Sources ➔ From Web).
4. Paste website URL inside box and click OK.
5. Select the table name from Navigator preview list and click Load.
6. Excel will download clean table data into new worksheet automatically!

💡 Simple Tips for Web Table Copy

1. Remove Unwanted Links: If pasted data have many blue website links, select cells, right-click, and click Remove Hyperlinks.
2. Sort Your New Data: After paste table, you can sort data easily! Check How to Sort Data in Excel to arrange A to Z.
3. Copy Entire Sheet: Need to move copied table to another file? Watch How to Copy Entire Sheet to Another Excel File.
4. Basic Formulas: Want to calculate total numbers from web table? Learn Top 15 Basic Excel Formulas.