Multiple and manual ticket entry on a spreadsheet

Multiple and manual ticket entry on a spreadsheet

We use desk mostly for interactions with our distributors. Sometimes they do tend to not interact with us for each particular helpdesk incident, spare parts requirement etc. They also have their own spare parts stocks and they tend to save up those particular incidents and then order a cumulative stock list of items also including a cumulative service report for each service they've provided.

We do analyze the tickets on Zoho Analytics based on each particular helpdesk and spare part communication and when we receive such a cumulative report from our distributors then it becomes a very cumbersome task of entering them one by one into the system. There is also the problem of creating those tickets with virtual and misleading creation dates.

It would help us tremendously ( and everyone else having similar problems) to be able to enter a bunch of tickets on a spreadsheet type of interface by also being able to edit the ticket creation dates ( or any other normally non-editable fields) for date-based reports.