Importing data from spreadsheets is one of the first, and perhaps most useful, skills that a CiviCRM administrator generally learns when getting acquainted with their new CRM. However, it can be frustrating to find that certain types of data either can’t be imported at all with the standard import tools, or can’t be imported with all the necessary data.
There is a tool for this, however! The “API CSV Import Gui” extension can save the day in some of these situations and make your work much more efficient, especially if a lot of your data is currently stored in spreadsheets.
The process and user interface are quite similar to the standard import tools; users upload their CSV on the first screen, and map the fields on the second one. The primary difference lies in the “Entity to import” field, which requires users to select what type of data they’re importing.