Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

Do we have a KB article on using Excel files as a source for an Import? I have formatting questions.

Originally posted by Michael Malandra

6/18/2018

Do we have a KB article on using Excel files as a source for an Import? I have formatting questions.

Data Sources
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    5 years ago
    Originally posted by Chul Smith

    It's the easiest data source - don't need to define any of the dimensions, just ensure that the Allow Dynamic Excel Load is TRUE and put in your xfd ranges in each tab. If you want each tab to be listed as a source, use the Excel formula to pull in the tab name for Source ID.