The Text Import Wizard can replace existing data in a worksheet when it brings in new text. Use a blank worksheet so you don't risk overwriting your current data.

Forms created in Microsoft Word can be used to compile data on groups such as clients, purveyors and prospects, and later extract and import the data to an Excel worksheet.

Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.

You can import data from various sources like Excel files, databases (SQL Server, Oracle, etc.), text files, or even online services. You need to use Power Pivot here, which creates a specialized ...

Save time and effort manually copying data from Google to Excel. Import data from Google Spreadsheets seamlessly into Excel.

Twitter used to provide CSV exports of your data, now it's all in machine-readable JSON. How can you use it in Excel?