Service master upload process manual
Step 1: Make a copy of the next service sheet. Click File -> Make a copy and save this sheet as your google sheet.
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step1_1uvyvjc.jpg)
Step 2: Fill up the 'Service' sheet as per the given template format. Read below guidelines before adding your data.
Do not change template headers
Service name column is mandatory .
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step21_1h2fz3w.jpg)
Avoid using Dash/Hyphen symbol in the service name & service number.
Do not add '%' symbol in the TAX Value column, keep only number. For Ex. 5
Only numeric value should be entered in Price, Tax, and Benchmark hours column. Decimal will be accepted
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step22_8w68uf.jpg)
If services have to be added in multiple languages, then enter the service name in both the languages separated by a "/" example: Car Diagnostic / تشخيص السيارة
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step23_1m0gxov.jpg)
Keep the number format as Automatic or plain text.
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step24_7cdmtq.jpg)
Remove all the extra columns other than the template. (If any)
Step 3: If you are adding any data in the CATEGORY column, ensure to first create these categories in GaragePlug.
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step3_9k251b.jpg)
Step 4: Download only service sheet in CSV (Comma Separated Values) format.
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step4_namfty.jpg)
Step 5: Upload the CSV file into your GaragePlug account. Settings ->Service & Part master ->select service ->upload CSV ->choose file -> UPLOAD
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step5_z2cvx3.jpg)
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step1_1uvyvjc.jpg)
Step 2: Fill up the 'Service' sheet as per the given template format. Read below guidelines before adding your data.
Do not change template headers
Service name column is mandatory .
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step21_1h2fz3w.jpg)
Avoid using Dash/Hyphen symbol in the service name & service number.
Do not add '%' symbol in the TAX Value column, keep only number. For Ex. 5
Only numeric value should be entered in Price, Tax, and Benchmark hours column. Decimal will be accepted
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step22_8w68uf.jpg)
If services have to be added in multiple languages, then enter the service name in both the languages separated by a "/" example: Car Diagnostic / تشخيص السيارة
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step23_1m0gxov.jpg)
Keep the number format as Automatic or plain text.
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step24_7cdmtq.jpg)
Remove all the extra columns other than the template. (If any)
Step 3: If you are adding any data in the CATEGORY column, ensure to first create these categories in GaragePlug.
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step3_9k251b.jpg)
Step 4: Download only service sheet in CSV (Comma Separated Values) format.
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step4_namfty.jpg)
Step 5: Upload the CSV file into your GaragePlug account. Settings ->Service & Part master ->select service ->upload CSV ->choose file -> UPLOAD
![](https://storage.crisp.chat/users/helpdesk/website/7b6d748690182400/step5_z2cvx3.jpg)
Updated on: 16/05/2022
Thank you!