CLE Credit Submission By Spreadsheet

CLE Credit Submission by Spreadsheet FAQ

1. What is the website address?

https://www.supremecourt.ohio.gov/attysvcs/cle/sponsors/Login.aspx

2. I want to download a blank spreadsheet. How do I do that?

After you have logged into the system, click on “Download Excel Spreadsheet” and follow the prompts.

3. How does the spreadsheet work?

A specially formatted Microsoft Excel spreadsheet has been developed for sponsors to use to submit attorney attendance credits for approved activities. To get started, a sponsor must provide the Office of Attorney Services with one designated email address for its organization to use. Sponsors will receive a password and emails regarding the submission of spreadsheets at the designated email address. After we receive a sponsor’s email address, an email will be sent to the sponsor with a password and the link to log on to the CLE Credit Upload website.

Sponsors must use the specially formatted Microsoft Excel spreadsheet to report continuing legal education credit. This document will always be available on the website. The spreadsheet should be downloaded to your desktop. We recommend that you set up icons on your desktop for the Excel spreadsheet and the CLE Credit Login.

On the spreadsheet, you will input the attorney registration number, the activity code number and the number of CLE hours for each of the attorneys who attended the course. A maximum of 200 attendance credits can be submitted on one spreadsheet.

4. What types of credits can be submitted through the spreadsheet?

A sponsor may submit attendance credits for all approved courses, including new lawyer training programs, in-house programs, and self-study programs.

5. What happens after I submit a completed spreadsheet?

When you press the button to upload a spreadsheet, you will receive a message telling you whether or not the upload was successful. The message will include a batch number that you should reference if you have any questions. You may want to rename your spreadsheet to include the batch number for easy reference.

Step 1: Upload File

Step 2: Success!

If the upload is not successful, you will see a message similar to this:

Please review the list of error messages found under FAQ question 18 for information about the specific error messages.

You will immediately receive an email that lists the number of records successfully uploaded, sorted by activity code. The email will also list any errors that have occurred. Please review the email carefully and compare errors with the information you entered on the spreadsheet. An error could simply be a transposed attorney registration number or activity code or there may be an issue with the number or type of credits approved for a particular activity. Please review the list of error messages found under FAQ question 18 for more information.

Please keep in mind, that when you submit corrections, you will need to create a new spreadsheet that contains just the corrections. If you resubmit the original spreadsheet with corrections, you will receive duplicate submission errors for all the records that were previously uploaded successfully.

6. What type of credits cannot be submitted through the spreadsheet?

Teaching credits cannot be submitted through the spreadsheet. Please have the speaker complete a request for teaching credit (Form 2) and mail to the Office of Attorney Services.

7. What should I do if I discover that I made an error on the spreadsheet? How do I make a correction?

If you have not yet uploaded the spreadsheet, you should make all corrections on the spreadsheet prior to submitting it.

If you have already uploaded the spreadsheet, you will need to send an email to requesting that an attorney’s credit be corrected. Please include the attorney registration number, activity number, and number of CLE credits.

8. I would like to modify the spreadsheet. How do I do that?

The Excel spreadsheet is locked and cannot be modified.

9. How can I change the email address for the sponsoring organization?

Sign in to the CLE Credit Upload website and then click on the field titled “Change Email or Password.”

Then, type in the new email address and password. Click on the “Update Information” button.

If you have any questions, please contact the Office of Attorney Services.

10. How can I retrieve a lost or forgotten password?

Go to the CLE Credit Upload website and click on the field titled “Forgot Password?” and follow the prompts.

If you have any questions, please contact the Office of Attorney Services at 614.387.9320.

11. I want to change my password. How do I go about it?

After you login, click on the “Change Email or Password” field.

Step 1

Then, type in the sponsor email address and your desired password. Click on the “Update Information” button.

Step 2

12. How do I submit credits for an attorney who attends a new attorney course?

