How do you import data from another spread sheet?

jeffreybrown · #1 08-27-2020, 03:51 PM

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

SoMany · #2 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I am trying to remove the $- from the cells with no data on a large spread sheet	gch777	Excel	3	07-05-2018 09:42 AM
Data from a specific row in a spread sheet into a form	JohnnySTI	Excel Programming	13	01-24-2018 01:20 PM
Simple Spread Sheet	TThomas	Excel	1	04-07-2016 09:01 PM
Using combobox to pass data from an Excel spread sheet to text boxes on userform	Stewie840	Word VBA	14	12-17-2015 10:13 PM
Condensing a spread sheet	hawkeyefxr	Excel	4	08-22-2012 05:17 AM