Microsoft Office Forums - View Single Post - How do you import data from another spread sheet?

SoMany · 08-30-2020, 06:33 AM

Quote:

Originally Posted by Purfleet

what is the file type of the data dump? xls/xlsx/txt/csv?

The format is .xls

Quote:

Originally Posted by jeffreybrown

As has been already pointed out, the best method is to setup a connection thru power query.

Import the First Sheet in a Workbook with Power Query - Excelerator BI

Before learning about Power Query, it should be noted that when I go to Data-->Get Data-->From Workbook ... The message I get is "External table is not in the expected format."

Edit: All I need is to be able to copy past the entire first sheet of this spreadsheet into the second sheet of the file I'll be using to interpret this data.