In January we created a simple KML converter that takes a KML file and produces a csv file that is easily opened with Microsoft Excel. Recently GEB reader David Kettle asked whether it would be ...

Step 2 when importing data is the command “Data -‘ From Picture -‘ Picture from File”. On the right side you can check the data before importing or insert it directly into the spreadsheet.

Microsoft Excel’s mobile app lets you to take a picture of a table and paste the data directly into your spreadsheet. Here's how to use it.

Excel pro tips: Importing and parsing data When data dumps into your spreadsheet and it's a big mess, you'll know what to do.