It used to be easy to analyze your Twitter data: you'd go to your settings and ask for a download, and there among all the files would be a CSV file full of your tweets and the associated metadata.

If the numbers you need to crunch come from the Web, then you’ll need an efficient way to get it into Microsoft Excel. There are several ways you can do this, and one method even allows for automatic ...

is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft is overhauling Excel with the ability to support custom live data types.