Excel Data Import and Export
Excel rarely works in isolation. Data moves into Excel from databases, websites, accounting software, and other files — and out of Excel into reports, other applications, and systems. Knowing how to import and export data correctly saves hours of manual work and prevents errors caused by copy-pasting.
Importing a CSV File
A CSV (Comma-Separated Values) file stores data as plain text with commas separating each value. It is the most common format for data exchange.
Method 1: Open Directly
Go to File → Open → Browse. Change the file type filter to "All Files" or "Text Files." Select your CSV file. Click Open. Excel opens the file and splits data at each comma automatically.
Method 2: Import via Data Tab (Recommended)
Go to Data → Get Data → From File → From Text/CSV. Select your CSV file. A preview window opens showing how Excel will split the data. Check that the delimiter is set to Comma. Click Load to bring the data into your sheet, or click Transform Data to clean it first in Power Query.
CSV Import Diagram
Raw CSV file content: Name,Region,Sales Alice,North,5000 Bob,South,3200 Carol,East,7100 After importing into Excel: +-------+--------+-------+ | Name | Region | Sales | +-------+--------+-------+ | Alice | North | 5000 | | Bob | South | 3200 | | Carol | East | 7100 | +-------+--------+-------+
Importing a Text File (TXT)
Text files use spaces, tabs, or other characters as delimiters. Go to Data → Get Data → From File → From Text/CSV. In the preview, change the delimiter from Comma to Tab, Space, or Custom, depending on what separates the values in your file. Click Load.
Importing from a Web Page
Excel can pull table data directly from a public web page.
Go to Data → Get Data → From Other Sources → From Web. Enter the URL of the page. Click OK. Excel loads the page and lists any tables it finds. Select the table you want. Click Load. Excel imports the table data into your worksheet.
Importing from Another Excel File
To link data from another Excel file, use a direct cell reference that includes the file name, sheet name, and cell address.
='[SalesData.xlsx]Sheet1'!$B$5 This formula reads the value from cell B5 in Sheet1 of SalesData.xlsx. If SalesData.xlsx is closed, the full file path must be included: ='C:\Users\Rahul\Documents\[SalesData.xlsx]Sheet1'!$B$5 When the source file is open, Excel reads the live value. When the source file is closed, Excel uses the last saved value.
Importing from a Database
Excel can connect to SQL Server, Access, and other databases using the Data tab.
Go to Data → Get Data → From Database. Choose the database type (SQL Server, Access, and others). Enter the server name or file path. Log in with your credentials. Select the table or write a query. Click Load or Transform Data.
Exporting to CSV
CSV files work in almost every software — accounting tools, CRM systems, databases, and other spreadsheet applications.
Go to File → Save As. Choose a location. In the "Save as type" dropdown, select CSV (Comma delimited) (*.csv). Click Save. Excel warns that CSV does not support multiple sheets or formatting. Click Yes to save only the active sheet as CSV.
What CSV Loses vs XLSX
| Feature | Saved in CSV? | Saved in XLSX? |
|---|---|---|
| Data values and text | Yes | Yes |
| Formulas | No — values only | Yes |
| Cell formatting (colour, font) | No | Yes |
| Multiple sheets | No — one sheet only | Yes |
| Charts | No | Yes |
| Data validation | No | Yes |
Exporting to PDF
Exporting to PDF creates a fixed, printable version of your spreadsheet that anyone can open without Excel installed.
Go to File → Export → Create PDF/XPS Document. Click Create PDF/XPS. Choose a location. Under Publish what, choose to publish the active sheet, the entire workbook, or a selected cell range. Click Publish.
Exporting Specific Data to Another Format
To share only a table or chart — not the whole workbook — copy the range or chart in Excel. Open Word, PowerPoint, or another application. Paste as a picture or as a linked object depending on whether you need the data to update automatically.
Copying Data Between Applications Using Paste Special
When you paste data from another application into Excel, the data often carries unwanted formatting or gets interpreted incorrectly. Use Ctrl + Alt + V (Paste Special) and choose:
| Paste Option | What It Does |
|---|---|
| Values | Pastes only the numbers or text, no formatting or formulas |
| Formats | Pastes only the formatting, not the values |
| Values and Number Formats | Pastes values with their number format (like currency or percentage) |
| Transpose | Rotates rows to columns or columns to rows |
Refreshing Imported Data
When you import data using the Data tab (not just File → Open), Excel creates a connection to the source. When the source updates, you can refresh the import without starting over.
Go to Data → Refresh All to update all imported data connections at once. Or right-click a specific imported table and choose Refresh to update only that connection.
Data import and export skills reduce manual effort across every Excel workflow. Instead of retyping data from a report into Excel or copying figures cell by cell, the right import method brings structured data into your sheet in seconds. The right export method sends it back out in the format that the receiving system or person needs.