Using Excel as a Data Source

Submit Search

Using Excel as a Data Source

An Excel file can be imported without having to configure the data source completely by setting Allow Dynamic Excel Loads to True and configuring an Excel template. See "Loading Data via Excel Templates or CSV" in Collecting Data for more information.

Additional Resources

PDF Design_and_Reference_Guide

Design and Reference Guide

D&R Data Sources

Knowledge Base Articles

Comma (,) Delimiters and Indicators in Data Sources
How to Configure Data Source to Import Tab Delimited Files
Error Message : "No valid DataKeys (Scenario / Time) found in Data Source"
How to configure a Data Source to import a space delimited file
How to Set the Data Source Quote Character Setting to a Space
Connecting to a Source System
and more, search the Knowledge Base using the term "data sources"

Navigator Courses

OneStream Essentials: OneStream Administration
OneStream Essentials: Getting Started with OneStream and OneStream Administration Instructor Led
OneStream Essentials: Implementing OneStream
and more, search Navigator courses using the term "data sources"

OneStream Community Forum

Navigator

OneStream Community

Using Excel as a Data Source

Copyright Notice