Data published from your spreadsheet into Cube and data imported into Cube from your source systems (via flat file or direct integration) can be pulled into your spreadsheet anytime using the Fetch Data button in the Spreadsheet add-on.
Whether creating an ad-hoc report or reviewing a budget, fetching data into your spreadsheet couldn't be easier.
1. Make sure your data is up to date
Before fetching data, you'll want to ensure the Cube cloud data is up-to-date. You can check this in your Cube Web portal under Source Data. Click the three dots menu and then Import history:
If it's been a while, run another import for each source system by clicking the import icon. Import time will vary depending on the amount of data being re-synced, especially when running multiple imports; you'll receive an email invitation when it's complete and ready to start fetching to your spreadsheet.
2. Define your range(s)
A range is the designated rows and columns in your spreadsheet that tell Cube what data you'd like to see and how you'd like to see it using the names of your dimensions, tags, formulas, and attributes:
You can select a range on a Cubified report, create a new range, or open an existing template. For help building ranges, see our guide.
3. Click Fetch Data
When all your columns, rows, and filters have been captured in your Spreadsheet add-on, you're ready to hit Fetch Data.
Want to automatically exclude rows without values from your fetch? Toggle the option to Exclude zero rows before fetching.
When you click Fetch Data, your spreadsheet will populate with your Cube data.
Fetch to multiple ranges
Consider adding multiple ranges to your sheet to support fetching and publishing to different areas or pulling multiple data sets into visualizations.
Select multiple ranges to fetch to all of them at the same time.
Want more? Check out this best practices guide for fetching to ensure you're getting the most out of using Cube!