Saving and file formats (xlsx, csv) in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant managing monthly sales data.

📋 Request: Your manager wants you to save the sales report in two formats: Excel (.xlsx) for editing and CSV (.csv) for sharing with the sales team.

📊 Data: You have a sales report with columns: Date, Product, Region, Sales Amount.

🎯 Deliverable: Save the sales report as an Excel file and also as a CSV file.

Sample Data

Date	Product	Region	Sales Amount
2024-05-01	Notebook	North	120
2024-05-02	Pen	East	75
2024-05-03	Notebook	South	90
2024-05-04	Pen	West	60
2024-05-05	Notebook	East	110
2024-05-06	Pen	North	80
2024-05-07	Notebook	West	95
2024-05-08	Pen	South	70

1

Step 1: Open the sales report Excel file with the data shown.

No formula needed.

Expected Result

The sales data is visible in the spreadsheet.

2

Step 2: Save the file as an Excel workbook (.xlsx) to keep all formatting and formulas.

Click File > Save As > Choose location > Select 'Excel Workbook (*.xlsx)' > Save.

Expected Result

File saved as 'SalesReport.xlsx' with all data and formatting preserved.

3

Step 3: Save the same file as a CSV file to share with the sales team who may not use Excel.

Click File > Save As > Choose location > Select 'CSV (Comma delimited) (*.csv)' > Save.

Expected Result

File saved as 'SalesReport.csv' containing plain text data separated by commas.

4

Step 4: Close and reopen the CSV file to verify data is correctly saved.

Open 'SalesReport.csv' in Excel or a text editor.

Expected Result

Data appears as plain text with columns separated by commas, no formatting or formulas.

Final Result

SalesReport.xlsx
+------------+---------+--------+--------------+
| Date       | Product | Region | Sales Amount |
+------------+---------+--------+--------------+
| 2024-05-01 | Notebook| North  | 120          |
| 2024-05-02 | Pen     | East   | 75           |
| 2024-05-03 | Notebook| South  | 90           |
| 2024-05-04 | Pen     | West   | 60           |
| 2024-05-05 | Notebook| East   | 110          |
| 2024-05-06 | Pen     | North  | 80           |
| 2024-05-07 | Notebook| West   | 95           |
| 2024-05-08 | Pen     | South  | 70           |
+------------+---------+--------+--------------+

SalesReport.csv
Date,Product,Region,Sales Amount
2024-05-01,Notebook,North,120
2024-05-02,Pen,East,75
2024-05-03,Notebook,South,90
2024-05-04,Pen,West,60
2024-05-05,Notebook,East,110
2024-05-06,Pen,North,80
2024-05-07,Notebook,West,95
2024-05-08,Pen,South,70

✓Excel (.xlsx) format keeps all formatting and formulas intact.

✓CSV format saves only plain text data separated by commas.

✓CSV files are useful for sharing data with users who do not use Excel.

✓Always verify CSV files after saving to ensure data integrity.

Bonus Challenge

Try saving the file as a 'Text (Tab delimited) (*.txt)' format and compare it with the CSV file.

Show Hint

Use the Save As option and select 'Text (Tab delimited) (*.txt)'. Open the file in a text editor to see tabs separating the data.