Exporting and Importing Data

In cases where you don’t need the data you are using from another source to be automatically updated if the source data changes, the most expedient way to get the data is to copy and paste it. In cases where you want to copy data from one program to another, you can convert the data to a format that the other program accepts. If you have text you want to include in your workbook, you can import, or open, a text file in a workbook.

Export Data Using Copy and Paste

Image Select the cell or range that you want to copy.

Image Click ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.