<div>
<blockquote>
putting them in one sheet of excel
</blockquote>
<br />
In what form? If it's not a pivot table, you're probably better off with PQ.
</div>


> putting them in one sheet of excel


In what form? If it's not a pivot table, you're probably better off with PQ.

<div>
^^^ &nbsp;Along these lines, it might not be a bad idea for you to paint us a picture of what exactly your business needs are, and how large these files are, as there are other solutions that may be more ideal.
</div>


^^^  Along these lines, it might not be a bad idea for you to paint us a picture of what exactly your business needs are, and how large these files are, as there are other solutions that may be more ideal.

<div>
Thank you, I was out sick so sorry for the delay
</div>


Thank you, I was out sick so sorry for the delay

<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
What is the basic difference between PowerPivot and power query – I am pulling data from multiple sources (huge csv files and other formats) and then i &nbsp;would need to join them and then manipulating them and putting them in one sheet of excel. &nbsp;Which one will be better in this case? Power pivot or power query
</div>
</div>


Hello All,

What is the basic difference between PowerPivot and power query – I am pulling data from multiple sources (huge csv files and other formats) and then i  would need to join them and then manipulating them and putting them in one sheet of excel.  Which one will be better in this case? Power pivot or power query

powerpvt vs powerQry

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.