Google Sheets hien nay la phien ban online cua Excel duoc nhieu nguoi lua chon su dung, vi tinh thuan tien cua no khi ban chi can dang nhap tai khoan Google cua minh de su dung la xong. Tuy nhien trong khi lam viec tren Google Sheets, se co luc ban can chia se du lieu Excel de lam viec. Neu copy du lieu tu Excel sang Google Sheets theo cach thu cong se thay doi dinh dang bang. Vay lam sao de chuyen du lieu tu Excel sang Google Sheets ma khong thay doi dinh dang bang du lieu?

Chung ta co 2 cach de tai file Excel len Google Sheets, do la tai len Google Drive hoac nhap file Excel vao file Google Sheets hien co.

Cach 1: Tai file Excel len Google Drive

Buoc 1: Truoc het chung ta mo tai khoan Google Drive len. Tai giao dien click chuot vao muc My Drive roi chon Upload files... de tai file Excel len

Buoc 2: Chung ta cho qua trinh tai file len Google Drive thanh cong.



Sau do, mo file Excel nay tren Google Drive roi nhan vao nut Open with roi chon Google Sheets de mo file Excel nay trong Google Sheets.



Buoc 3: Trong giao dien nay chung ta co the boi den bang du lieu, roi click chuot phai va chon Copy de sao chep du lieu. Hoac o day ban cung co the thuc hien them nhieu tuy chon khac.

Cach 2: Nhap file Excel vao Google Sheets

Buoc 1: Tren thanh cong cu cua Google Sheets chung ta nhan chon File roi chon Import de nhap file Excel.



Buoc 2: Trong giao dien tai du lieu len Google Sheets, nguoi dung nhan chon vao tab Upload roi tai file Excel co san tren may tinh.



Buoc 3: Sau do trong giao dien Import file tich chon vao Creat new spreahsheet de mo 1 bang tinh moi roi nhan vao Import.



Buoc 4: Cho qua trinh nhap file Excel vao Google Sheets thanh cong roi ban nhan chon Open now de mo.

Khi mo du lieu Excel tren Google Sheets ban se thay moi dinh dang du lieu van duoc giu nguyen nhu hinh.

Voi 2 cach ben tren, ban da co them thu thuat de mo du lieu, sao chep du lieu Excel sang Google Sheets ma van giu nguyen duoc dinh dang noi dung. Tu dinh dang chu, mau sac, bang tinh,... se khong thay doi ma van nhu khi lam viec tren Excel. Tuy theo su thuan tien khi su dung ma chung ta lua chon cach tai file Excel len Google Drive de mo trong Google Sheets, hoac mo ngay file Excel trong giao dien Google Sheets.

Chuc cac ban thuc hien thanh cong!
xem thêm:

Nguyên tắc kế toán hàng mua đang đi đường theo Thông tư 133 – TK 151

https://ketoan68.net/nguyen-tac-ke-toan-hang-mua-dang-di-duong-theo-thong-tu-133-tk-151/