Add to Favourites

Map Data with & Without Column Headers in Excel

When preparing data in Excel for import, you might have files that include column headers (for example, Party Name, GSTIN, Amount, etc.) or files without any headers where data starts directly from the first row.

TallyPrime allows you to import such data easily by creating a Mapping Template that maps the fields in your Excel file with the corresponding fields in TallyPrime.

Map Data with Column Headers

Let’s say you have entered the data in Excel with column headers, as shown below.

In the Mapping Template Creation screen:

1. Set Excel Data has column headers to Yes.
2. Under Field (TallyPrime), map the following fields with their corresponding columns in Excel:
   1.  Name with Party.
   2. Group Name with Debtor/Creditor.
   3. Address with Location.
   4. GST Registration – GSTIN/UIN with GSTIN.
   5. Ledger – Opening Balance with Op.Bal.
      
3. Press Ctrl+A to save the mapping template and import the data using the saved template.

Map Data Without Column Headers

Let’s say your Excel file does not have column headers for any or all columns, you can specify the columns during mapping.

In the Mapping Template Creation screen:

1. Set Excel Data has column headers to No.
2. Under Field (TallyPrime), map the following fields with their corresponding columns in Excel:
   1. Name with column A.
   2. Group Name with column B.
   3. Address with column C.
   4. GST Registration – GSTIN/UIN with column D.
   5. Ledger – Opening Balance with column E.
      
3. Press Ctrl+A to save the mapping template and import the data using the saved template.