Transitioning to Spendbase for comprehensive SaaS management can be smooth and efficient, especially if you’re migrating from another system where your software and license data is stored in spreadsheet formats like Google Sheets or Microsoft Excel. Spendbase allows you to upload your existing SaaS stack directly via a CSV file.
Preparing Your CSV File
Before uploading your data to Spendbase, you'll need to ensure that your data is properly formatted and saved as a CSV file. Here’s what to do:
- Organize Your Data: Arrange your application data in a spreadsheet with clear headings for each column, such as App Name, Owner, Department, Pricing plan, Quantity, Price, etc.
- Export to CSV: Once your data is organized, export the spreadsheet to a CSV file. In Google Sheets, you can do this by clicking
File
>Download
>Comma-separated values (.csv)
. In Microsoft Excel, chooseFile
>Save As
and selectCSV
from the file format options.
Uploading the CSV File to Spendbase
Spendbase makes the upload process intuitive:
- Navigate to Application page
- Click Upload CSV
- Select Applications import sub-option
- Map fields: literally match the field names from your file onto the similar fields in SB
- Confirm upload: Spendbase processes the CSV file, uploading the data and automatically adding new applications or updating existing ones in your account.
- There you go!
It may take just a little time to upload all apps but usually it occurs in the matter of seconds.
After the upload, review the applications in your Spendbase applications grid to ensure everything has been integrated as expected. You can make manual adjustments if necessary.
Benefits of CSV Upload
- Efficiency: Quickly migrate a large volume of application data into Spendbase, saving time and reducing manual entry errors.
- Simplicity: The straightforward process eliminates the complexity of transitioning to a new SaaS management platform.
- Accuracy: Direct mapping of fields ensures that all data is accurately reflected in Spendbase, enhancing the reliability of your SaaS management.