Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By fabar022 on
I have some data on Excel documents, I need to import my data into Drupal and them show the data in tables or chart. What is the most simple way to do that? What do you recommend me?
Comments
Export the data in CSV format
Export the data in CSV format and import it into Drupal using Feeds.
What you do then is up to you, but you could, for example, have Feeds make each row a node, with each column corresponding to a field, and then use Views to display all the nodes in tabular layout.
============================
Resonetrics: Better Tools for Building Brands
http://resonetrics.com
http://technologyformarketers.com
http://kittenassociates.org
http://www.linkedin.com/in/sammooreatresonetrics
_
Depending on how the files are going to be generated, CSVs can be problematic (i usually have lots of issues getting users to format CSVs properly). For when you really do need to import from excel, feeds_xls works great.