Updated July 2022 by Dave Van Kleeck
Using MarcEdit to Create an 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
------------------------------------
MarcEdit is a free tool that can be downloaded at: https://marcedit.reeset.net/
You can find tutorials on using MarcEdit at: https://www.youtube.com/results?search_query=marcedit
|
