Editing the exported file, Editing a text or csv file – Konica Minolta PageScope Enterprise Suite User Manual
Page 21
![background image](/manuals/474863/21/background.png)
Account Manager
3
Account Manager
3-6
2
Note
The exported data can be viewed and edited in a spreadsheet
application. For details, refer to "Editing the exported file" on page 3-6.
2
Note
To open a file for which a password has been set with XLS or XLSX
selected in "File Format", a read password must be entered to open the
file.
Editing the exported file
The exported file can be edited and saved in a spreadsheet application.
2
Reminder
To edit and save an XML file in a spreadsheet application, change the file
format to "XML Spreadsheet", and then save it.
For the procedure to edit a tab-delimited text file (.txt) or a comma-
delimited CSV file (.csv) in a spreadsheet application, see "Editing a text
or CSV file".
Editing a text or CSV file
The following procedure describes how to edit an exported tab-delimited
text or comma-delimited CSV file in Microsoft Excel.
1
Open Microsoft Excel.
2
Open the exported file.
–
To open a CSV file using Microsoft Excel 2003, select "Import
External Data" - "Import Data" from the Data menu. In the Select
Data Source dialog box, select "All Files" as the file type.
–
To open a CSV file using Microsoft Excel 2007, click "From Text"
on the Data tab.
The Text Import Wizard appears.