Know-HowGoogle Docs™TablesTips

Copy a Table from Word or Excel into Google Docs™ Without Losing Formatting

Tables pasted from Microsoft Word or Excel into Google Docs™ often arrive with shifted columns, lost borders, or broken merged cells. Here's the reliable way to bring them across.

Travis

Travis

The most reliable route for Excel tables is a stop in Google Sheets™: paste there first, then copy the range into Google Docs™. For Word tables, let Google convert the whole file instead of pasting. And when a paste has already gone wrong, convert the mess in place instead of starting over.


Word, Excel, and Google Docs™ all describe tables differently — border widths, cell padding, merged cells, and column sizing don't translate one-to-one. A direct paste usually produces *a* table, but often not *your* table: borders vanish, columns squeeze, merged headers unmerge. Here's what actually works.


Excel → Google Docs™: go through Google Sheets™

  1. Copy the table range in Excel.
  2. Paste it into a blank Google Sheets™ file. Sheets™ speaks spreadsheet natively, so values, number formats, and cell structure survive well.
  3. Select the range in Sheets™ and copy it.
  4. Paste into Google Docs™. Docs™ inserts it as a real table and asks whether to link to the spreadsheet or paste unlinked — choose *linked* if the numbers will change (you'll get an update button in the Doc), *unlinked* for a one-off snapshot.

This two-hop route is more faithful than Excel → Docs™ directly, and the optional link is something a direct paste can't give you at all.


Word → Google Docs™: convert the file, don't paste

For a document that's mostly tables, skip the clipboard:

  1. Upload the .docx file to Google Drive.
  2. Open it with Google Docs™ (right-click > Open with > Google Docs™). Google converts the file, and its table conversion is far better than clipboard pasting.
  3. Copy the converted table from that document into your target Doc — a Docs™-to-Docs™ copy keeps the formatting intact.

For a single small table, a direct paste from Word is worth trying first — just expect to fix borders and column widths afterwards via Format > Table > Table properties.


Already pasted and it's a mess?

If the paste produced jumbled plain text instead of a table, you don't need to hunt down the original file:

  1. Select the pasted text.
  2. Run Extensions > Text To Table Converter > 🔤 ➜ 🔡 Selected Text to Table — the free Add-On detects the separators (tabs, in most spreadsheet pastes) and rebuilds the table in place.
  3. Restyle in one click via Extensions > Text To Table Converter > Table Styles.

Quick reference

SourceBest route
Excel rangeExcel → Google Sheets™ → Docs™ (optionally linked)
Word tableUpload to Drive → open as Google Docs™ → copy
Broken paste already in your DocText To Table Converter Add-On

Get the Add-On

Text To Table Converter

Obtenir le module gratuitement

Text To Table Converter

Fix broken pastes for free: Use the free Text To Table Converter add-on to turn jumbled pasted text back into clean tables in Docs™, Slides™, and Sheets™.

Installer gratuitement

Next Step: Tables from the Web