Skip to main content

Aleph@UF: Using MarcEdit to Create Excel Spreadsheet From a .Dat File

Cataloging procedures and policies

Updated July 2019 by Gerald Langford and Greg Allen

Using MarcEdit to Create Excel Spreadsheet From a .Dat File

In MarcEdit, go to Tools\Export\Export Tab Delimited Records  (shortcut: Ctrl + t)

Click on folder icon to the right of 1st box to navigate to your .dat file

By default, MarcEdit will look for MARC files.  In dropdown to the right of the “File name” box, choose “All Files”

Highlight .dat file; click “Open”

Click on folder icon to the right of the 2nd box to navigate to where you want the tab-delimited file.

Give the file a name.

Make sure the “Save as type:” is “Tab Delimited Text”

Click “Save”

Click “Next”

Click on “Settings…”

Click on “Load Settings”

On library server, go to SharedProjects\IRatUF\PILOTs_to_Catalog

Click on “PILOT_settings_for_UFDC.txt”

Click “Open”

Click “Export” button.

You can import the exported tab-delimited text file to Excel.

 

The following fields will be pulled from the records in the .dat file:

001

005

006

007

008

040

050

100

245

264

300

336

337

338

500

590

502

504

588

520

540

653

655

690

700

830

852

856

 

University of Florida Home Page

This page uses Google Analytics - (Google Privacy Policy)

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.