Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...

Click the Data tab. In the Get & Transform Data group, click From Table/Range. (If the data isn’t a Table, Excel will run you through the steps necessary to convert the data into one.) ...

Excel 2016 and later include a powerful set of tools for sourcing and managing data called Get & Transform. (These tools are also available for Excel 2010 and 2013 as a downloadable add-in called ...

Excel’s Get & Transform Data feature provides a quick way to retrieve data. While doing so, there are a number of ways to manipulate the data, and one of those will delete blank rows.

You can convert JSON files to Microsoft Excel CSV file formats using this hidden built-in feature. We show you how to do it.

This way, users select data they wish to import into an Excel spreadsheet. Importing PDF data into Excel spreadsheets is part of Excel’s Get & Transform feature.