Following matrix of prices up to a given weight per country is given:
The user is able to edit individual prices. Depending on the amount of countries and weights the matrix can get quite big, making it a pain to use. The user has to scroll around vertically and horizontally to make changes.
Our users avoid using the matrix. Instead they export the matrix as csv, make changes in excel and import it back in our tool.
How can the usability be improved? Are there alternatives to the matrix?
My first Idea was to display an empty matrix and let the user choose specific countries, thus reducing the amount of fields displayed at the same time. Another idea was to get rid of the matrix completely and focus on a nice import/export experience.