Complete Apollo 11 timeline in Excel


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

NASA has a detailed web page with the timeline of the Apollo 11 mission from before liftoff to well after splashdown   It’s an example of the two ways to put a web table into an Excel worksheet.

Newer Excel (365, 2019 and 2016) has PowerQuery with  ‘Get and Transform’ which is much better.

The older method (Copy and Paste) has been in Excel for a long time. We’ll demonstrate that in a separate article for people with older Excels. As you’ll see, Copy/Paste needs a lot more work to format and normalize in Excel.

This is our excuse to show the neat feature copying web tables into Excel. It’s a practical example including some little tricks and extras. Also how to use Get Data to copy a ‘one-off’ table that doesn’t need later refreshing.

Try for yourself.  It’s a simple and harmless way to step into Excel Get Data / Get & Transform.

Get Data from Web Table

Modern Excel has more powerful data import and conversion systems. They grab data from many external sources, transform in Excel data very well and drop into a worksheet ready to use.

Excel’s Get Data is setup to refresh the data from the source. That’s great in most situations but not always necessary. The Apollo 11 timeline  is a static, unchanging table with no data refresh necessary.

We’ll show how to copy a web table with Get Data with no later updates.

Get Data | From Other Sources | From Web

On the Data tab go to Get Data | From Other Sources | From Web.  The label ‘Get Data’ may be different depending on your version of Excel because Microsoft can’t seem to settle on a name. But the ‘From Web’ option will be there.

complete apollo 11 timeline in excel microsoft excel 29448 - Complete Apollo 11 timeline in Excel

Paste in the web link
https://history.nasa.gov/SP-4029/Apollo_11i_Timeline.htm  
to the page with the web table. Basic is enough for a standard web page available to anyone  Click Advanced if there are login or special requirements.

img 5d2f8ac2d29de - Complete Apollo 11 timeline in Excel

Wait while Excel grabs the web page and examines it.

The left of the Navigator shows the web page parts, click on the Table to see it in Table View on right.  This is the data Excel will import.

complete apollo 11 timeline in excel microsoft excel 29450 - Complete Apollo 11 timeline in Excel

Click Transform Data to go into PowerQuery. PowerQuery is where the incoming data table can be adapted to suit your needs.  Data can be changed to different formats, filtering, sorting, calculated columns added and a lot more.

In this case there’s NOTHING to do.  Get Data has converted all the NASA data into the correct Excel data types. GET is a time duration.  GMT Time are time cells and GMT Date are all dates.

complete apollo 11 timeline in excel microsoft excel 29451 - Complete Apollo 11 timeline in Excel

If that doesn’t seem like a big deal, see all the extra work needed in earlier versions of Excel with the Copy/Paste method.  Get Data is much better at identifying incoming text and matching it to Excel data types.

Finally click Close and Load to insert the data into an Excel worksheet.

complete apollo 11 timeline in excel microsoft excel 29452 - Complete Apollo 11 timeline in Excel

A lot of detailed work is done for you.  The data is made into a table automatically with sort and filter pull-downs ready to go.

The data query from the web page is shown in the Queries & Connections pane.

Disconnect Connection to web page

Each time Excel refreshes data connections, it will go out to the NASA page, grab another copy of the table and update the worksheet.

Since the Apollo 11 timeline isn’t going to change, there’s no point in keeping the data connection.

Click in the table then go to the Query tab and click Delete. Simple as that.

complete apollo 11 timeline in excel microsoft excel 29454 - Complete Apollo 11 timeline in Excel

Query | Delete only removes the data connection.  The existing table remains unchanged.

subs profile e1563205311409 - Complete Apollo 11 timeline in Excel
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