From Spreadsheets to Graph

Many organizations track their environments in complex Excel or SharePoint spreadsheets. Moving to Rescile is straightforward.

1. Export to CSV

Export your existing spreadsheets to CSV files. Place them in the data/assets/ directory.

2. Normalize Names

Ensure the first column of each CSV represents a unique primary key. Rename the headers to match standard Rescile naming conventions (e.g., use lowercase, underscores).

3. Extract Relationships

If a spreadsheet has a column like “Database Name”, split the unique databases into a new database.csv file, and keep the “database” column in the original application.csv. Rescile will automatically link them.

4. Handle Complex Types

Prefix columns with ~ if you want to force string conversion for fields that look like numbers (e.g., ~version for “2.0”) or fields that contain commas. Prefix columns with _ to prevent accidental auto-linking.