Please enter the credits in the specially designated fields on the spreadsheet.

13. What does the maximum allowable error message mean?

If you report more credits than the activity was approved for, you will receive this error message.

14. What does the teaching and attendance maximum allowable error message mean?

Teaching credit has been added to this attorney record. Email the Office of Attorney Services at to submit attendance credit for this attorney.

15. The attorney attended less than one full hour of continuing legal education. How do I key the credit?

Please keep in mind that in order to receive any CLE credit, an attorney must attend a minimum of one 60-minute hour of an approved activity. Reporting credit that equals less than one substantive hour will not be accepted and will result in an error message.

Credits must be submitted in increments of .25 hours, i.e. .25, .50, .75, 1.0, 1.25 etc. and the total must equal at least 1.0.

16. I realized that I made a number of errors on the spreadsheet I just submitted. Can I submit another spreadsheet to overwrite the incorrect submissions?

No, you will need to contact the Office of Attorney Services at 614-387-9320.

17. What do I do if an attorney contacts me and indicates that he or she did not receive credit for an activity that the attorney attended in a previous biennium?

Only credit for activities that took place in the current compliance period can be submitted. Credit for an attorney’s attendance at an activity from a previous compliance period cannot be submitted electronically.

18. What other error messages might I see?

Error Message / Explanation /
Problem uploading Excel file. Your file was not processed, please try again. / This message will occur if the file disappears between the time the user uploads the file and the system opens the file to process the credit submissions. This error is very unlikely.
Unexpected error uploading spreadsheet. / This is a generic message that will occur if an unknown error occurs. Please check the spreadsheet for accuracy and try again.
Invalid number of columns in spreadsheet. Please make sure you are using the latest template. / You may be using an out-of-date version of the specially designed Excel spreadsheet. Please download the latest version.
Problem opening Excel file. Please make sure you are using the correct template. / You have not used the specially designed Excel spreadsheet to report attorney credits. Please download the current spreadsheet.
Problem reading attorney number column for record. / Attorney registration number is invalid.
Problem reading CLE activity column for record (line number). / Activity code is invalid.
Problem reading general hours column for record (line number). / Amount entered for general hours is invalid.
Problem reading attorney conduct hours column for record (line number). / Amount entered for attorney professional conduct is invalid.
Problem reading new attorney general hours column for record (line number). / Amount entered for new attorney general hours is invalid.
Problem reading new attorney law office hours column for record (line number) / Amount entered for new attorney law office management hours is invalid.
Problem reading new attorney client fund hours column for record (line number) / Amount entered for new attorney client fund management hours is invalid.
Problem reading new attorney professionalism hours column for record (line number) / Amount entered for new attorney professionalism is invalid.
Problem reading in-house column for record (line number) / Information entered in the in-house column is invalid.
Duplicates found for Attorney and Activity in spreadsheet / A duplicate record has been submitted.
Invalid Attorney / The attorney number provided is invalid.
Non Approved Activity / The activity is not approved for continuing legal education credit.
Hours greater than allowable: xx submitted / The hours submitted exceed the maximum allowable.
Negative values for hours entered found for Attorney / Hours were entered as a negative number.
Hours not in .25 increments / Entry is not in .25 increments.
Total hours less than 1: xx submitted / Credit for less than 1.0 hour was submitted.
Course date in future: xxDate here / Activity is in the future. Credit cannot be submitted prior to the activity date.
Teaching and attendance hours exceed maximum allowable / Teaching credit has been added to this attorney record. Email the Office of Attorney Services at to submit attendance credit for this attorney.
Invalid Specialization Type of NLT: / Activity is not eligible for New Attorney credit.
Course date too old (locked biennium) / Credit cannot be added to an activity that took place in a previous biennium.
Course date before Attorney start date / The attorney was not eligible to practice law on the date of this activity. No credit is available.
Duplicate Entry - Credit was previously submitted for Activity / A duplicate record has been submitted.

4