Madhurig at 16:11, 18 January 2026

2026-01-18T16:11:29Z

Mayahans: Created page with "'''Title of the Script: Extract Excel to Marc Codefile''' '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' Koha, Koha 24.05, Koha library system, Excel to MAR..."

2025-12-15T07:31:55Z

Created page with "'''Title of the Script: Extract Excel to Marc Codefile''' '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' Koha, Koha 24.05, Koha library system, Excel to MAR..."

New page

'''Title of the Script: Extract Excel to Marc Codefile'''

'''Author: '''Maya Hans and Vaibhavi Satardekar

'''Keywords:''' Koha, Koha 24.05, Koha library system, Excel to MARC, Excel to MARC conversion, Video tutorial.

'''Prerequisite:''' Install MarcEditor on Windows

{|border=1
|-
|| '''Slide Number 1'''

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Extract Excel '''to''' Marc Codefile'''.
|-
|| '''Slide Number 2'''

'''Learning Objectives'''
* '''Extract Excel to Marc Codefile'''

|| In this tutorial, we will learn how to:
* '''Extract '''the''' Excel to Marc Codefile'''.

|-
|| '''Slide Number 3'''

'''System Requirement'''
* '''Windows 11 Pro Operating System'''
* A working internet connection

|| To record this tutorial, I am using
* '''Windows 11 Pro Operating System '''and
* I also have a working internet connection.

|-
|| '''Slide Number 4'''

'''Prerequisites'''
* You should have knowledge of Library Science

|| To practice this tutorial, you should have knowledge of Library Science.
|-
|| Point to the shortcut icon on the '''Desktop'''
|| Recall that in an earlier tutorial we have already installed '''MarcEdit 7.7'''.
|-
|| Narration only
|| Please note, the '''Excel '''file used in this tutorial is provided in the code files link.
Download that file.

Now let’s learn to extract the code file.
|-
|| Point to '''This PC '''icon

Point to navigation pane on the left click on '''Downloads'''

Right-click on '''Convert-Excel-to-MARC-Code Files '''folder''' '''select '''Extract All'''

Cursor on '''Select a Destination and Extract Files'''

Click on''' Browse '''

Cursor on''' Select a destination window '''

From navigation pane on the left, click on '''Desktop'''

Click on''' Select Folder'''

Click on '''Extract'''

Double click on the '''Code-file''' folder
|| On the '''Desktop''' click on '''This PC'''.

From the navigation pane on the left, click on '''Downloads'''.

Right-click on the '''Convert-Excel-to-MARC-Codefiles''' folder and select '''Extract All'''.

A pop up '''Select a Destination and Extract Files '''opens.

Click on '''Browse''', a pop up '''Select a destination '''window''' '''opens.

From the navigation pane on the left, click on '''Desktop'''.

At the bottom of the window, click on '''Select Folder''' then click on '''Extract '''button.

Now close this window.

On the '''Desktop''' double click on the '''Code-file''' folder.

We can see the codefile is extracted successfully.

Now copy the '''TestData''' file and paste it on the '''Desktop '''for easy access.
|-
|| Narration only
|| With this we come to the end of this tutorial.
|-
|| '''Slide Number 4'''

'''Summary'''

We learned to:
* '''Extract Excel to Marc Codefile'''

|| Let’s quickly recap.
|-
||'''Slide Number 5'''

'''Assignment'''
* Extract the assignment codefile provided in the codefiles link

||As an assignment,

Extract the assignment codefile provided in the codefiles link.
|-
|| '''Slide Number 6'''

'''Thank you'''
|| Thank you for joining.
|-
|}

@@ Line 31: / Line 31: @@
 || To record this tutorial, I am using
-* '''Windows 11 Pro Operating System '''and
+* '''Windows 11 Pro Operating System ''' and
 * I also have a working internet connection.
@@ Line 41: / Line 41: @@
 || To practice this tutorial, you should have knowledge of Library Science.
 |-
-|| Point to the shortcut icon on the '''Desktop'''
-|| Recall that in an earlier tutorial we have already installed '''MarcEdit 7.7'''.
+'''Slide Number 5'''
 |-
-Now let’s learn to extract the code file.
+|| Narration only
 |-
 || Point to '''This PC '''icon
@@ Line 71: / Line 79: @@
 Double click on the '''Code-file''' folder
-|| On the '''Desktop''' click on '''This PC'''.
+|| On the '''Desktop''' click on '''This PC''' shortcut.
 From the navigation pane on the left, click on '''Downloads'''.
@@ Line 77: / Line 85: @@
 Right-click on the '''Convert-Excel-to-MARC-Codefiles''' folder and select '''Extract All'''.
-A pop up '''Select a Destination and Extract Files '''opens.
+A pop up '''Select a Destination and Extract Files ''' opens.
-Click on '''Browse''', a pop up '''Select a destination '''window''' '''opens.
+Click on '''Browse''' button, a pop up '''Select a destination '''window''' '''opens.
 From the navigation pane on the left, click on '''Desktop'''.

Koha-Library-Software/C4/Extract-Excel-to-Marc-Codefile/English - Revision history

Madhurig at 16:11, 18 January 2026

Mayahans: Created page with "'''Title of the Script: Extract Excel to Marc Codefile''' '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' Koha, Koha 24.05, Koha library system, Excel to MAR..."