Import data from external sources Excel offers a robust set of tools to import data from various external sources, making it a versatile, lightweight database solution.

Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether.

Launch Visual Basic 6 or Visual Basic Express. Open the project file in which you want to create a module and command button that creates an Excel spreadsheet from selected data.

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

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.