Copy and Paste web pages & tables into Excel – Apollo 11 Timeline


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

One way to get a web table into Excel is simply to copy the page from your browser into an Excel workbook.

This method works for all versions of Excel back more than a decade.  It’s been superseded by Get and Transform with PowerQuery which does a much better job of conversion.  See Complete Apollo 11 timeline in Excel

Copy and Paste

For a static, unchanging table like NASA’s Apollo 11 timeline the simple way to import into Excel is copy from the web page into an Excel worksheet.

Open the web page in your browser.

Select the entire page (Ctrl + A) or choose the entire table you want with perhaps some text before and after just to be sure.

copy and paste web pages tables into excel apollo 11 timeline microsoft excel 29430 - Copy and Paste web pages & tables into Excel - Apollo 11 Timeline

Switch to a blank worksheet in Excel then Paste (Ctrl + V)

Excel will convert the web table into cells.

copy and paste web pages tables into excel apollo 11 timeline microsoft excel 29431 - Copy and Paste web pages & tables into Excel - Apollo 11 Timeline

Tidy up any unwanted rows.

Cell Format conversion

Each cell is converted into a matching Excel cell format, with mixed success.

Whenever copying a web table to Excel, check what Excel has done to each cell. Especially check date and time cells. Sometimes Excel converts the value to a date or time but it might leave it as Text/General.

The GMT time cells are converted to time with hh:mm:ss formatting.

copy and paste web pages tables into excel apollo 11 timeline microsoft excel 29432 - Copy and Paste web pages & tables into Excel - Apollo 11 Timeline

None of the GET (Ground/Mission Elapsed Time) values are converted into Excel time durations.

copy and paste web pages tables into excel apollo 11 timeline microsoft excel 29433 - Copy and Paste web pages & tables into Excel - Apollo 11 Timeline

Fix that by selecting the cells and choosing the correct format from Home | Number | Custom | [h]:mm:ss    That format with [h] makes Excel show total hours.

img 5d2f893caac2c - Copy and Paste web pages & tables into Excel - Apollo 11 Timeline

Scroll down the table looking for anomalies like split cells, blank rows or changes in formatting. A giveaway is when the cell justification changes unexpectedly which indicates a change in cell formatting.

copy and paste web pages tables into excel apollo 11 timeline microsoft excel 29435 - Copy and Paste web pages & tables into Excel - Apollo 11 Timeline

Format as Table

Finally, format the entire thing as a table for better formatting plus sort and filter options.

copy and paste web pages tables into excel apollo 11 timeline microsoft excel 29436 - Copy and Paste web pages & tables into Excel - Apollo 11 Timeline

Or … do it the easier way

Avoid all that messing about with cell conversions, Format as Table.etc by using Get and Transform. Look on left side of Excel’s Data tab for a data import feature. It’s changed name over time but the fundamentals are the same.

copy and paste web pages tables into excel apollo 11 timeline microsoft excel 29437 - Copy and Paste web pages & tables into Excel - Apollo 11 Timeline

See Complete Apollo 11 timeline in Excel for details on how to use Get and Transform to import web pages and tables.

subs profile e1563205311409 - Copy and Paste web pages & tables into Excel - Apollo 11 Timeline
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address